Joe Conway <[EMAIL PROTECTED]> writes: > Assuming the only real problem here is the control data (long shot, I > know), and the actual database files and transaction logs are OK, is > there any reasonable way to reconstruct the correct contol data? Or is > that the point at which you use pg_resetxlog?
Well, the problem is that if you can't trust pg_control you don't know what you can trust. My advice is to backup the $PGDATA tree (which you said was in progress), then pg_resetxlog, then cross-check the hell out of the data you see. Only if you can detect some data problems can we guess at something else to do ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings