Re: LSN as a recovery target

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Christoph Berg <myon(at)debian(dot)org>, Craig Ringer <craig(at)2ndquadrant(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LSN as a recovery target
Date: 2016-05-24 16:32:12
Message-ID: CAB7nPqRvG-6vQW8AmcgCju16x=n7pv=vXNbZQMgSEyeY67u7dg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, May 24, 2016 at 9:29 AM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
> Christoph Berg wrote:
>> Re: Michael Paquier 2016-05-24 <CAB7nPqQRXsC8=ozh6GpjLnpZ=MeooUZOaAbzx28n2bjSMv2B4g(at)mail(dot)gmail(dot)com>
>> > Yeah, that's really something that covers only a narrow case, though
>> > if we don't have it when we need it we're limited to some hacks.
>> > Perhaps people who have the advanced level to use such a thing have
>> > the level to use hacks anyway..
>>
>> I'd think recovery_target_lsn would be more useful in practice than
>> the existing recovery_target_xid. So I don't see why it shouldn't just
>> be added, also given it's likely very unobtrusive to do so.
>
> Also, see
> http://www.postgresql.org/message-id/56BD0E4E.5050503@2ndquadrant.com

Looking at xlog.c it is not that complicated, and we could add tests
in 003_recovery_targets.pl at the same time. Perhaps somebody looking
for a first participation would be interested in this small project?
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2016-05-24 16:39:58 Re: pg_dump -j against standbys
Previous Message Alvaro Herrera 2016-05-24 16:29:21 Re: LSN as a recovery target