Re: [v9.2] Start new timeline for PITR

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: [v9.2] Start new timeline for PITR
Дата
Msg-id 4DF272BD.3090309@enterprisedb.com
обсуждение исходный текст
Ответ на Re: [v9.2] Start new timeline for PITR  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 10.06.2011 22:34, Robert Haas wrote:
> On Fri, Jun 10, 2011 at 2:53 PM, Josh Berkus<josh@agliodbs.com>  wrote:
>>> Let's imagine we're taking filesystem snapshots each day by whatever
>>> means.  We're also archiving xlogs, but only have space for 48 hours'
>>> worth.  Now we want to recover to 3 days ago, but there are no WALs
>>> from that time, so we do a crash recovery from the filesystem
>>> snapshot.  Doing continuous archiving from this conflicts with the
>>> existing WALs, which we solve by creating a new timeline.
>>
>> How is this different from just changing the recovery_command?
>
> *scratches head*
>
> How is it the same?

Creating a dummy recovery.conf with bogus recovery_command would do the 
trick.

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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [v9.2] Start new timeline for PITR
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: [v9.2] Start new timeline for PITR