Re: [pgeu-general] Replication failover

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: [pgeu-general] Replication failover
Дата
Msg-id 519DE3A3.1010209@vmware.com
обсуждение исходный текст
Ответ на Re: [pgeu-general] Replication failover  (TJ <tj@melodicninja.co.uk>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: TJ
Дата:
Сообщение: Re: [pgeu-general] Replication failover
Следующее
От: Wojciech Skaba
Дата:
Сообщение: update ARRAY of COMPOSITE TYPE of text