Steps to switch from Master to standby mode :

From: prakhar jauhari <prak840(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Steps to switch from Master to standby mode :
Date: 2013-05-13 07:23:13
Message-ID: CAEd0_=8=mU9xp0oMrZHox-3zmZ2Zb6r6c5t5G2nfUw1nsw7QTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Hariraman Jayaraj 2013-05-13 11:04:14 Type Conversion Error after migrating from 8.3 to 9.2
Previous Message Joshua D. Drake 2013-05-11 14:03:19 Re: Sr. Postgres DBA