Re: [pgeu-general] Replication failover - Mailing list pgsql-general

On 23.05.2013 03:55, TJ wrote:
>
> We have a few different sets of servers with different versions.
> 9.0.4
> 9.1.4
> 9.2.3
>
> I recently tried to fail-over a set of 9.2.3 servers and server4 did
> notice the timeline change but did not start following it.
> We do not have the recovery_target_timeline set in the recovery.conf
>
> ATM we are not using WAL archiving only streaming.
>
> And server4 is behind server3.
>
> So would we need to setup WAL archiving to achieve this?

Yep. Set up a WAL archive, set recovery_target_timeline='latest', and
use 9.1 or above, and it should work.

- Heikki