Re: verifying database integrity - fsck for pg?

Tom Lane wrote:
> 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?

i had considered pg_dump. i was hoping there was a utility similar
to fsck that could check for corruption. i'd like to verify now that
the data is ok, rather than coming across errors in 6 months time.

i'm going to go a vacuum full, and a pg_dump. at least that should
mean all the data is accessible.

cheers


--

   - Rich Doughty