Re: Help!! Crash recovery

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: Help!! Crash recovery
Дата
Msg-id 20070406161123.0f030c31.wmoran@potentialtech.com
обсуждение исходный текст
Ответ на Help!! Crash recovery  (Jaime Silvela <JSilvela@Bear.com>)
Список pgsql-general
In response to Jaime Silvela <JSilvela@Bear.com>:

> I know you've probably discussed this in many places, but I have a crash
> right now I need to recover from, and I'm not finding documentation that
> fast.
> Where should I go?
>
> Here are the details on starting, after a kill -9 of a process brought
> Postgres down.
>
> Is there a page/s with information on quick recovery after corruption?
> LOG:  could not create IPv6 socket: Address family not supported by protocol
> LOG:  database system was interrupted while in recovery at 2007-04-05
> 08:18:47 EDT
> HINT:  This probably means that some data is corrupted and you will have
> to use the last backup for recovery.

Do you have dumps?  Hopefully you do, in which case your best bet may be
to backup your config files, then blow away the cluster directory and
re-initdb, then restore from dump.

--
Bill Moran
http://www.potentialtech.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: reindexing keys in postgres
Следующее
От: Marcus Engene
Дата:
Сообщение: performance; disk bad or something?