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

2008-01-08 Thread O'Shea, Brendan
> "Lane, Tom" <[EMAIL PROTECTED]> 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 su

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

2008-01-08 Thread O'Shea, Brendan
"Lane, Tom" <[EMAIL PROTECTED]> writes:> > "O'Shea, Brendan" <[EMAIL PROTECTED]> writes: > >> "Lane, Tom" <[EMAIL PROTECTED]> writes: > >> Ugh. Does it work if you do > >> export PGOPTIONS="--ignore_system_indexes=1" > > > I tried that, but unfortunately pg_dump still fails to run > and the err

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

2008-01-04 Thread Tom Lane
"O'Shea, Brendan" <[EMAIL PROTECTED]> writes: >> "Lane, Tom" <[EMAIL PROTECTED]> writes: >> Ugh. Does it work if you do >> export PGOPTIONS="--ignore_system_indexes=1" > I tried that, but unfortunately pg_dump still fails to run and the error > message is identical to previous attempts. Huh. So

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

2008-01-04 Thread Tom Lane
"O'Shea, Brendan" <[EMAIL PROTECTED]> 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

[GENERAL] ERROR: catalog is missing 9 attribute(s) for relid 10297

2008-01-04 Thread O'Shea, Brendan
We have run into a situation where our postgresql 8.2.5 database appears to be corrupt and we are no longer able to run pg_dump. We don't know what is causing the data corruption issues and unfortunately this is one of those cases where we cannot reliably reproduce the problem (so no test case can