Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 1A2D019DE835 for ; Wed, 7 Mar 2012 13:58:18 -0400 (AST) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S5L7t-0004RN-O3 for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 17:58:16 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Wed, 07 Mar 2012 11:58:00 -0600 Message-Id: <4F574D470200002500045FAB@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Wed, 07 Mar 2012 11:57:59 -0600 From: "Kevin Grittner" To: "Lukasz Brodziak" Cc: "Steve Crawford" , ,"Tom Lane" Subject: Re: pg_attribute file in PostgreSQL 9.0 References: <4F577217.3080204@pinpointresearch.com> <7061.1331132472@sss.pgh.pa.us> <4F579779.9000001@pinpointresearch.com><4F579779.9000001@pinpointresearch.com> <10158.1331141065@sss.pgh.pa.us> In-Reply-To: <10158.1331141065@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201203/31 X-Sequence-Number: 39219 Tom Lane wrote: > Steve Crawford writes: >> On 03/07/2012 09:03 AM, Lukasz Brodziak wrote: >>> Thanks a lot I have found file I needed let's hope I will be >>> able to fix the problem now as I cannot connect to the database >>> because I get 'catalog is missing 1 attribute for relation 2662' >>> which I hope to be able to repair by getting the pg_attribute >>> file from another db. > >> STOP! Don't touch anything just yet. Now we know the real reason >> for the question. > > ... yeah, and this is the wrong answer. It's *exceedingly* > unlikely that plopping in the pg_attribute file from a different > database will accomplish anything except to make matters far > worse. Even if the other DB has exactly the same tables and > exactly the same columns in those tables, it likely doesn't have > the same OID assignments. http://wiki.postgresql.org/wiki/Corruption -Kevin