More issues: promoting intermediate standby breaks replication.
To be a bit blunt here, has anyone tested cascading replication *at all*
before this?
So, same setup as previous message.
1. Shut down master-master.
2. pg_ctl promote master-replica
3. replication breaks. error message on replica-replica:
FATAL: timeline 2 of the primary does not match recovery target timeline 1
4. No amount of adjustment on replica-replica will get it replicating
again.
Note that replica-replica was configured with:
recovery_target_timeline = 'latest'
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com