Re: how to recover after harddisk error - Mailing list pgsql-general

From Björn Metzdorf
Subject Re: how to recover after harddisk error
Date
Msg-id 01b001c2dd78$e5b1bd40$0564a8c0@shock
Whole thread Raw
In response to how to recover after harddisk error  ("Peter Alberer" <h9351252@obelix.wu-wien.ac.at>)
Responses Re: how to recover after harddisk error  ("Peter Alberer" <h9351252@obelix.wu-wien.ac.at>)
List pgsql-general
> 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
>
> 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...

pg_resetxlog from contrib

Regards,
Bjoern


pgsql-general by date:

Previous
From: "Peter Alberer"
Date:
Subject: how to recover after harddisk error
Next
From: "Peter Alberer"
Date:
Subject: Re: how to recover after harddisk error