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 81251D1D1CD for ; Thu, 8 Apr 2004 10:27:36 -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 31296-02 for ; Thu, 8 Apr 2004 10:27:36 -0300 (ADT) Received: from pop.e-it.com (pop.e-it.com [216.187.113.81]) by svr1.postgresql.org (Postfix) with ESMTP id 2348DD1D098 for ; Thu, 8 Apr 2004 10:27:34 -0300 (ADT) Received: (qmail 32138 invoked by uid 500); 8 Apr 2004 13:00:05 -0000 Received: from ool-18b9d65f.dyn.optonline.net (HELO did-it.com) (eric@did-it.com@24.185.214.95) by pop.e-it.com with SMTP; 8 Apr 2004 13:00:05 -0000 Message-ID: <40755349.8060209@did-it.com> Date: Thu, 08 Apr 2004 09:27:37 -0400 From: Ericson Smith User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Bakken Cc: pgsql-admin@postgresql.org Subject: Re: Out of space References: <000a01c41cbd$3e916850$770e9dc7@agwest.one.usda.gov> In-Reply-To: <000a01c41cbd$3e916850$770e9dc7@agwest.one.usda.gov> Content-Type: multipart/mixed; boundary="------------050108090603060801080307" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/144 X-Sequence-Number: 13117 This is a multi-part message in MIME format. --------------050108090603060801080307 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Why not just get a bigger disk? Warmest regards, Ericson Smith Tracking Specialist/DBA +-----------------------+---------------------------------+ | http://www.did-it.com | "When you have to shoot, shoot, | | eric@did-it.com | don't talk! - Tuco | | 516-255-0500 | | +-----------------------+---------------------------------+ 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/ > >Many of them have dates of more than a year ago. I'm kind of rusty with >this. Postgres works too well to keep me fluent with troubleshooting. > >Tom Bakken >Information Resource Manager >Texas USDA, Rural Development > > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > --------------050108090603060801080307 Content-Type: text/x-vcard; charset=utf8; name="eric.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="eric.vcf" begin:vcard fn:Ericson Smith n:Smith;Ericson org:Did-it.com;Programming adr:#304;;55 Maple Avenue;Rockville Center;NY;11570;USA email;internet:eric@did-it.com title:Web Developer tel;work:516-255-0500 tel;cell:646-483-3420 note:Nothing special! x-mozilla-html:FALSE url:http://www.did-it.com version:2.1 end:vcard --------------050108090603060801080307--