Tom Lane wrote:
Rich Doughty <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
