Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id AC1816323A4
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 11 Feb 2010 18:20:44 -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 45918-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 11 Feb 2010 22:20:20 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by mail.postgresql.org (Postfix) with ESMTP id D80E4632926
	for <pgsql-admin@postgresql.org>; Thu, 11 Feb 2010 18:20:33 -0400 (AST)
Received: from Courts-MTA by gw.wicourts.gov
	with Novell_GroupWise; Thu, 11 Feb 2010 16:20:31 -0600
Message-Id: <4B742E4A020000250002F1F4@gw.wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 8.0.1 
Date: Thu, 11 Feb 2010 16:20:26 -0600
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Albert Shih" <Albert.Shih@obspm.fr>,<pgsql-admin@postgresql.org>
Subject: Re: pg_xlog
References: <20100211220907.GA13352@obspm.fr>
In-Reply-To: <20100211220907.GA13352@obspm.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.468 tagged_above=-10 required=5 tests=AWL=0.131,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201002/98
X-Sequence-Number: 33701

Albert Shih <Albert.Shih@obspm.fr> 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