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 <prak...@gmail.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 >