Re: [GENERAL] Error: "catalog is missing 8 attribute(s) for relid 16683"

2005-03-06 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Something very bad has happened to pg_attribute. Just for a data point, this same problem happened to me on a 8.0 beta database. Actually, only one of 8 databases was affected for that particular backend, but that one was toast and I had to rebuil

Re: [GENERAL] Error: "catalog is missing 8 attribute(s) for relid 16683"

2005-03-02 Thread Tom Lane
"Alexandru Coseru" <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] gateway]# psql -U postgres -h 127.0.0.1 template1 > Welcome to psql 7.4.5, the PostgreSQL interactive terminal. > Type: \copyright for distribution terms >\h for help with SQL commands >\? for help on internal sla

Re: [GENERAL] Error: "catalog is missing 8 attribute(s) for relid

2005-03-02 Thread Edward Macnaghten
Alexandru Coseru wrote: Hello.. Any ideeas ? Fraid so and it is not good. I am no expert in the inner-inner workings of Postgres, but my guess is that your catalogue is, or has been, corrupt. If this is the case it is unrecoverable. It is a matter of rescuing what data you can (using pg_d

[GENERAL] Error: "catalog is missing 8 attribute(s) for relid 16683"

2005-03-02 Thread Alexandru Coseru
Hello.. I've got this error and I don't know how to fix it. Since it's an production database , I can't drop & recreate it..     Here are some infos below..   [EMAIL PROTECTED] gateway]# psql -U postgres  -h 127.0.0.1 template1Welcome to psql 7.4.5, the PostgreSQL interactive terminal.   Ty