[check_postgres] hot standby delay
Filip Rembiałkowski
filip.rembialkowski at gmail.com
Sun May 19 15:41:14 UTC 2013
Hi
Subject action worked for me when I was using streaming replication,
When I switched same pair of servers to WAL shipping, it always returns the
master offset (a large number).
But I can calculate real delay value manually, by substracting
pg_last_xlog_replay_location() on slave from pg_current_xlog_location() on
master.
It would be nice and useful if the action returned useful value of delay
regardless if it is streaming or log shipping.
What do you think?
Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20130519/570e196a/attachment.html>
More information about the Check_postgres
mailing list