Tom Lane wrote:
Andy Osborne <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
