On Thu, 2010-02-11 at 23:09 +0100, Albert Shih wrote: > Hi all > > 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' > > so can I just do > > postgresql stop > rm f pg_xlog/*
No. > postgresql start > > Regards. I strongly suggest using something like walmgr or pitrtools to manage this. Walmgr is part of skytools, pitrtools can be found here: https://projects.commandprompt.com/public/pitrtools Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
