From: | Michael Cassaniti <m(dot)cassaniti(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Notification or action when WAL archives fully restored and streaming replication started |
Date: | 2019-03-14 03:59:38 |
Message-ID: | 8aee6f5f-6ed8-ed96-f1f4-ec8a38305eed@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2019-03-14 04:10:19 | Re: Notification or action when WAL archives fully restored and streaming replication started |
Previous Message | Rene Romero Benavides | 2019-03-13 22:32:57 | Re: PostgreSQL temp table blues |