Re: Version 7.2.3 unrecoverable crash on missing pg_clog

Tom Lane wrote:
> Andy Osborne <andy@sift.co.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