[check_postgres] hot_standby_delay parameters

[Collin Peters]

Hello,

I have just setup streaming replication on our production server and am
adding the hot_standby_delay check to our existing Nagios install (already
using Check_postgres)

I don't quite follow from the instructions what I should be putting in the
check for the warning/critical values.  What value exactly is the plugin
returning?

Can someone also verify the following syntax for the check (from our
staging server):
nagios at staging-postgres1:~$
/usr/lib/nagios/plugins/postgres/check_postgres_hot_standby_delay  -db
intouch_staging_db -H 192.168.80.182,192.168.80.184 -u nagios -w 1 -c 2
POSTGRES_HOT_STANDBY_DELAY OK: DB "intouch_staging_db"
(host:192.168.80.182) 0 | time=0.05s replay_delay=0;1;2
 receive-delay=0;1;2

192.168.80.182 is the master (staging-postgres1) and 192.168.80.184 is the
slave.

So specifically, the warning/critical values of 1/2, are these totally off
base?  Is this number of transactions behind?  Bytes?


--
Collin Peters
cpeters at intouchfollowup.com
(206) 855-6656 (Direct Line)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20121217/1245e71d/attachment.html>