On Sun, Oct 30, 2005 at 08:50:18AM +0000, John Sidney-Woollett wrote:
> Oh my god!....
> DB is pg 7.4.6 on linux
Firstly, check pg_database, it should tell you which databases need to
be vacuumed. Any database you regularly vacuumed is fine so maybe the
corruption is in some other database you don't remember?
> 1) Why do have we data corruption? I thought we were doing everything we
> needed to stop any wraparound... Are the pg docs inadequate, or did I
> misunderstand what needed to be done?
You *may* have corruption. Anything you vacuumed recently should be
> 2) What can I do to recover the data?
Check whether anything is lost first.
> How do I stop this EVER happening again??!!!
Have you read this:
Hope this helps,
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
In response to
pgsql-general by date
|Next:||From: David Fetter||Date: 2005-10-30 14:29:41|
|Subject: Re: mysql replace in postgreSQL?|
|Previous:||From: John Sidney-Woollett||Date: 2005-10-30 08:50:18|
|Subject: Please HELP - URGENT - transaction wraparound error|