Re: strange behavior (corruption?) of large production database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: strange behavior (corruption?) of large production database
Date: 2005-12-03 03:08:59
Message-ID: 10957.1133579339@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joe Conway <mail(at)joeconway(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2005-12-03 03:33:21 Re: strange behavior (corruption?) of large production
Previous Message Jim C. Nasby 2005-12-03 02:28:08 Re: 8.1, OID's and plpgsql