Re: validating database integrity

Поиск
Список
Период
Сортировка
От lst_hoe02@kwsoft.de
Тема Re: validating database integrity
Дата
Msg-id 20110427103838.17521a37t5wp1atc@webmail.kwsoft.de
обсуждение исходный текст
Ответ на validating database integrity  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
Zitat von Scott Ribe <scott_ribe@elevated-dev.com>:

> Just had a hard crash, and pg came back looking ok. However, crash
> was in the driver for the (battery-backed) RAID card, and I know for
> a fact that one file that was written to the (journaled) file system
> before the crash was not there after reboot. So, what steps are
> recommended to make sure pg files are ok?

I would say a full dump will let you know, at least for the data.

> Yeah, battery-backed cache does no good if the driver is crap...

Or the battery is leaking :-)

Regards

Andreas



Вложения

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

Предыдущее
От: lst_hoe02@kwsoft.de
Дата:
Сообщение: Re: Scaling
Следующее
От: Mark Stosberg
Дата:
Сообщение: best practice for moving millions of rows to child table when setting up partitioning?