Re: Validate standby against master

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