Vacuuming of database failed to re-find parent key.

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!

Toxic Byte