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 B9B66D1C9B7 for ; Wed, 7 Apr 2004 17:48:56 -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 02510-04 for ; Wed, 7 Apr 2004 17:48:56 -0300 (ADT) Received: from txsnet.tx.nrcs.usda.gov (txsnet.tx.nrcs.usda.gov [199.158.131.3]) by svr1.postgresql.org (Postfix) with ESMTP id CD287D1C50B for ; Wed, 7 Apr 2004 17:48:52 -0300 (ADT) Received: from txtemple20d119 ([199.157.14.119]) by txsnet.tx.nrcs.usda.gov (8.9.3/8.9.3/USDA-ITC $Revision: 1.5 $) with ESMTP id PAA16497; Wed, 7 Apr 2004 15:52:27 -0500 (CDT) From: "Tom Bakken" To: "'Tom Lane'" Cc: Subject: Re: Out of space Date: Wed, 7 Apr 2004 15:45:37 -0500 Message-ID: <003701c41ce1$48310d10$770e9dc7@agwest.one.usda.gov> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0038_01C41CB7.5F5B0510" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.5709 In-Reply-To: <27072.1081367838@sss.pgh.pa.us> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/122 X-Sequence-Number: 13095 This is a multi-part message in MIME format. ------=_NextPart_000_0038_01C41CB7.5F5B0510 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Tom, 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. Tom Bakken Information Resource Manager Texas USDA, Rural Development=20 -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Sent: Wednesday, April 07, 2004 2:57 PM To: Tom Bakken Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Out of space=20 "Tom Bakken" writes: > FATAL 2: ZeroFill(/var/lib/pgsql/data/pg_xlog/xlogtemp.1091) failed: No > such file or directory > /usr/bin/postmaster: Startup proc 1091 exited with status 512 - abort > I'm sure I didn't delete it. This is just trying to make a new, empty xlog file. I don't quite understand why the errno is "No such file or directory" --- you wouldn't think that write() could return that errno. But the most likely bet is that you don't yet have enough free space on the disk. These files are 16MB each, and it could be that more than one needs to be made. How much stuff is there in /var/lib/pgsql/data/pg_xlog anyway? I think that 7.1.2 predates some changes we made to keep down the number of xlog files that would be kept around. regards, tom lane ------=_NextPart_000_0038_01C41CB7.5F5B0510 Content-Type: text/x-vcard; name="Tom.Bakken@tx.usda.gov.vcf" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="Tom.Bakken@tx.usda.gov.vcf" BEGIN:VCARD VERSION:2.1 N:Bakken;Tom FN:Tom.Bakken@tx.usda.gov ORG:Texas State Office TEL;WORK;VOICE:(254) 742-9726 TEL;WORK;FAX:(254) 742-9709 ADR;WORK;ENCODING=3DQUOTED-PRINTABLE:;;101 South Main=3D0D=3D0ASuite 102;Te= mple;TX;76502;United States of America LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:101 South Main=3D0D=3D0ASuite 102=3D= 0D=3D0ATemple, TX 76502=3D0D=3D0AUnited States of Am=3D erica EMAIL;PREF;INTERNET:Tom.Bakken@tx.usda.gov REV:20040301T143942Z END:VCARD ------=_NextPart_000_0038_01C41CB7.5F5B0510--