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

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


> "Lane, Tom" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>
> 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
>

I tried that, but unfortunately pg_dump still fails to run and the error
message is identical to previous attempts.

Any suggestions for additional logging we might turn on to help
determine the cause of this issue? Our current logging setup uses the
default postgresql.conf setup with the following changes to the logging
section:

log_line_prefix='%t %p %u %h '
log_connections=on

Thanks,
Brendan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Sunavec 2008-01-04 18:49:35 Re: tsearch2 headline options
Previous Message Scott Marlowe 2008-01-04 18:41:22 Re: Fail to connect after server crash