On 1/31/06, Rich Doughty <[EMAIL PROTECTED]> 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 ---------------------------(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
