Re: LSN as a recovery target

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: LSN as a recovery target
Дата
Msg-id CAMsr+YGsp=uJfyzD6VGk6wBpDhVUOrS1U6-gt8P4Qg+33njo-w@mail.gmail.com
обсуждение исходный текст
Ответ на LSN as a recovery target  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: LSN as a recovery target  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
On 24 May 2016 at 09:12, Michael Paquier <michael.paquier@gmail.com> wrote:
Hi all,

Today somebody has pointed me out that it could be interesting to be
able to recovery up to a given LSN position. One argument behind that
was to allow a maximum of things to recover up to the point where a
relation block got corrupted by a specific record because of a broken
segment. So that would be simply having recovery_target_lsn in
recovery.conf similar to what we have now.
Thoughts?


Sounds useful, if somewhat niche. I've needed that in the past, and just zeroed the WAL segment after the end of the target record. Not super user-friendly. 


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: PATCH: Batch/pipelining support for libpq
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Typo in 001_initdb.pl