Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZhaH-000194-0s for pgsql-admin@arkaria.postgresql.org; Fri, 25 Oct 2013 13:37:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VZhaG-00012b-6u for pgsql-admin@arkaria.postgresql.org; Fri, 25 Oct 2013 13:37:48 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZhaF-00012T-DO for pgsql-admin@postgresql.org; Fri, 25 Oct 2013 13:37:47 +0000 Received: from asbnvacz-mailrelay01.megapath.net ([207.145.128.243]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZhaA-0002LP-IG for pgsql-admin@postgresql.org; Fri, 25 Oct 2013 13:37:45 +0000 Received: from mail3.sea5.speakeasy.net (mail3.sea5.speakeasy.net [69.17.117.42]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id 300C41EE50BA for ; Fri, 25 Oct 2013 09:37:41 -0400 (EDT) Received: (qmail 26212 invoked from network); 25 Oct 2013 13:37:40 -0000 Received: by simscan 1.4.0 ppid: 5141, pid: 12489, t: 0.2754s scanners: clamav: 0.88.2/m:52/d:10739 spam: 3.0.4 Received: from 97-124-226-83.hlrn.qwest.net (HELO [192.168.2.16]) (sribe@elevated-dev.com@[97.124.226.83]) (envelope-sender ) by mail3.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 25 Oct 2013 13:37:40 -0000 Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\)) Subject: Re: testing database consistency From: Scott Ribe In-Reply-To: Date: Fri, 25 Oct 2013 07:37:38 -0600 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Albe Laurenz X-Mailer: Apple Mail (2.1510) 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: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Oct 25, 2013, at 3:00 AM, Albe Laurenz wrote: > There is no safe way (unless you were running on 9.3 with checksums). It would be cool though, for those of us doing that, to have some new comma= nd to verify the checksum on all pages... --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin