[check_postgres] negative result from hot_standby_delay action
Guillaume Lelarge
guillaume at lelarge.info
Thu Dec 27 09:19:34 UTC 2012
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
More information about the Check_postgres
mailing list