Archiving wal files
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?
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
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.