Andreas Pflug wrote: > Tom Lane wrote: > > >Do we have a TODO for allowing users to > > force switching to a new WAL file segment? > > Together with PITR, this might make sense?
I thought about this, and it would perhaps help, but it would bloat the archive location if used repeatedly, perhaps every minute so you have a recent version. It also might not work on server shutdown because there might not be time to do the archive. I think we are going to need a solution to archive the current file in a different way. -- 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 8: explain analyze is your friend