Re: database corruption questions - Mailing list pgsql-general

From John R Pierce
Subject Re: database corruption questions
Date
Msg-id 5079F114.2020504@hogranch.com
Whole thread Raw
In response to Re: database corruption questions  (Leif Biberg Kristensen <leif@solumslekt.org>)
List 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 by date:

Previous
From: David Johnston
Date:
Subject: Re: citext question
Next
From: Vibhor Kumar
Date:
Subject: Re: citext question