Re: Verify Option with pg_dump - Mailing list pgsql-general

From Howard News
Subject Re: Verify Option with pg_dump
Date
Msg-id f3d5e1a6-d2a2-7425-4e68-d2bbfc9da0d9@selestial.com
Whole thread Raw
In response to Re: Verify Option with pg_dump  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: Verify Option with pg_dump  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Regarding the filesystem solution, the dump is currently written to a HP
>> RAID 10 array with an NTFS partition. What filesystems / raid arrays have
>> this ability?
> If you can't trust your RAID 10 (1 meaning mirrored) to
> actually store what you told it to you've got problems beyond
> somehow verifying a pg_dump.
>
> Regards,
> Karsten
I am told RAID can only protect you against disk failure. File writes to
one or more of the disks in an array are not typically compared so a
RAID array carrys on until the disk failure, or error count get to a
certain level. So RAID does not fully protect you from data corruption.

So you can't trust RAID!



pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: About the MONEY type
Next
From: Marcin Giedz
Date:
Subject: PostgreSQl HA solution