Re: How to determine a database is intact?

Thomas F. O'Connell <tfo@sitening.com>

From: Thomas F.O'Connell <tfo@sitening.com>
To: Wes <wespvp@syntegra.com>
Cc: Postgres General <pgsql-general@postgresql.org>
Date: 2004-09-02T20:43:43Z
Lists: pgsql-general
Hmm. I do a nightly dump of our production database, archive a copy 
offsite, and verify the quality of the dump by running a little 
verification script that is little more than a restore.

But if it would take you more than a day to do that, I'm not sure.

-tfo

On Sep 2, 2004, at 3:30 PM, Wes wrote:

> Back to the original question...  How can I verify the complete 
> integrity of
> a database - especially a very large one where a reload or full index
> rebuild could take on the order of days?
>
> Wes