Re: production server down

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

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