Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] Re: pg_current_xlog*_location andpg_stat_replication.replay_location > 0 for synced replication connection - Mailing list pgsql-admin

From Ranjan Gajare
Subject [ADMIN] Re: pg_current_xlog*_location andpg_stat_replication.replay_location > 0 for synced replication connection
Date
Msg-id 1504598538845-0.post@n3.nabble.com
Whole thread Raw
In response to [ADMIN] Re: pg_current_xlog*_location and pg_stat_replication.replay_location> 0 for synced replication connection  (Aleksander Kamenik <aleksander.kamenik@gmail.com>)
List pgsql-admin
Tree view 
You could query pg_stat_replication on the master, compare sent_location
and replay_location, and if they are the same, the replication is in sync.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: [ADMIN] wal_level not changing
Next
From: Peter
Date:
Subject: [ADMIN] database corruption on disk-full?