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 fine. > 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: http://www.postgresql.org/docs/7.4/static/maintenance.html#VACUUM-FOR-WRAPAROUND Hope this helps, -- Martijn van Oosterhout <kleptog@svana.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.
pgpfnTkNQOBJ3.pgp
Description: PGP signature
