Re: Verify Option with pg_dump

From: Howard News <howardnews(at)selestial(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Verify Option with pg_dump
Date: 2016-11-30 13:53:21
Message-ID: f3d5e1a6-d2a2-7425-4e68-d2bbfc9da0d9@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Giedz 2016-11-30 14:00:16 PostgreSQl HA solution
Previous Message Raymond O'Donnell 2016-11-30 13:43:22 Re: About the MONEY type