Re: How to determine a database is intact?

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Wes <wespvp(at)syntegra(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to determine a database is intact?
Date: 2004-09-02 20:43:43
Message-ID: C7AD792A-FD20-11D8-A6F2-000D93AE0944@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ennio-Sr 2004-09-02 20:54:14 "echo"ing a psql command in a bash script
Previous Message Ian Harding 2004-09-02 20:34:30 Debugging