Re: how to recover after harddisk error

Thanks a lot Bjoern.

Just wanted to mention that I found pg_resetxlog to be available per
default in pg7.3.2.

>-----Ursprüngliche Nachricht-----
>Von: Björn Metzdorf [mailto:bm@turtle-entertainment.de]
>Gesendet: Mittwoch, 26. Februar 2003 10:25
>An: Peter Alberer; pgsql-general@postgresql.org
>Betreff: Re: [GENERAL] how to recover after harddisk error
>
>> 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