On Mon, Nov 26, 2012 at 5:05 PM, Shams Khan <shams.khan22@gmail.com> wrote:
> I want to know the ways to monitor the replication, whether the master and
> slave server are sync.
On the slave, run "SELECT now() - pg_last_xact_replay_timestamp() AS
time_lag;". That tells you how far behind in time the slave is.
> My question is how do we read these numbers(17A/342A6F78 and 17A/34366C30) I
> never got the same results on both servers. Is that mean slave is not synced
> with master?
With asynchronous replication, the slave will always lag behind the
master. The query I posted above will tell you by how much.
--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/