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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
