| From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
|---|---|
| To: | TJ <tj(at)melodicninja(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [pgeu-general] Replication failover |
| Date: | 2013-05-23 09:38:43 |
| Message-ID: | 519DE3A3.1010209@vmware.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgeu-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Carlson | 2013-05-24 21:46:13 | restrictions on pg_cancel_backend |
| Previous Message | TJ | 2013-05-23 07:55:28 | Re: [pgeu-general] Replication failover |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wojciech Skaba | 2013-05-23 09:40:37 | update ARRAY of COMPOSITE TYPE of text |
| Previous Message | TJ | 2013-05-23 07:55:28 | Re: [pgeu-general] Replication failover |