> > > > We are already using the following query: > > SELECT CASE WHEN pg_last_xlog_receive_location( > ) = pg_last_xlog_replay_location() THEN 0 ELSE EXTRACT (EPOCH FROM now() - > pg_last_xact_replay_timestamp()) END AS log_delay; > > This is (delay) not the correct thing to monitor.
We cannot use pg_xlog_location_diff as we use postgresql 9.1. > > You can still use the other two methods I mentioned. Regards Sameer Ashnik Pte Ltd, Singapore
