Alan Hodgson <ahodgson@xxxxxxxxx> writes: > On April 10, 2006 09:28 am, "Just Someone" <just.some@xxxxxxxxx> wrote: >> So my question is: Is what I'm seeing meaning the WAL archiving is >> working? Or should I expect the file to be deleted? > If the file is showing up in your archive target location, it's working. > The file will remain in the pg_xlog directory for some time, and then > eventually be recycled. I'd expect the file to be renamed or deleted at the next checkpoint, so "eventually" is not very long, unless you've increased the checkpoint spacing parameters quite a lot ... regards, tom lane
