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 D1B7511F74C9 for ; Mon, 24 Apr 2006 15:08:20 -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 50316-02-2 for ; Mon, 24 Apr 2006 15:08:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by postgresql.org (Postfix) with ESMTP id 0C7AD11F8E39 for ; Mon, 24 Apr 2006 09:43:26 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 24 Apr 2006 08:43:27 -0400 X-IronPort-AV: i="4.04,151,1144036800"; d="scan'208"; a="56149178:sNHT18457144" Received: from alvh.no-ip.org (200.126.100.190) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 443B7DDC001ABE45; Mon, 24 Apr 2006 08:43:26 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 4D914C30F8E; Mon, 24 Apr 2006 08:43:26 -0400 (CLT) Date: Mon, 24 Apr 2006 08:43:26 -0400 From: Alvaro Herrera To: Bruno Cortes Cc: pgsql-admin@postgresql.org Subject: Re: FATAL: catalog is missing attributes Message-ID: <20060424124326.GB13361@surnet.cl> Mail-Followup-To: Bruno Cortes , pgsql-admin@postgresql.org References: <444BDF18.5010608@mail.pt> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <444BDF18.5010608@mail.pt> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/241 X-Sequence-Number: 21410 Bruno Cortes wrote: > 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 Sounds very much like you haven't been doing the required vacuum on all system catalogs. Look for "transaction Xid wraparound" for possible suggestions. For example look at http://archives.postgresql.org/pgsql-bugs/2005-05/msg00079.php -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support