Re: Point in time recovery + replication

Поиск
Список
Период
Сортировка
От prakhar jauhari
Тема Re: Point in time recovery + replication
Дата
Msg-id CAEd0_=8Y7skDyjuZqqsKVL=uSYhi9kp9Fo37U7QBTzOW97hHQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Point in time recovery + replication  (Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>)
Список 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


On Mon, May 13, 2013 at 7:35 PM, Gabriele Bartolini <gabriele.bartolini@2ndquadrant.it> wrote:
Hi German,

Il 09/05/13 17:45, German Becker ha scritto:
> Do I need to get a new copy of the primary to continue the replication?
Yes. At that point, it is a completely different server with its own new
life. :)

Ciao,
Gabriele

--
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Предыдущее
От: Gabriele Bartolini
Дата:
Сообщение: Re: Point in time recovery + replication
Следующее
От: Nicolas Zin
Дата:
Сообщение: select * from pg_stat_bgwriter slow