Re: Strange issues with 9.2 pg_basebackup & replication

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