Re: how to recover after harddisk error
От | Björn Metzdorf |
---|---|
Тема | Re: how to recover after harddisk error |
Дата | |
Msg-id | 01b001c2dd78$e5b1bd40$0564a8c0@shock обсуждение исходный текст |
Ответ на | how to recover after harddisk error ("Peter Alberer" <h9351252@obelix.wu-wien.ac.at>) |
Ответы |
Re: how to recover after harddisk error
|
Список | 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 по дате отправления: