Re: Archiving wal files - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Archiving wal files
Date
Msg-id 20060725140736.GA18664@surnet.cl
Whole thread Raw
In response to Archiving wal files  ("Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de>)
List 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.

pgsql-general by date:

Previous
From: Christian Schoenebeck
Date:
Subject: Re: CASE statement and SETOF values
Next
From: Michael Fuhr
Date:
Subject: Re: Lock changes with 8.1 - what's the right lock?