Re: Point in Time Recovery

Simon Riggs wrote:
> On Sat, 2004-07-17 at 00:57, Bruce Momjian wrote:
> > OK, I think I have some solid ideas and reasons for them.
> > 
> 
> Sorry for taking so long to reply...
> 
> > First, I think we need server-side functions to call when we start/stop
> > the backup.  The advantage of these server-side functions is that they
> > will do the required work of recording the pg_control values and
> > creating needed files with little chance for user error.  It also allows
> > us to change the internal operations in later releases without requiring
> > admins to change their procedures.  We are even able to adjust the
> > internal operation in minor releases without forcing a new procedure on
> > users.
> 
> Yes, I think we should go down this route. ....there's a "but" and that
> is we don't absolutely need it for correctness....and so I must decline
> adding it to THIS release. I don't imagine I'll stop be associated with
> this code for a while yet....
> 
> Can we recommend that users should expect to have to call a start and
> end backup routine in later releases? Don't expect you'll agree to
> that..

I guess my big question is that if we don't do this for 7.5 how will
people doing restores know if the xid they specify is valid for the
backup they used.  If we recover to most recent time, is there any check
that will tell them their backup is invalid because there are no archive
records that span the time of their backup?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073