Re: Best way to recover from crash?

Поиск
Список
Период
Сортировка
От Steve Wampler
Тема Re: Best way to recover from crash?
Дата
Msg-id 1090519463.27918.88.camel@weaver.tuc.noao.edu
обсуждение исходный текст
Ответ на Re: Best way to recover from crash?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Thu, 2004-07-22 at 10:59, Tom Lane wrote:

> I think you'd be foolish not to initdb and reload from the backups.
> You have no way to know how extensive the data damage is ... you might
> work around the problems you see now, only to find something else
> later after you've put more data into the corrupted DB.

Thanks, Tom.  I did that and what you say makes sense.  I was
just overly worried about the down time since the backup database
dump was well over 4GB and looking for a quick fix.  On the
other hand, a 1-hour downtime (what it took) isn't so bad,
and knowing things are solid is worth more than that!

Thanks again,
Steve
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Best way to recover from crash?
Следующее
От: Si Chen
Дата:
Сообщение: how to find transaction associated with a lock