| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Christian Rengstl <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Archiving wal files |
| Date: | 2006-07-25 14:07:37 |
| Message-ID: | 20060725140736.GA18664@surnet.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-07-25 14:49:51 | Re: Beginner's questions about creating a custom data type in PostgreSQL... |
| Previous Message | Germán Hüttemann Arza | 2006-07-25 14:04:44 | Error using OLD and NEW records |