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

From Scott Marlowe
Subject Re: Postgresql data integrity during RAID10 drive rebuild
Date
Msg-id 1164829195.14565.210.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Postgresql data integrity during RAID10 drive rebuild  ("Steve Poe" <steve.poe@gmail.com>)
Responses Re: Postgresql data integrity during RAID10 drive rebuild  (Vivek Khera <vivek@khera.org>)
List pgsql-general
On Wed, 2006-11-29 at 13:21, Steve Poe wrote:
>         Yep, I've done it a few times.  A few tips:
>
>         backup your database with pg_dump.  confirm you can restore on
>         a test
>         machine.
>
> Thanks. We do nightly dump and restore  to a second server for
> testing/backup purposes.
>  The data is entact. Are you recommending a dump before we begin the
> drive rebuild?

Either that, or wait until the nightly dump / restore has run and start
then.

>         replace the drive during the lowest traffic period for your
>         database.
>
> Sounds good. According to LSI, the drive will take 8 hrs to rebuild a
> 146GB disc (at a 30% rebuild rate), so doing this in the middle of the
> day is not ideal.

The rebuild time also tends to depend on how full the array is.  If
you're only using 5% or so, it won't take the full 8 hours they're
projecting.



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Development of cross-platform GUI for Open Source DBs
Next
From: Mark Jensen
Date:
Subject: Re: Including unique users in huge data warehouse in Postgresql...