Postgres Pro
Downloads
Home   >   mailing lists

Re: Notification or action when WAL archives fully restored andstreaming replication started - Mailing list pgsql-general

From Michael Paquier
Subject Re: Notification or action when WAL archives fully restored andstreaming replication started
Date
Msg-id 20190314041019.GF3493@paquier.xyz
Whole thread Raw
In response to Re: Notification or action when WAL archives fully restored andstreaming replication started  (Michael Cassaniti <m.cassaniti@gmail.com>)
Responses Re: Notification or action when WAL archives fully restored andstreaming replication started  (Michael Cassaniti <m.cassaniti@gmail.com>)
List pgsql-general
Tree view 
On Thu, Mar 14, 2019 at 02:59:38PM +1100, Michael Cassaniti wrote:
> I've got master/slave replication setup between a few hosts. At any
> point a slave could become a master. I've got appropriate locking in
> place using an external system so that only one master can exist at a
> time. I'm having trouble determining when my slaves are in sync with the
> current master so that they can be a candidate for promotion. I want
> some form of indicator _without reading a log_ when streaming
> replication has started.

pg_stat_replication on the primary, no?  Here is its documentation:
https://www.postgresql.org/docs/11/monitoring-stats.html#MONITORING-STATS-VIEWS
--
Michael
Attachment

pgsql-general by date:

Previous
From: Michael Cassaniti
Date:
Subject: Re: Notification or action when WAL archives fully restored andstreaming replication started
Next
From: Thomas Munro
Date:
Subject: Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes