Re: PITR Archive Recovery plus WIP PITR

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