Re: Postgresql data integrity during RAID10 drive rebuild - Mailing list pgsql-general

From Vivek Khera
Subject Re: Postgresql data integrity during RAID10 drive rebuild
Date
Msg-id 1E8348E8-FBF3-421D-864D-99D820E6EBC4@khera.org
Whole thread Raw
In response to Postgresql data integrity during RAID10 drive rebuild  ("Steve Poe" <steve.poe@gmail.com>)
List pgsql-general

On Nov 29, 2006, at 11:56 AM, Steve Poe wrote:

I've never had to replace a disc in an array with Postgresql running on it. LSI says I can replace the disc and do a rebuild while everything is running. I am of course concerned about data integrity/corruption. 


This is the whole entire complete purpose you have a RAID card and hot-swap drives:  To make it transparent to the layers above the disk interface.

Has anyone had to rebuild one of their disc in an array of their database?

Yes.  The OS (let alone an application such as the DB) has no clue other than possibly slower response from the mirrored pair being rebuilt.
Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: coalesce with all nulls can only be assigned to text
Next
From: "Kevin Grittner"
Date:
Subject: Re: coalesce with all nulls can only be assigned to