[check_postgres] ERROR: Cannot test replication: values are not the same

[Greg Sabino Mullane]

On Fri, Dec 05, 2014 at 04:25:28PM +0530, Juned Khan wrote:
> Greg, I think problem is, sometimes it takes too long to update values so
> tried with increasing timeout parameter.
> 
> root at db02:/usr/lib/nagios/plugins# ./check_nrpe -H server-ip -c
> check_replication_astpp --timeout=20
> CHECK_NRPE: Socket timeout after 20 seconds.
> root at db02:/usr/lib/nagios/plugins# ./check_nrpe -H server-ip -c
> check_replication_astpp --timeout=30
> ERROR: Cannot test replication: values are not the same

How long until this message appears in the command where the timeout 
is 30? Based on these two messages, I would say your replication is 
not working as it should, or at least is not firing right away. Is 
there a trigger on the table in question? If you manually change 
it on server one via psql, can you get an idea of how long it takes 
to have the value changed on server two?

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20141206/dc79c2f2/attachment.sig>