Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings