Le 11/02/2010 à 16:20:26-0600, Kevin Grittner a écrit > Albert Shih <Albert.Shih@xxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
