On Mon, Nov 26, 2012 at 5:05 PM, Shams Khan <shams.khan22@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx> http://www.stuartbishop.net/ -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
