-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Hi, 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. My recovery.conf for slaves: standby_mode = on restore_command = 'gunzip < /archives/wal/%f > %p' recovery_target_timeline = 'latest' primary_conninfo = 'host=PGSQL_FRONTEND_NAME port=5432 user=PGSQL_RECOVERY_USER password=PGSQL_RECOVERY_PASS' Appropriate postgresql.conf: wal_level = replica archive_mode = on archive_command = 'test ! -f /archives/wal/%f && gzip < %p > /archives/wal/%f' archive_timeout = 15min Regards, Michael Cassaniti -----BEGIN PGP SIGNATURE----- iG0EAREIAB0WIQT0DIHSqEo48gI0VT9pF1oDt4Q+5wUCXInRqgAKCRBpF1oDt4Q+ 5661AN4nRJPXF/M0ZoLg3JVH8f0UsO1WlouHruIRMnsnAN4q9x4G6S4RcobUm5Kh qTNOD2F3v6A8ng4ABFpm =5qCA -----END PGP SIGNATURE-----
