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

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode
Дата
Msg-id AANLkTimgQuFzhb79oxp4dtCEcOSRLcXCDW=Rt2ESQiQ2@mail.gmail.com
обсуждение исходный текст
Ответы Re: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: How should the primary behave when the sync standby goes away? Re: Sync Rep v17
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: If recovery_target_timeline is set to 'latest' and standby mode