Re: production server down

Joe Conway <mail@joeconway.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