X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 15DBA9DCC1C for ; Tue, 14 Feb 2006 10:25:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31127-07-2 for ; Tue, 14 Feb 2006 10:25:27 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by postgresql.org (Postfix) with ESMTP id B3D949DCC2C for ; Tue, 14 Feb 2006 10:25:21 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i4so1257046wra for ; Tue, 14 Feb 2006 06:25:26 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:mime-version:content-transfer-encoding:message-id:content-type:to:from:subject:date:x-mailer; b=DZi7o3KOrT+zW948DODz8Iz5i+qlRJQO/Mf7FEUiACkgqAMjXyuI0v1B+xCImbvEK04q52gPzy2Ho/UB8B5fTp9gacn1oI6AhAdQPyUTbtXPDjf16mBH0M7eG56A1wHd89E31Xgp80vkZ2kq0Cbx5JJjvDurnXnHB/cR0rDXaQg= Received: by 10.65.115.3 with SMTP id s3mr1804218qbm; Tue, 14 Feb 2006 06:25:25 -0800 (PST) Received: from ?10.0.1.58? ( [194.35.93.7]) by mx.gmail.com with ESMTP id f18sm2888856qba.2006.02.14.06.25.24; Tue, 14 Feb 2006 06:25:25 -0800 (PST) Mime-Version: 1.0 (Apple Message framework v746.2) Content-Transfer-Encoding: 7bit Message-Id: <96120B80-1A6C-4199-9892-A75CC943F886@gmail.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-admin@postgresql.org From: Mike Lott Subject: Possible to check integrity of restored database? Date: Tue, 14 Feb 2006 14:25:20 +0000 X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/177 X-Sequence-Number: 20598 Hi there I am working on some d/r solutions at the university where I work, and I was wondering if there were any way to check the integrity of the restored data of a PostgreSQL database. The reason I ask is that if I am restoring [or the restoration is scripted] from backup, I would like to ensure that there has not been any data corruption throughout the process i.e. if the restoration of the data is successful, the data must not be corrupted, otherwise the d/r solution is a failure. I am running Mac OS X 10.3.9 and 10.4.4 and using PostgreSQL 8.1.2 Thanks, Mike Lott