Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id C970919DE836 for ; Wed, 7 Mar 2012 13:14:49 -0400 (AST) Received: from cerberus.pinpointresearch.com ([66.7.238.130] helo=polaris.pinpointresearch.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S5KRs-00064b-PM for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 17:14:49 +0000 Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id E815AE00EC82; Wed, 7 Mar 2012 09:14:35 -0800 (PST) Message-ID: <4F579779.9000001@pinpointresearch.com> Date: Wed, 07 Mar 2012 09:14:33 -0800 From: Steve Crawford User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19 MIME-Version: 1.0 To: Lukasz Brodziak CC: Tom Lane , pgsql-admin@postgresql.org Subject: Re: pg_attribute file in PostgreSQL 9.0 References: <4F577217.3080204@pinpointresearch.com> <7061.1331132472@sss.pgh.pa.us> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/27 X-Sequence-Number: 39215 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. Do you have an idea what may have caused this? Are there any relevant errors in the log? What is the source of the file that you want to use as a replacement? What version of PG? OS? Is the database able to start? Are you attempting to connect as a superuser? With this as a starting point you may get some valuable advice (though from those people far more capable of answering this question than I). Cheers, Steve