From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Verify Option with pg_dump |
Date: | 2016-11-30 14:06:56 |
Message-ID: | 20161130140656.ggfl2tcube2kfw32@hermes.hilbert.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2016-11-30 14:10:27 | Re: Verify Option with pg_dump |
Previous Message | Howard News | 2016-11-30 14:03:28 | Re: select function alias |