Re: Steps to switch from Master to standby mode :

I think that you need to create a new base backup from the new master to
make the old master a standby server. I usually do this using rsync, so
that it takes as fast as possible, but you could also use a tool like
http://www.repmgr.org/

Regards,
Strahinja

On Mon, May 13, 2013 at 9:23 AM, prakhar jauhari <prak840(at)gmail(dot)com> wrote:

> 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
>