Re: production server down

Tom Lane wrote:
> 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).

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