Thread: Archiving wal files

Archiving wal files

From
"Christian Rengstl"
Date:
Hi list,

somehow it seems that in my pg_xlog directory not all wal files are deleted after copying them to the archive directory
eventhough the archive_status is done for all of them. 
Is it safe to delete them after they were copied or is it safe to use 'mv' as archive_command?

Thanks!

--
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230


Re: Archiving wal files

From
Alvaro Herrera
Date:
Christian Rengstl wrote:
> Hi list,
>
> somehow it seems that in my pg_xlog directory not all wal files are
> deleted after copying them to the archive directory even though the
> archive_status is done for all of them.  Is it safe to delete them
> after they were copied or is it safe to use 'mv' as archive_command?

No, it is not safe nor necessary.  Leave them alone -- Postgres will
automatically reuse them as needed.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.