Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 2EDB1475B94 for ; Wed, 8 May 2002 01:59:50 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 5CB12475AD2 for ; Wed, 8 May 2002 01:59:49 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g485xkv29777; Wed, 8 May 2002 01:59:46 -0400 (EDT) To: Bojan Belovic Cc: pgsql-admin@postgresql.org Subject: Re: db recovery (FATAL 2) In-reply-to: <20020507142203.4114.qmail@uwdvg001.cms.usa.net> References: <20020507142203.4114.qmail@uwdvg001.cms.usa.net> Comments: In-reply-to Bojan Belovic message dated "Tue, 07 May 2002 10:22:03 -0400" Date: Wed, 08 May 2002 01:59:46 -0400 Message-ID: <29774.1020837586@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200205/61 X-Sequence-Number: 4236 Bojan Belovic writes: > FATAL 2: write(logfile 10 seg 93 off 15474688) failed: Success This would be what PG version? Broad-jumping to conclusions, I'm going to guess (a) 7.1.0-7.1.2 and (b) you are out of disk space for the WAL logs. If so, you'll need to free up 16MB or so to restart the postmaster, and you'd be well advised to update to 7.1.3 before trying another VACUUM. regards, tom lane