Re: ERROR: catalog is missing 9 attribute(s) for relid 10297

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "O'Shea, Brendan" <boshea(at)akamai(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: catalog is missing 9 attribute(s) for relid 10297
Date: 2008-01-04 15:59:07
Message-ID: 16843.1199462347@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"O'Shea, Brendan" <boshea(at)akamai(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Naz Gassiep 2008-01-04 16:20:54 Hash Indexes
Previous Message Bruce Momjian 2008-01-04 15:58:40 Re: Mandatory AS keyword in SELECT statements