On 24 May 2016 at 09:12, Michael Paquier <michael.paqu...@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