FATAL: catalog is missing attributes

From: Bruno Cortes <bcc(at)mail(dot)pt>
To: pgsql-admin(at)postgresql(dot)org
Subject: FATAL: catalog is missing attributes
Date: 2006-04-23 20:10:00
Message-ID: 444BDF18.5010608@mail.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I was trying to make a dump from a database in postgresql 7.4.2-1. I was
enable to do so because of a cache lookup problem.
To solve it, I enter the database as superuser and execute VACUUM ALL.
This was even worse than the previous error. Right now I cannot enter
the database neither make a dump. When I execute a command such as "psql
-U postgres center-01" I get the error:
psql: FATAL: catalog is missing 10 attribute(s) for relid 1262

Since the backup it too old, I must enter this production DB and extract
the data but it is unavailable. I look at similar threads in the
archives but all the solutions assume that it is possible to access the
database and this is not my case.

Can anyone help on this?
Thanks in advance
Bruno Cortes

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ottó Havasvölgyi 2006-04-23 21:01:47 Re: sorry which is the best
Previous Message Devrim GUNDUZ 2006-04-22 10:22:56 Re: GFS and postgresql