Carl Anderson <carl(dot)anderson(at)archimedesmodel(dot)com> writes:
> Running vacuumdb, with and without -f, I get output with final line:
> vacuumdb: vacuuming of database "Validation" failed: ERROR: failed to re-find parent key in index "pg_shdepend_reference_index" for deletion target page 380
You should be able to fix that with REINDEX. However, since it's a
shared catalog index, you'll need to do it in standalone mode.
See the REINDEX and "postgres" reference pages.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2010-08-29 00:29:22|
|Subject: Re: Use hardware snapshots to restore postgres|
|Previous:||From: Carl Anderson||Date: 2010-08-28 18:03:11|
|Subject: vacuumdb: vacuuming of database "Validation" failed: ERROR: failed
to re-find parent key in index...|