Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode
Date
Msg-id AANLkTimgQuFzhb79oxp4dtCEcOSRLcXCDW=Rt2ESQiQ2@mail.gmail.com
Whole thread Raw
Responses Re: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode
List pgsql-hackers
On Mon, Mar 7, 2011 at 20:16, Heikki Linnakangas
<heikki.linnakangas@iki.fi> wrote:
> If recovery_target_timeline is set to 'latest' and standby mode is enabled,
> periodically rescan the archive for new timelines, while waiting for new WAL
> segments to arrive. This allows you to set up a standby server that follows
> the TLI change if another standby server is promoted to master. Before this,
> you had to restart the standby server to make it notice the new timeline.

Can we make recovery_target_timeline='latest' the default when we are
in standby mode? That would suddenly make it a lot easier to "repoint
a slave" after a switchover...

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: How should the primary behave when the sync standby goes away? Re: Sync Rep v17
Next
From: Heikki Linnakangas
Date:
Subject: Re: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode