Skip site navigation (1) Skip section navigation (2)

Re: Postgresql data integrity during RAID10 drive rebuild

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Steve Poe <steve(dot)poe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql data integrity during RAID10 drive rebuild
Date: 2006-11-29 17:11:23
Message-ID: 1164820283.4414.23.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: 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




In response to

pgsql-general by date

Next:From: Tomi N/ADate: 2006-11-29 17:31:31
Subject: Re: Only MONO/WinForms is a way to go
Previous:From: Kevin GrittnerDate: 2006-11-29 17:07:27
Subject: coalesce with all nulls can only be assigned to text

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group