Re: pg_xlog

Albert Shih <Albert.Shih@obspm.fr> wrote:

> How can I clean up the pg_xlog directory ?
>
> I've 710 go of those file.
>
> I've archive_mode on but not in the pg_xlog directory
> I've something like
>
> archive_mode = on               # allows archiving to be done
> archive_command = 'cp -i %p /databases/Archives/WAL/%f </dev/null'

It will keep each WAL file until your archive command which is
supposed to copy it completes with an exit code of zero.  It sounds
like that's not happening.  What does that destination directory
look like?  What messages are you seeing in your log files?

> so can I just do
>
>     postgresql stop
>     rm f pg_xlog/*
>     postgresql start

No.

-Kevin