Re: production server down

Joe Conway <mail(at)joeconway(dot)com> 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