Timeline Issue

Поиск
Список
Период
Сортировка
От Selva manickaraja
Тема Timeline Issue
Дата
Msg-id AANLkTikSfLOAAOBddJ-Rr2tcjbuXR_4CjHeHG2ys+5G7@mail.gmail.com
обсуждение исходный текст
Ответы Re: Timeline Issue  (Scott Mead <scottm@openscg.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: LC_COLLATE and pg_upgrade
Следующее
От: Scott Mead
Дата:
Сообщение: Re: Timeline Issue