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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
