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