Re: PITR Archive Recovery plus WIP PITR - Mailing list pgsql-patches

From Simon Riggs
Subject Re: PITR Archive Recovery plus WIP PITR
Date
Msg-id 1089789310.17493.3876.camel@stromboli
Whole thread Raw
In response to Re: PITR Archive Recovery plus WIP PITR  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Wed, 2004-07-14 at 05:45, Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Tom Lane wrote:
> >> I think that judgment is exactly backward.  *Not* having timelines is
> >> what will cause serious and possibly fatal mistakes during restore:
> >> people will hand the wrong xlog files to restore and the software will
> >> be unable to recognize the inconsistency.
>
> > I assume they could just restore from backup and try again.
>
> Sure, if they don't mind losing whatever transactions they processed
> before realizing how broken their database was.  That's not going to be
> an acceptable answer for the sort of installations that need PITR in the
> first place.
>
> I think it's really important to get this right the first time, both for
> reliability's sake and because we are expecting people to write their
> own archiving scripts.  If we change the xlog segment naming convention
> later on, then we will break all those scripts.
>

I agree, but I'm going to have a rest day while people test what is
already there in case there are further code changes....which nods
towards both of your concerns.

BTW, one test last night broke because of the lack of timelines...

Best Regards, Simon Riggs


pgsql-patches by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Fixes for 3 bugs in pg_dump
Next
From: "Magnus Hagander"
Date:
Subject: Re: serverlog rotation/functions