[check_postgres] check_hot_standby_delay question
Guillaume Lelarge
guillaume at lelarge.info
Tue Feb 8 22:56:08 UTC 2011
Le 08/02/2011 17:17, bricklen a écrit :
> [...]
> First of all, let me congratulate and thank you for a great set of
> tools -- we use Bucardo tool and the Nagios checks extensively in our
> organization, Neverblue Media.
>
> We upgraded our production databases to postgresql 9 a couple weeks
> ago, and set up a Hot Standby system shortly after. The question I
> have relates to the "check_hot_standby_delay" check: I can't seem to
> puzzle out what the return value corresponds to when it calculates the
> delta between the master and the slave WAL offsets. Is the returned
> value the number of transactions that have not yet been applied to the
> standby? Microseconds? I've checked out transaction IDs, and the
> numbers I'm getting don't seem to be anywhere in the same range as the
> return value from the check.
>
Nope, it is a number of bytes not yet applied to the slave.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
More information about the Check_postgres
mailing list