From: Steve Crawford <scrawford@pinpointresearch.com>
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_attribute file in PostgreSQL 9.0
Date: Wed, 07 Mar 2012 09:14:33 -0800
Message-ID: <4F579779.9000001@pinpointresearch.com> (raw)
In-Reply-To: <CAGWYGjUfH038Q6eKDLtfk+5RaXkbVvFmRB3C+LvCsPUpnYW9uw@mail.gmail.com>
References: <CAGWYGjX4Lcu19BKFgX+ttz7bHypd1j-WbP98S_GGUSGe_VtBew@mail.gmail.com>
<4F577217.3080204@pinpointresearch.com>
<7061.1331132472@sss.pgh.pa.us>
<CAGWYGjUfH038Q6eKDLtfk+5RaXkbVvFmRB3C+LvCsPUpnYW9uw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, lukasz.brodziak@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: pg_attribute file in PostgreSQL 9.0
In-Reply-To: <4F579779.9000001@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox