X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BDE59D1B21B for ; Fri, 18 Jun 2004 12:52:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45308-01 for ; Fri, 18 Jun 2004 15:52:26 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 77C18D1B241 for ; Fri, 18 Jun 2004 12:52:25 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5IFqNl6021058; Fri, 18 Jun 2004 11:52:23 -0400 (EDT) To: Bruno THOMAS Cc: pgsql-admin@postgresql.org Subject: Re: pg_class corrupted ? In-reply-to: <40D18921.3000609@alea.fr> References: <40D18921.3000609@alea.fr> Comments: In-reply-to Bruno THOMAS message dated "Thu, 17 Jun 2004 14:05:53 +0200" Date: Fri, 18 Jun 2004 11:52:22 -0400 Message-ID: <21057.1087573942@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/230 X-Sequence-Number: 13890 Bruno THOMAS writes: > My problem is that when I tried to make a dump of the copied DB for a > new backup I've had the following error : > pg_dump: query to obtain list of tables failed: ERROR: Relation > pg_class does not have attribute 1 Reindexing pg_class might help. Read the reindex man page carefully, because reindexing system tables is a tricky procedure before 7.4. > PS: postresql version is 7.2.1 You like to live dangerously, eh? There are several known serious bugs in 7.2.1. If you want to stay on the 7.2 series you should at least update to 7.2.4 (or whatever the last of that series was). regards, tom lane