Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 5BA6E19DE836 for ; Wed, 7 Mar 2012 13:24:41 -0400 (AST) Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S5KbQ-0006MQ-BY for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 17:24:40 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q27HOPFV010159; Wed, 7 Mar 2012 12:24:25 -0500 (EST) To: Steve Crawford cc: Lukasz Brodziak , pgsql-admin@postgresql.org Subject: Re: pg_attribute file in PostgreSQL 9.0 In-reply-to: <4F579779.9000001@pinpointresearch.com> References: <4F577217.3080204@pinpointresearch.com> <7061.1331132472@sss.pgh.pa.us> <4F579779.9000001@pinpointresearch.com> Comments: In-reply-to Steve Crawford message dated "Wed, 07 Mar 2012 09:14:33 -0800" Date: Wed, 07 Mar 2012 12:24:25 -0500 Message-ID: <10158.1331141065@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/28 X-Sequence-Number: 39216 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. regards, tom lane