Mailbox-Line: From bbelovic@usa.net  Tue May  7 12:19:42 2002
Message-ID: <20020507142203.4114.qmail@uwdvg001.cms.usa.net>
Date: Tue, 07 May 2002 10:22:03 -0400
From: Bojan Belovic <bbelovic@usa.net>
To: <pgsql-admin@postgresql.org>
Subject: db recovery (FATAL 2)
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
SPAM: -------------------- Start SpamAssassin results ----------------------
	SPAM: This mail is probably spam. The original message has been altered
	SPAM: so you can recognise or block similar unwanted mail in future.
	SPAM: See http://spamassassin.org/tag/ for more details. SPAM:
	SPAM: Content analysis details:   (5 hits, 5 required)
	SPAM: Hit! (2.0 points)  Received via a relay in relays.osirusoft.com
	SPAM: [RBL check: found 240.242.144.63.relays.osirusoft.com.,
	type: 127.0.0.4]
	SPAM: Hit! (3.0 points)  DNSBL: sender is Confirmed Spam Source SPAM:
	SPAM: -------------------- End of SpamAssassin results
	---------------------

My database apparently crashed - don't know how or why. It happend in the
middle of the night so I wasn't around to troubleshoot it at the time. It
looks like it died during the scheduled vacuum.

Here's the log that gets generated when I attempt to bring it back up:

postmaster successfully started
DEBUG:  database system shutdown was interrupted at 2002-05-07 09:35:35 EDT
DEBUG:  CheckPoint record at (10, 1531023244)
DEBUG:  Redo record at (10, 1531023244); Undo record at (10, 1531022908);
Shutdown FALSE
DEBUG:  NextTransactionId: 29939385; NextOid: 9729307
DEBUG:  database system was not properly shut down; automatic recovery in
progress...
DEBUG:  redo starts at (10, 1531023308)
DEBUG:  ReadRecord: record with zero len at (10, 1575756128)
DEBUG:  redo done at (10, 1575756064)
FATAL 2:  write(logfile 10 seg 93 off 15474688) failed: Success
/usr/bin/postmaster: Startup proc 1339 exited with status 512 - abort

Any suggestions? What are my options, other than doing a complete restore of
the DB from a dump (which is not really an option as the backup is not as
recent as it should be).

Thanks!

Bojan