Timeline Issue

From: Selva manickaraja <mavles78(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Timeline Issue
Date: 2011-02-17 01:29:44
Message-ID: AANLkTikSfLOAAOBddJ-Rr2tcjbuXR_4CjHeHG2ys+5G7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear All,

We have a primary running continous archiving to a secondary. We managed to
test fail-over to the secondary by stopping the database in the primary.
Then some transactions were tested in the secondary. It was acting well as a
primary to accept both read and write.

Now we want to revert this acting primary back to secondary and bring up the
actual primary. We know that the secondary had gone out of synch in ahead of
primary. So we do a PITR in this secondary before the time when the initial
primary was brought down. Now the primary is up and the secondary is brought
up as hot-standby. The secondary complaints that it cannot recover because
its Timeline 2 does not match with the Timeline 1 of the primary.

How can this be resolved?

Thank you.

Regards,

Selvam

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Mead 2011-02-17 01:36:57 Re: Timeline Issue
Previous Message Bruce Momjian 2011-02-16 21:24:18 Re: LC_COLLATE and pg_upgrade