X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1AAB99DC8AC for ; Sat, 18 Mar 2006 22:14:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82137-10 for ; Sat, 18 Mar 2006 22:14:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181]) by postgresql.org (Postfix) with ESMTP id E7DCB9DCD9C for ; Sat, 18 Mar 2006 22:14:49 -0400 (AST) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx2.surnet.cl with ESMTP; 18 Mar 2006 22:14:54 -0400 X-IronPort-AV: i="4.02,198,1139194800"; d="scan'208"; a="37397100:sNHT18216236" Received: from alvh.no-ip.org (201.220.123.157) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 43A978FD00AEF99D; Sat, 18 Mar 2006 22:14:54 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id C89F2C3A2DC; Sat, 18 Mar 2006 22:14:53 -0400 (CLT) Date: Sat, 18 Mar 2006 22:14:53 -0400 From: Alvaro Herrera To: marco Cc: pgsql-admin@postgresql.org Subject: Re: table disappear from pg_class Message-ID: <20060319021453.GB883@surnet.cl> Mail-Followup-To: marco , pgsql-admin@postgresql.org References: <1142410606.11594.24.camel@pestatasti.sys> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1142410606.11594.24.camel@pestatasti.sys> User-Agent: Mutt/1.5.11+cvs20060126 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.703 required=5 tests=[AWL=-0.216, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.703 X-Spam-Level: * X-Archive-Number: 200603/151 X-Sequence-Number: 20908 marco wrote: > Hi all, > I have a problem with a table which is disappeared from pg_class > with all objects related (views, indexes and so on). > pg_dump against this table does not work (I think because it is not > present in pg_class). > > The strange behaviour is that I can select data from this table !! This sounds very much like transaction Id wraparound, meaning you failed to vacuum pg_class (and possibly other system catalogs as well) in a timely fashion. Basically you need to return the transaction counter a little bit, then vacuum and make sure all your data is still consistent. This has been discussed before. See for example: http://archives.postgresql.org/pgsql-bugs/2005-05/msg00079.php -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.