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