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

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [v9.2] Start new timeline for PITR
Дата
Msg-id 4DF2683D.9010404@agliodbs.com
обсуждение исходный текст
Ответ на Re: [v9.2] Start new timeline for PITR  (David Fetter <david@fetter.org>)
Ответы Re: [v9.2] Start new timeline for PITR  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
David,

> 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?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Small SSI issues
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUG] Denormal float values break backup/restore