Re: How to determine a database is intact? - Mailing list pgsql-general

From Thomas F.O'Connell
Subject Re: How to determine a database is intact?
Date
Msg-id C7AD792A-FD20-11D8-A6F2-000D93AE0944@sitening.com
Whole thread Raw
In response to How to determine a database is intact?  (Wes <wespvp@syntegra.com>)
List 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


pgsql-general by date:

Previous
From: "Ian Harding"
Date:
Subject: Debugging
Next
From: Vivek Khera
Date:
Subject: Re: Foreign key locks