Re: pg_standby for 8.2 (with last restart point) - Mailing list pgsql-hackers

From Gurjeet Singh
Subject Re: pg_standby for 8.2 (with last restart point)
Date
Msg-id 65937bea0803271848g5cc849f0x9f9e81f3abe06e34@mail.gmail.com
Whole thread Raw
In response to Re: pg_standby for 8.2 (with last restart point)  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: pg_standby for 8.2 (with last restart point)  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-hackers
On Fri, Mar 28, 2008 at 3:56 AM, Greg Smith <gsmith@gregsmith.com> wrote:
On Fri, 28 Mar 2008, Gurjeet Singh wrote:

> For PG versions < 8.3 (specifically 8.2) I wanted the %r parameter to be
> substituted by the last restart point, just as the recovery code does in
> > 8.3. I assumed there would be objections to it (else it would have
> already been there in 8.2.x)

The idea to add this feature didn't show up before 8.2 was released, it
came up during the 8.3 development cycle.  This project doesn't make
functional changes to stable releases, that's the reason why 8.2 will
never get patched to add the %r feature.

I completely understand that, but still was hoping that we'd change that.
 


Cute script though.  I know people have asked about simulating this
behavior, and I don't recall a good sample solution being presented before
yours.

Thanks.

Is there anybody who sees any problem with this? Specifically, internals wise, does 8.2 also give the same guarantee 8.3 does w.r.t restart point? And consequently, is it safe to go ahead with this script in a production environment?

Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

Mail sent from my BlackLaptop device

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: TODO Item: Consider allowing control of upper/lower case folding of unquoted, identifiers
Next
From: Bruce Momjian
Date:
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)