Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: catalog is missing 9 attribute(s) for relid 10297 - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: catalog is missing 9 attribute(s) for relid 10297
Date
Msg-id 16843.1199462347@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: catalog is missing 9 attribute(s) for relid 10297  ("O'Shea, Brendan" <boshea@akamai.com>)
Responses Re: ERROR: catalog is missing 9 attribute(s) for relid 10297
List pgsql-general
Tree view 
"O'Shea, Brendan" <boshea@akamai.com> writes:
> pg_dump: reading schemas
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  catalog is missing 9
> attribute(s) for relid 10297

Ugh.  Does it work if you do

    export PGOPTIONS="--ignore_system_indexes=1"

first?  If so, the problem would evidently be corruption of the indexes
for pg_attribute, specifically pg_attribute_relid_attnum_index.  It
seems pretty suspicious that lightning would strike twice in the same
place ...

            regards, tom lane

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tsearch2 headline options
Next
From: Bruce Momjian
Date:
Subject: Re: Mandatory AS keyword in SELECT statements