Re: Postgresql data integrity during RAID10 drive rebuild

Поиск
Список
Период
Сортировка
От Steve Poe
Тема Re: Postgresql data integrity during RAID10 drive rebuild
Дата
Msg-id 721b21dc0611291121m333f8698ldab633a9e49626d6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql data integrity during RAID10 drive rebuild  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: Postgresql data integrity during RAID10 drive rebuild
Список pgsql-general

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?

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 LSI cards are very stable.  I've replaced drives under them back in
the Ultra-320 days with removable caddies.  I would imagine that as long
as you have the proper drive caddies you're set.  If the drives are not
in removable caddies, you'll need to power down to safely unplug them.

The drive is on a removable caddie in a 4-disc array backplane.

Scott, Joshua, and Vivek...thanks for your feedback.

Steve Poe
Adobe Animal Hospital

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: coalesce with all nulls can only be assigned to
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Including unique users in huge data warehouse in Postgresql...