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

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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
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:28:58
Message-ID: AANLkTi=Ekrs5TPtLPQ2nBrtDR5czSNavQnLkQYaejKT5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
On Mon, Mar 7, 2011 at 20:24, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> 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?

Seems like a much narrower usecase in ordinary recovery mode, but we
could definitely change both..


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

I didn't realize we didn't already have that. In principle, i think we
should *always* be able to specify in a config file whatever comes out
as a default. There should be no magic behavior that cannot be
explicitly specified.

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

In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-03-07 19:31:18
Subject: Re: [HACKERS] Sync rep doc corrections
Previous:From: Heikki LinnakangasDate: 2011-03-07 19:24:56
Subject: Re: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode

pgsql-committers by date

Next:From: Simon RiggsDate: 2011-03-07 20:11:17
Subject: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode
Previous:From: Heikki LinnakangasDate: 2011-03-07 19:24:56
Subject: Re: 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