From: Joshua D. Drake <jd@commandprompt.com>
To: Albert Shih <Albert.Shih@obspm.fr>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_xlog
Date: Thu, 11 Feb 2010 14:24:37 -0800
Message-ID: <1265927077.28400.9.camel@jd-desktop.unknown.charter.com> (raw)
In-Reply-To: <20100211220907.GA13352@obspm.fr>
References: <20100211220907.GA13352@obspm.fr>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, Albert.Shih@obspm.fr
Subject: Re: pg_xlog
In-Reply-To: <1265927077.28400.9.camel@jd-desktop.unknown.charter.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox