X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D7FCE9DCC15 for ; Tue, 7 Mar 2006 11:11:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38353-03 for ; Tue, 7 Mar 2006 11:11:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by postgresql.org (Postfix) with ESMTP id 4AD0A9DCB94 for ; Tue, 7 Mar 2006 11:11:14 -0400 (AST) Received: obelix 172.31.0.1 from 172.31.1.4 172.31.1.4 via HTTP with MS-WebStorage 6.0.6249 Received: from panoramix by obelix; 07 Mar 2006 16:11:18 +0100 Subject: Re: Can I delete all WAL logfiles if the database is From: Joost Kraaijeveld To: Tom Lane Cc: "Pgsql-Admin (E-mail)" In-Reply-To: <18484.1141744059@sss.pgh.pa.us> References: <18484.1141744059@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Tue, 07 Mar 2006 16:11:15 +0100 Message-Id: <1141744275.7408.1.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.089 required=5 tests=[AWL=0.088, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.089 X-Spam-Level: X-Archive-Number: 200603/66 X-Sequence-Number: 20823 Hi Tom, On Tue, 2006-03-07 at 10:07 -0500, Tom Lane wrote: > "Joost Kraaijeveld" writes: > > Can I safely delete all the WAL log files in PGDATA/pg_xlog directory if the database has been shut down correctly, because I lowered the number of logfiles in postgresql.conf? > > All but the one holding the latest checkpoint record (pg_controldata > will tell you which one that is). I'm not sure why you'd bother though. > The next checkpoint should remove any excess log files, there's no need > to do it manually. Ah, I did not know that. I will wait and do nothing. Thanks -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: J.Kraaijeveld@Askesis.nl web: www.askesis.nl