Re: verifying database integrity - fsck for pg? - Mailing list pgsql-general

From Harry Jackson
Subject Re: verifying database integrity - fsck for pg?
Date
Msg-id 45b42ce40601310230p70491821qd050bc4d0fa96dd8@mail.gmail.com
Whole thread Raw
In response to verifying database integrity - fsck for pg?  (Rich Doughty <rich@opusvl.com>)
List pgsql-general
On 1/31/06, Rich Doughty <rich@opusvl.com> wrote:
> We are currently migrating a cluster between hosts. I'd like to
> verify that the new database has been transferred reliably and
> that the datafiles are in tact.
>
> What's the recommended way to do this? We're using
> pg_start/stop_backup so an md5 check is out of the question.
>
> pg version 8.0

I would doubt if it is a full test but in the past when I have had
corruptions in the database its been a full vacuum that has spotted
them.

--
Harry
http://www.hjackson.org
http://www.uklug.co.uk

pgsql-general by date:

Previous
From: "Myatluk Andrey"
Date:
Subject: Re: PostgreSQL + hibernate
Next
From: "Myatluk Andrey"
Date:
Subject: Re: PostgreSQL + hibernate