Postgres Pro
Downloads
Home   >   mailing lists

Re: strange behavior (corruption?) of large production database - Mailing list pgsql-hackers

From Tom Lane
Subject Re: strange behavior (corruption?) of large production database
Date
Msg-id 10957.1133579339@sss.pgh.pa.us
Whole thread Raw
In response to strange behavior (corruption?) of large production database  (Joe Conway <mail@joeconway.com>)
Responses Re: strange behavior (corruption?) of large production  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Tree view 
Joe Conway <mail@joeconway.com> writes:
> cyspec=# vacuum freeze pg_catalog.pg_class;
> ERROR:  failed to re-find parent key in "pg_class_relname_nsp_index"

> It seems that we cannot vacuum pg_class, because vacuum itself fails. 
> Any suggestions on how to bootstrap the fixing of pg_class?

REINDEX?
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Charles F. I. Savage"
Date:
Subject: Building Windows Server Extensions Using VC++ 2005
Next
From: Joe Conway
Date:
Subject: Re: strange behavior (corruption?) of large production