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:
signature.asc
Description: PGP signature
