Steps to switch from Master to standby mode :

Поиск
Список
Период
Сортировка
От prakhar jauhari
Тема Steps to switch from Master to standby mode :
Дата
Msg-id CAEd0_=8=mU9xp0oMrZHox-3zmZ2Zb6r6c5t5G2nfUw1nsw7QTg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Steps to switch from Master to standby mode :
Список pgsql-admin
Hi all,

I have been trying to setup Postgres 9.2 in HA using streaming replication and base backup.
There is no problem in switching from:
Standby -> Master using the trigger file mechanism provided by postgres.

The problem comes when switching from:
Master -> Stanbdy : I try to set up Streaming replication from the new standby to the new Master,
but replication doesn't start, rather i find the following error in postgres logs

"FATAL:  timeline 2 of the primary does not match recovery target timeline 1".

Is there any way the timeline can be bumped up to the correct number on the new standby, without taking
base backup. And is it safe to use the method described in
http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-timeline-switch-of-slave-node-without-archives/
to bump up the timeline.

regards,
Prakhar

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Sr. Postgres DBA
Следующее
От: Hariraman Jayaraj
Дата:
Сообщение: Type Conversion Error after migrating from 8.3 to 9.2