X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 74FF711F6C17 for ; Sun, 23 Apr 2006 17:46:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 92232-03-4 for ; Sun, 23 Apr 2006 17:45:37 -0300 (ADT) X-Greylist: delayed 00:06:38.161915 by SQLgrey- Received: from smtp802.mail.ukl.yahoo.com (smtp802.mail.ukl.yahoo.com [217.12.12.139]) by postgresql.org (Postfix) with SMTP id 3A6D511F6D1E for ; Sun, 23 Apr 2006 17:16:41 -0300 (ADT) Received: (qmail 80526 invoked from network); 23 Apr 2006 20:10:02 -0000 Received: from unknown (HELO ?127.0.0.1?) (bruno.crotos@btinternet.com@86.141.171.247 with plain) by smtp802.mail.ukl.yahoo.com with SMTP; 23 Apr 2006 20:10:02 -0000 Message-ID: <444BDF18.5010608@mail.pt> Date: Sun, 23 Apr 2006 21:10:00 +0100 From: Bruno Cortes User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: FATAL: catalog is missing attributes Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 0616-4, 2006-04-21), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.199 tagged_above=0 required=5 tests=BAYES_40, SPF_SOFTFAIL X-Spam-Level: * X-Archive-Number: 200604/235 X-Sequence-Number: 21404 Hi, I was trying to make a dump from a database in postgresql 7.4.2-1. I was enable to do so because of a cache lookup problem. To solve it, I enter the database as superuser and execute VACUUM ALL. This was even worse than the previous error. Right now I cannot enter the database neither make a dump. When I execute a command such as "psql -U postgres center-01" I get the error: psql: FATAL: catalog is missing 10 attribute(s) for relid 1262 Since the backup it too old, I must enter this production DB and extract the data but it is unavailable. I look at similar threads in the archives but all the solutions assume that it is possible to access the database and this is not my case. Can anyone help on this? Thanks in advance Bruno Cortes