Re: Version 7.2.3 unrecoverable crash on missing pg_clog

Tom Lane wrote:
> Andy Osborne <andy(at)sift(dot)co(dot)uk> writes:
>
>>Tom Lane wrote:
>
> But with no way to reproduce it it's hard to pin blame.

Sad but true :-(

>>>You didn't happen to make a physical copy of the news table before
>>>dropping it, did you? It'd be interesting to examine the remains.
>>
>
>>Sadly, no I didn't. This is one of our live database servers
>>and I was under a lot of pressure to get it back quickly. If
>>it does it again, what can I do to provide the most useful
>>feedback ?.
>
>
> If the database isn't unreasonably large, perhaps you could take a
> tarball dump of the whole $PGDATA directory tree while the postmaster
> is stopped? That would document the situation for examination at leisure.

It's about 8GB in total, so that seems like a plan.

Thanks for your help,

Andy

--
Andy Osborne **************** "Vertical B2B Communities"
Senior Internet Engineer
Sift Group 100 Victoria Street, Bristol BS1 6HZ
tel:+44 117 915 9600 fax:+44 117 915 9630 http://www.sift.co.uk