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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
