Re: 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