[GENERAL] Monitoring Streaming Replication in 9.2

Newb question here. I have streaming replication working with 9.2 and I'm using Bucardo's check_postgres.pl to monitor replication. I see that it runs this query on the slave: SELECT pg_last_xlog_receive_location() AS receive, pg_last_xlog_replay_location() AS replay That returns hex, which is th

[GENERAL] Monitoring Streaming Replication in 9.2

Newb question here. I have streaming replication working with 9.2 and I'm using Bucardo's check_postgres.pl to monitor replication. I see that it runs this query on the slave: SELECT pg_last_xlog_receive_location() AS receive, pg_last_xlog_replay_location() AS replay That returns hex, which is th

Re: [GENERAL] Monitoring Streaming Replication in 9.2

Hi, Hereis the blog which has good explanation about this. If you want to find the lag in seconds, then you need to execute something like below. SELECT pg_last_xact_replay_timestamp() - now(); Regards, Dinesh manojadinesh