[check_postgres] negative result from hot_standby_delay action

[Guillaume Lelarge]

On Tue, 2012-12-18 at 16:45 -0800, Selena Deckelmann wrote:
> On Sun, Dec 16, 2012 at 2:23 PM, Guillaume Lelarge
> <guillaume at lelarge.info> wrote:
>         On Thu, 2012-11-15 at 19:48 +0100, Filip Rembiałkowski wrote:
>         > Hello.
>         >
>         > hot_standby_delay sometimes returns negative value.
>         >
>         > I know the reason behind this - quite naturally the delay
>         between querying
>         > master ad slave can cause this.
>         >
>         > I think it makes sense to fix it in check_postgres.pl by
>         something like
>         > $result = 0 if $result < 0;
>         > All in all, it is logically impossible that slave has
>         processed more WAL
>         > segments than master :-)
>         >
>         
>         
>         I guess you're right. If nobody objects, I'll commit a patch
>         doing this
>         this week.
> 
> Just ran into this today, so I'd appreciate the patch :)
> 

Done. It works for me, but I would appreciate any feedback.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com