Skip site navigation (1) Skip section navigation (2)

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

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode
Date: 2011-03-07 19:24:56
Message-ID: 4D753108.7030503@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
On 07.03.2011 21:20, Magnus Hagander wrote:
> On Mon, Mar 7, 2011 at 20:16, Heikki Linnakangas
> <heikki(dot)linnakangas(at)iki(dot)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...

Hmm, seems reasonable. 'latest' is what you usually want, at least in 
standby mode. Though it would be strange to have a different default 
depending on the value of another setting. Maybe we should change the 
default regardless of standby_mode?

Wë́'d need a magic value to mean the current default behavior, to recover 
to the current timeline. 'current'?

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2011-03-07 19:28:58
Subject: Re: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode
Previous:From: Magnus HaganderDate: 2011-03-07 19:20:58
Subject: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode

pgsql-committers by date

Next:From: Magnus HaganderDate: 2011-03-07 19:28:58
Subject: Re: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode
Previous:From: Magnus HaganderDate: 2011-03-07 19:20:58
Subject: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group