On Mon, Jan 20, 2014 at 1:53 PM, Granthana Biswas <granth...@zedo.com>wrote:
> Yes we already do that. Count the number of ready wal files. I guess a better place to check would be pg_stat_replication Check this discussion: http://www.postgresql.org/message-id/4f13ed11.6080...@gmail.com Another way is explained in wiki: http://wiki.postgresql.org/wiki/Streaming_Replication $ psql -c "SELECT pg_current_xlog_location()" -h192.168.0.10 (primary host) pg_current_xlog_location -------------------------- 0/2000000 (1 row) $ psql -c "select pg_last_xlog_receive_location()" -h192.168.0.20 (standby host) pg_last_xlog_receive_location ------------------------------- 0/2000000 (1 row) $ psql -c "select pg_last_xlog_replay_location()" -h192.168.0.20 (standby host) pg_last_xlog_replay_location ------------------------------ 0/2000000 (1 row) Best Regards, *Sameer Kumar | Database Consultant* *ASHNIK PTE. LTD.*101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533 M : *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz [image: email patch] This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
<<image002.jpg>>
