Re: LSN as a recovery target - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: LSN as a recovery target
Date
Msg-id CAMsr+YGsp=uJfyzD6VGk6wBpDhVUOrS1U6-gt8P4Qg+33njo-w@mail.gmail.com
Whole thread Raw
In response to LSN as a recovery target  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: LSN as a recovery target  (Michael Paquier <michael.paquier@gmail.com>)
List 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 by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PATCH: Batch/pipelining support for libpq
Next
From: Stephen Frost
Date:
Subject: Re: Typo in 001_initdb.pl