Search Postgresql Archives

Re: Postgresql data integrity during RAID10 drive rebuild

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux