| From: | Björn Metzdorf <bm(at)turtle-entertainment(dot)de> |
|---|---|
| To: | "Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: how to recover after harddisk error |
| Date: | 2003-02-26 09:24:42 |
| Message-ID: | 01b001c2dd78$e5b1bd40$0564a8c0@shock |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florent LE SOZ | 2003-02-26 09:57:41 | Is It possible to fixe a table in mermory ? |
| Previous Message | Peter Alberer | 2003-02-26 09:12:03 | how to recover after harddisk error |