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@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".