Toxic Byte

So then, it’s late in the day, the database is long overdue a vacuum so I set it off and left it. Apparently it fails two minutes in with:

vacuumdb: vacuuming of database "xxxxxx" failed: ERROR: failed to re-find parent key in "pg_class_relname_nsp_index"


So, after changing my underpants. I find the cure quite quickly with:

REINDEX INDEX pg_class_relname_nsp_index;

Thank the lord for that. Lesson of the day. Don’t switch off vacuum with postgresql because postgres don’t like it!

Technorati Tags: vacuum, postgresql, postgres