Re: pg_current_xlog*_location and pg_stat_replication.replay_location > 0 for synced replication connection

From: Ranjan Gajare <ranjangajare(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_current_xlog*_location and pg_stat_replication.replay_location > 0 for synced replication connection
Date: 2017-09-05 08:02:18
Message-ID: 1504598538845-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter 2017-09-05 09:21:46 database corruption on disk-full?
Previous Message Achilleas Mantzios 2017-09-05 07:38:43 Re: wal_level not changing