On Montag, 25. Februar 2008 Aaron Bono wrote:Even with a RAID system, a broken hard drive that doesn't show that it's
> We did have a hard drive problem (errors on the drive) in the past
> and they had to swap out a drive. It is a RAID configuration so no
> backup/restore was necessary.
broken can cause severe data destroying: We've had this several times
already, with different RAID and drive combinations, SATA and SCSI,
doesn't matter. The symptom was that you write data to the drive, it
says OK, but upon reading you receive other data than you wrote. Even
RAID 1/5/6 doesn't help you here.
Doesn't mean you have the same, but from what you wrote I just wanted to
inform you that it's a fact that a single broken drive can destroy even
a RAIDs data very nasty.
mfg zmi
If I do a pg_dump from this potentially "bad" database and then use the output to do a restore to a new DB on another server, aside from having some data corrupted, would we be able to recover from this problem? If not, what could I do to "fix" the data so the database stops having issues?
Thanks!
Aaron
--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================