Re: LSN as a recovery target

On 24 May 2016 at 09:12, Michael Paquier <michael(dot)paquier(at)gmail(dot)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