Tom Lane wrote:
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).
OK
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?
Correct.
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.
Thanks,
Joe
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
