Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TTn37-0004ia-Ts for pgsql-admin@postgresql.org; Thu, 01 Nov 2012 05:10:38 +0000 Received: from asbnvacz-mailrelay01.megapath.net ([207.145.128.243]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TTn31-0002pY-7f for pgsql-admin@postgresql.org; Thu, 01 Nov 2012 05:10:36 +0000 Received: from mail3.sea5.speakeasy.net (mail3.sea5.speakeasy.net [69.17.117.42]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id 90D90A717BB for ; Thu, 1 Nov 2012 01:10:29 -0400 (EDT) Received: (qmail 31906 invoked from network); 1 Nov 2012 05:10:29 -0000 Received: by simscan 1.4.0 ppid: 27887, pid: 19709, t: 1.4738s scanners: clamav: 0.88.2/m:52/d:10739 spam: 3.0.4 Received: from unknown (HELO [192.168.2.118]) (sribe@elevated-dev.com@[205.170.118.129]) (envelope-sender ) by mail3.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 1 Nov 2012 05:10:27 -0000 Subject: Re: Detecting DB corruption Mime-Version: 1.0 (Apple Message framework v1085) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: <5091E377.2030505@ringerc.id.au> Date: Wed, 31 Oct 2012 23:10:25 -0600 Cc: Raj Gandhi , pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <5091E377.2030505@ringerc.id.au> To: Craig Ringer X-Mailer: Apple Mail (2.1085) X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on mail3.sea5 X-Spam-Level: X-Spam-Status: No, score=0.0 required=8.0 tests=none autolearn=disabled version=3.0.4 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201211/3 X-Sequence-Number: 40248 On Oct 31, 2012, at 8:50 PM, Craig Ringer wrote: > Seriously, if you're facing DB corruption then something is already > horribly wrong with your setup. True, but. In a past life, complaints from the db (it was a db that = stored a checksum with every block) were the very first symptom when = something went horribly wrong with the hardware. (Partial short between = wires of an internal SCSI cable; eventually we determined that about = every 1MB, 1 bit would get flipped between the controller & disk.) So, if there were an official db verifier tool for PG, I for one would = have it run periodically. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice