pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedValidate standby against master
2+ messages / 2 participants
[nested] [flat]
* Validate standby against master
@ 2011-08-18 21:41 A J <s5aly@yahoo.com>
2011-08-21 19:38 ` Re: Validate standby against master Dimitri Fontaine <dimitri@2ndQuadrant.fr>
0 siblings, 1 reply; 2+ messages in thread
From: A J @ 2011-08-18 21:41 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Validate standby against master
2011-08-18 21:41 Validate standby against master A J <s5aly@yahoo.com>
@ 2011-08-21 19:38 ` Dimitri Fontaine <dimitri@2ndQuadrant.fr>
0 siblings, 0 replies; 2+ messages in thread
From: Dimitri Fontaine @ 2011-08-21 19:38 UTC (permalink / raw)
To: A J <s5aly@yahoo.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-08-21 19:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-18 21:41 Validate standby against master A J <s5aly@yahoo.com>
2011-08-21 19:38 ` Dimitri Fontaine <dimitri@2ndQuadrant.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox