Jim C. Nasby wrote: > On Mon, Mar 27, 2006 at 09:28:43AM -0800, Sriram Dandapani wrote: > > I was referring to the logs in the archive folder specified when WAL > > archiving is turned on...not the pg_xlog folder. > > > > I assume postgres will not use the logs in the archive folder > > Correct. And I believe if you have PITR enabled PostgreSQL also won't > re-use WAL names, though I'm not positive on that one.
PostgreSQL never reuses WAL _names_ (since initdb), it only reuses WAL files by renaming. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match