Re: pg_xlog

Le 11/02/2010 à 16:20:26-0600, Kevin Grittner a écrit
> Albert Shih <Albert(dot)Shih(at)obspm(dot)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?
>
Thanks for the help

In fact you right, they are some problem about the copy (wrong owner of the
/WAL directory), so the WAL is not copied. That's why I got ... 45000 files
in the pg_xlog.

Thanks for your help.

Regards.

JAS
--
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Téléphone : 01 45 07 76 26/06 86 69 95 71
Heure local/Local time:
Jeu 11 fév 2010 23:42:11 CET