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? > so can I just do > > postgresql stop > rm f pg_xlog/* > postgresql start No. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
