Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 474EA632D07
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 11 Feb 2010 18:25:07 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 47099-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 11 Feb 2010 22:24:42 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from spinlock.commandprompt.com (host-215.commandprompt.net
	[207.173.203.215])
	by mail.postgresql.org (Postfix) with ESMTP id 8A6D3632926
	for <pgsql-admin@postgresql.org>; Thu, 11 Feb 2010 18:24:56 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by spinlock.commandprompt.com (Postfix) with ESMTP id F2C46348038;
	Thu, 11 Feb 2010 14:24:53 -0800 (PST)
Received: from spinlock.commandprompt.com ([127.0.0.1])
	by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1])
	(amavisd-new, port 10024)
	with ESMTP id CBDU8vvnNj0X; Thu, 11 Feb 2010 14:24:53 -0800 (PST)
Received: from [192.168.1.100] (unknown [75.142.159.62])
	by spinlock.commandprompt.com (Postfix) with ESMTPSA id 940C7348034;
	Thu, 11 Feb 2010 14:24:53 -0800 (PST)
Subject: Re: pg_xlog
From: "Joshua D. Drake" <jd@commandprompt.com>
Reply-To: jd@commandprompt.com
To: Albert Shih <Albert.Shih@obspm.fr>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <20100211220907.GA13352@obspm.fr>
References: <20100211220907.GA13352@obspm.fr>
Content-Type: text/plain; charset="UTF-8"
Organization: Command Prompt, Inc.
Date: Thu, 11 Feb 2010 14:24:37 -0800
Message-ID: <1265927077.28400.9.camel@jd-desktop.unknown.charter.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.1 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.525 tagged_above=-10 required=5 tests=AWL=-0.415,
	BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 201002/99
X-Sequence-Number: 33702

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.