Re: Recovery target 'immediate' - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Recovery target 'immediate'
Date
Msg-id CAB7nPqSU6O+COCq5jSMdKfddNHfWtKmH0_3RkRNX6Ng2Y4gRUg@mail.gmail.com
Whole thread Raw
In response to Re: Recovery target 'immediate'  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Recovery target 'immediate'  (Cédric Villemain <cedric@2ndquadrant.com>)
List pgsql-hackers
<div dir="ltr"><br /><div class="gmail_extra"><br /><br /><div class="gmail_quote">On Fri, May 3, 2013 at 8:56 AM,
BruceMomjian <span dir="ltr"><<a href="mailto:bruce@momjian.us" target="_blank">bruce@momjian.us</a>></span>
wrote:<br/><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div
class="im">OnThu, May  2, 2013 at 09:31:03AM +0200, Magnus Hagander wrote:<br /> > Actually, there is - I hear it
quiteoften from people not so<br /> > experienced in PostgreSQL. Though in fairness, I'm not entirely sure<br />
>the new syntax would help - some of those need a tool to do it for<br /> > them, really (and such tools exist, I
believe).<br/> ><br /> > That said, there is one property that's very unclear now and that's<br /> > that you
canonly set one of recovery_target_time, recovery_target_xid<br /> > and recovery_target_name. But they can be
freelycombined with<br /> > recovery_target_timeline and recovery_target_inclusive. That's quite<br /> >
confusing.<br/> ><br /> ><br /> ><br /> > > This changes the existing API which will confuse people that
knowit<br /> > > and invalidate everything written in software and on wikis as to how<br /> > > to do it.
Thatmeans all the "in case of fire break glass"<br /> > > instructions are all wrong and need to be rewritten and
retested.<br/> ><br /> > Yes, *that* is the main reason *not* to make the change. It has a<br /> > pretty bad
costin backwards compatibility loss. There is a gain, but<br /> > I don't think it outweighs the cost.<br /><br
/></div>So,is there a way to add this feature without breaking the API?<br /></blockquote>Yes, by adding a new
parameterexclusively used to control this feature, something like recovery_target_immediate = 'on/off'.<br /></div>--
<br/>Michael<br /></div></div> 

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Remaining beta blockers
Next
From: Michael Paquier
Date:
Subject: Re: \watch stuck on execution of commands returning no tuples