X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 521ADD1C9B7 for ; Wed, 7 Apr 2004 14:19:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08684-01 for ; Wed, 7 Apr 2004 14:19:48 -0300 (ADT) Received: from curie.credativ.org (credativ.com [217.160.209.18]) by svr1.postgresql.org (Postfix) with ESMTP id BE25CD1C951 for ; Wed, 7 Apr 2004 14:19:47 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by curie.credativ.org (Postfix) with ESMTP id BFCA055F01; Wed, 7 Apr 2004 19:19:47 +0200 (CEST) Received: from colt.pezone.net (dsl-082-082-236-250.arcor-ip.net [82.82.236.250]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by curie.credativ.org (Postfix) with ESMTP id 4C65555A23; Wed, 7 Apr 2004 19:19:47 +0200 (CEST) From: Peter Eisentraut To: "Tom Bakken" , Subject: Re: Out of space Date: Wed, 7 Apr 2004 19:19:46 +0200 User-Agent: KMail/1.5.1 References: <000a01c41cbd$3e916850$770e9dc7@agwest.one.usda.gov> In-Reply-To: <000a01c41cbd$3e916850$770e9dc7@agwest.one.usda.gov> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200404071919.46503.peter_e@gmx.net> X-Virus-Scanned: by AMaViS at credativ.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/114 X-Sequence-Number: 13087 Tom Bakken wrote: > I've been running a postgres for 2 or 3 years without a problem. > This morning my disk space for the database filled up. I need to > know what transaction/log files I can truncate or delete without > compromising the system. These files are located under > /var/lib/pgsql/data/ The answer is normally "none" unless you have experienced crashes or other problems that might have left stale files lying around. But you say have had no problem ... If you have any suspicion in that direction, please show us the exact files you're thinking about. A note about which PG version you are running would also help.