From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: A J <s5aly@yahoo.com>
Cc: PG Admin <pgsql-admin@postgresql.org>
Subject: Re: Validate standby against master
Date: Sun, 21 Aug 2011 21:38:26 +0200
Message-ID: <m2ippqv9l9.fsf@2ndQuadrant.fr> (raw)
In-Reply-To: <1313703712.75602.YahooMailNeo@web120004.mail.ne1.yahoo.com>
References: <1313703712.75602.YahooMailNeo@web120004.mail.ne1.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dimitri@2ndQuadrant.fr, s5aly@yahoo.com
Subject: Re: Validate standby against master
In-Reply-To: <m2ippqv9l9.fsf@2ndQuadrant.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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