Possible to check integrity of restored database? - Mailing list pgsql-admin

From Mike Lott
Subject Possible to check integrity of restored database?
Date
Msg-id 96120B80-1A6C-4199-9892-A75CC943F886@gmail.com
Whole thread Raw
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Change port number
Next
From: Tom Lane
Date:
Subject: Re: pg_xlog location