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

From Karsten Hilbert
Subject Re: Verify Option with pg_dump
Date
Msg-id 20161130140656.ggfl2tcube2kfw32@hermes.hilbert.loc
Whole thread Raw
In response to Re: Verify Option with pg_dump  (Howard News <howardnews@selestial.com>)
Responses Re: Verify Option with pg_dump  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
On Wed, Nov 30, 2016 at 01:53:21PM +0000, Howard News wrote:

> 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.

True enough. So it seems you are referring to "silent data
corruption". Does this link help ?

    http://www.raidix.com/knowledge-base/silent-data-corruption/

This link also seems relevant:

    http://stackoverflow.com/questions/13107783/pipe-output-to-two-different-commands

Regards,
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-general by date:

Previous
From: Howard News
Date:
Subject: Re: select function alias
Next
From: Karsten Hilbert
Date:
Subject: Re: Verify Option with pg_dump