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 107A6D1BC5C for ; Wed, 7 Apr 2004 16:58:40 -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 78202-10 for ; Wed, 7 Apr 2004 16:58:39 -0300 (ADT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 35EDAD1BAAD for ; Wed, 7 Apr 2004 16:58:38 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by www.postgresql.com (Postfix) with ESMTP id 93309CF52BD for ; Wed, 7 Apr 2004 16:58:36 -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 i37JvI84027073; Wed, 7 Apr 2004 15:57:19 -0400 (EDT) To: "Tom Bakken" Cc: pgsql-admin@postgresql.org Subject: Re: Out of space In-reply-to: <001f01c41cd8$7a127480$770e9dc7@agwest.one.usda.gov> References: <001f01c41cd8$7a127480$770e9dc7@agwest.one.usda.gov> Comments: In-reply-to "Tom Bakken" message dated "Wed, 07 Apr 2004 14:42:35 -0500" Date: Wed, 07 Apr 2004 15:57:18 -0400 Message-ID: <27072.1081367838@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/120 X-Sequence-Number: 13093 "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