[check_postgres] hot standby delay

[Filip Rembiałkowski]

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>