Forum OpenACS Q&A: Response to index error on vacuum analyze

Collapse
2: Response to index error on vacuum analyze (response to 1)
Posted by Don Baccus on 05/10/01 12:40 AM
Do a pg_dump first then drop the index and create it.

When PG 7.1.2 comes out next week, I suggest you give our community a
few days to thrash it, and if it survives our datamodels and queries
UPGRADE YOUR SITE ASAP.

There have been some nasty vacuum bugs fixed since PG 7.0.2.  Some, at
least, made it into PG 7.0.3 but there are many other reasons to
upgrade straight to PG 7.1.2 as soon as you can.