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

From Bruce Momjian
Subject Re: PITR Archive Recovery plus WIP PITR
Date
Msg-id 200407141450.i6EEotI08466@candle.pha.pa.us
Whole thread Raw
In response to Re: PITR Archive Recovery plus WIP PITR  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PITR Archive Recovery plus WIP PITR  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
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.

We don't have anything hardcoded based on those file names, at last in
PostgreSQL.

--
  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, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: serverlog rotation/functions
Next
From: Tom Lane
Date:
Subject: Re: PITR Archive Recovery plus WIP PITR