A J <s5aly@yahoo.com> writes:
> What are the various ways in which I can validate that a standby (new or
> existing) is caught-up with the master ? For streaming replication setup in
> v9.x
You could use repmgr to monitor your standby:
http://repmgr.org/https://github.com/greg2ndQuadrant/repmgr
postgres@node2 $ psql -x -d pgbench -c "SELECT * FROM repmgr_test.repl_status"
-[ RECORD 1 ]-------------+------------------------------
primary_node | 1
standby_node | 2
last_monitor_time | 2011-02-23 08:19:39.791974-05
last_wal_primary_location | 0/1902D5E0
last_wal_standby_location | 0/1902D5E0
replication_lag | 0 bytes
apply_lag | 0 bytes
time_lag | 00:26:13.30293
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support