Skip site navigation (1) Skip section navigation (2)

Re: pg_attribute file in PostgreSQL 9.0

From: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_attribute file in PostgreSQL 9.0
Date: 2012-03-07 17:49:12
Message-ID: CAGWYGjUCAmG0H_aL6-G_pdCUh7c+PmNfASfu_4KHAa+jy9rasA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Ok, so the case is that I don't have the exact cause of the problem as
it occured on one of our clients dbs. The PG version is 9.0.0 and the
OS is windows XP. The DB is able to start (I have the data folder) but
when I connect to the db from our application (or pgAdmin) I come
across the above mentioned error. I have managed to get into the
database after replacing the pg_attribute from another DB (clean db
created with our installer) but then I read Your mail so I stopped at
this point. Pg_log has only this one information on the error.

2012/3/7 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Steve Crawford <scrawford(at)pinpointresearch(dot)com> 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



-- 
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-03-07 17:57:59
Subject: Re: pg_attribute file in PostgreSQL 9.0
Previous:From: Walter HurryDate: 2012-03-07 17:41:41
Subject: Re: table names seem identical

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group