Re: database corruption questions

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: database corruption questions
Дата
Msg-id 5079F114.2020504@hogranch.com
обсуждение исходный текст
Ответ на Re: database corruption questions  (Leif Biberg Kristensen <leif@solumslekt.org>)
Список pgsql-general
On 10/13/12 3:04 PM, Leif Biberg Kristensen wrote:
>   Lørdag 13. oktober 2012 23.53.03 skrev Heine Ferreira :
>> >Hi
>> >
>> >Are there any best practices for avoiding database
>> >corruption?
> In my experience, database corruption always comes down to flaky disk drives.
> Keep your disks new and shiny eg. less than 3 years, and go for some kind of
> redundancy in a RAID configuration.

also, ECC RAM so creeping bit rot doesn't slip in from memory without
detection.    if you use a raid controller with a write-back cache, be
sure it has BBU or flash-back.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast




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

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: citext question
Следующее
От: Vibhor Kumar
Дата:
Сообщение: Re: citext question