Joe Conway <[EMAIL PROTECTED]> writes: > I don't trust it at all. So does that imply that I should override next > transaction id and WAL starting address per the manpage?
Yes, override everything there's a switch for. Also check that the other values shown by pg_controldata look reasonable (the locale settings are probably the only ones you might get burned on). >> What if anything have you got in $PGDATA/pg_xlog? >> > -rw------- 1 postgres postgres 16777216 Dec 13 15:39 0000016500000077 Um. That's so far from the values shown in pg_control that it's not funny. This is 7.4, right? I have a crude xlog dump tool that I'll send you off-list. We should be able to identify the latest checkpoint in the existing XLOG files, and that will give you something to work with. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend