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 по дате отправления:

Предыдущее
От: "Peter Alberer"
Дата:
Сообщение: how to recover after harddisk error
Следующее
От: "Peter Alberer"
Дата:
Сообщение: Re: how to recover after harddisk error