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