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

From Tom Lane
Subject Re: verifying database integrity - fsck for pg?
Date
Msg-id 3612.1138718853@sss.pgh.pa.us
Whole thread Raw
In response to verifying database integrity - fsck for pg?  (Rich Doughty <rich@opusvl.com>)
Responses Re: verifying database integrity - fsck for pg?  (Rich Doughty <rich@opusvl.com>)
List pgsql-general
Rich Doughty <rich@opusvl.com> writes:
> 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.

pg_dump both databases and diff the results, perhaps?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: incremental backups
Next
From: Rich Doughty
Date:
Subject: Re: verifying database integrity - fsck for pg?