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

From Joshua D. Drake
Subject Re: Postgresql data integrity during RAID10 drive rebuild
Date
Msg-id 1164820283.4414.23.camel@localhost.localdomain
Whole thread Raw
In response to Postgresql data integrity during RAID10 drive rebuild  ("Steve Poe" <steve.poe@gmail.com>)
List pgsql-general
On Wed, 2006-11-29 at 08:56 -0800, Steve Poe wrote:
> I need some input from the Postgresql community.
>
> Our animal hospital runs Postgresql 7.4 on a 6-disc RAID10. The
> database logs are on a separate RAID1.
>
> We're using an LSI MegaRAID 320-2X controller. The controller reports
> one 146GB SCSI disc has failed in the RAID10 performance is in
> "DEGRADED" mode. The database seems to be running fine but slower.
> 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.

Well of course do a backup, but LSI is correct it will rebuild
correctly.

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

Of course :) and you should be fine. However make sure you grab a backup
just in case, and check the firmware version on your LSI. There was a
parity bug that caused data corruption a coupld of revs ago.

Joshua D. Drake

>
> Thanks for your help.
>
> Steve Poe
>
>
>
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: coalesce with all nulls can only be assigned to text
Next
From: "Tomi N/A"
Date:
Subject: Re: Only MONO/WinForms is a way to go