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 CDC64D1B4D3 for ; Wed, 7 Apr 2004 17:56:58 -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 07809-01 for ; Wed, 7 Apr 2004 17:56:57 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4BACCD1D07F for ; Wed, 7 Apr 2004 17:56:55 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i37KurUc027604; Wed, 7 Apr 2004 16:56:54 -0400 (EDT) To: "Tom Bakken" Cc: pgsql-admin@postgresql.org Subject: Re: Out of space In-reply-to: <003701c41ce1$48310d10$770e9dc7@agwest.one.usda.gov> References: <003701c41ce1$48310d10$770e9dc7@agwest.one.usda.gov> Comments: In-reply-to "Tom Bakken" message dated "Wed, 07 Apr 2004 15:45:37 -0500" Date: Wed, 07 Apr 2004 16:56:53 -0400 Message-ID: <27603.1081371413@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/123 X-Sequence-Number: 13096 "Tom Bakken" writes: > Here's the situation: > [root@linux04 init.d]# cd /var/lib/pgsql/data/ > [root@linux04 data]# ls -l > total 1494316 > -rw------- 1 postgres postgres 4 Jun 21 2001 PG_VERSION > drwx------ 6 postgres postgres 4096 Sep 17 2003 base > drwx------ 2 postgres postgres 4096 Oct 27 13:40 global > -rw-r--r-- 1 root root 7640 Jun 29 2001 h > -rw------- 1 postgres postgres 9070 Mar 2 10:56 pg_hba.conf > -rw------- 1 postgres postgres 1118 Jun 21 2001 pg_ident.conf > -rw------- 1 postgres postgres 1528630320 Apr 7 14:26 pg_log > drwx------ 2 postgres postgres 4096 Apr 7 14:26 pg_xlog > -rw------- 1 postgres postgres 3137 Jun 21 2001 postgresql.conf > -rw------- 1 postgres postgres 52 Apr 7 14:26 postmaster.opts > [root@linux04 data]# ls -l pg_xlog/ > total 16404 > -rw------- 1 postgres postgres 16777216 Apr 7 12:14 000000010000001E > I do have a limited amount of space in the partition but I'd like to get = > rid of more. Just not sure what to delete if anything. Hm, what is that pg_log file? It's not part of the normal Postgres fileset. Is it perhaps just the postmaster's stderr output? If so, you're in luck: truncate that as you see fit, and you'll have some breathing room. regards, tom lane