Re: Why we really need timelines *now* in PITR

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why we really need timelines *now* in PITR
Дата
Msg-id 399.1090274291@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why we really need timelines *now* in PITR  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> The crucial time is when re-running recoveries repeatedly and if we
> write the manual with sufficient red ink then we'll avoid this. But
> heck, not having your history file is only as bad as not having added
> timelines in the first place. Not great, just more care required.

Yeah, you only really need them when you are hip-deep in repeated
recovery retries.

If you haven't gotten to my later proposal yet, the history files will
be plain text and it'd be at least theoretically possible for someone to
reconstruct one by hand if needed.  All you need to have is the sequence
of parent timeline IDs, which you could reconstruct in most cases by
looking at the archived WAL files.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Why we really need timelines *now* in PITR
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Why we really need timelines *now* in PITR