Re: strange behavior (corruption?) of large production

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

Tom Lane wrote:
> 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?
>

As usual, sage advice. That worked -- thanks.

Joe

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-12-03 04:25:23 Re: Numeric 508 datatype
Previous Message Tom Lane 2005-12-03 03:08:59 Re: strange behavior (corruption?) of large production database