how to recover after harddisk error

From: "Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at>
To: <pgsql-general(at)postgresql(dot)org>
Subject: how to recover after harddisk error
Date: 2003-02-26 09:12:03
Message-ID: 000001c2dd77$20a13e00$5be0d089@ekelhardt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Yesterday at about 8pm the harddisk subsystem of our web application
crashed, because of some scsi-error. The system could be restarted today
in the morning, but the database would not come up again. The following
info could be found in the log file.

2003-02-26 09:03:06 [1291] DEBUG: database system was interrupted at
2003-02-25 20:19:22 CET
2003-02-26 09:03:06 [1291] DEBUG: open of
/usr/local/pgsql/data/pg_xlog/0000001A000000C9 (log file 26, segment
201) failed
: No such file or directory
2003-02-26 09:03:06 [1291] DEBUG: invalid primary checkpoint record
2003-02-26 09:03:06 [1291] DEBUG: open of
/usr/local/pgsql/data/pg_xlog/0000001A000000C8 (log file 26, segment
200) failed
: No such file or directory
2003-02-26 09:03:06 [1291] DEBUG: invalid secondary checkpoint record
2003-02-26 09:03:06 [1291] FATAL 2: unable to locate a valid
checkpoint record
2003-02-26 09:03:06 [1277] DEBUG: startup process (pid 1291) exited
with exit code 2
2003-02-26 09:03:06 [1277] DEBUG: aborting startup due to startup
process failure

I did the following steps to get the system running again:

- a new initdb in another data-directory
- create the database again
- restore the data from the last available nightly dump

Is there a better way to get the system running again? Had there been
any way to access the old system again? The steps I did took about 45
min which is quite long (cause the db-dump is rather large) and if there
had been some important data it had been lost...

TIA, peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Björn Metzdorf 2003-02-26 09:24:42 Re: how to recover after harddisk error
Previous Message Erwin Moller 2003-02-26 09:02:12 Newbie needs help: How to create a 'plain' 7.3 database in 7.2.1?