db recovery (FATAL 2)

From: Bojan Belovic <bbelovic(at)usa(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: db recovery (FATAL 2)
Date: 2002-05-07 14:22:03
Message-ID: 20020507142203.4114.qmail@uwdvg001.cms.usa.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Pam Wampler 2002-05-07 15:32:22 Upgrade from 7.2 -> 7.2.1
Previous Message Marin Dimitrov 2002-05-07 13:49:42 Re: [ADMIN] [DOCS] Migrating Oracle to PostgreSQL

Browse pgsql-sql by date

  From Date Subject
Next Message Sean McCorkle 2002-05-07 15:03:50 blanking out repeated columns in rows
Previous Message Marin Dimitrov 2002-05-07 13:49:42 Re: [ADMIN] [DOCS] Migrating Oracle to PostgreSQL