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

FATAL: catalog is missing 1 attribute(s) for relid 16396

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: FATAL: catalog is missing 1 attribute(s) for relid 16396
Date: 2005-01-14 02:12:27
Message-ID: 20050113215944.W45642@ganymede.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Did some searching, and figured/concluded that things are pretty much 
hosed ... the last backup is from June (clients machine, not ours), but 
before I suggest going back to that backup, I want to make sure that I 
haven't overlooked anything ...

What the client did was a 'delete from pg_attribute where ... ' ...

The database is a 7.4.2 one ... my first thought was one of the older 
standbys ... rebuild the schema and move the data files into place over 
top of that ... but of course, 7.3 and beyond are OID based vs name based 
files, so that doesn't work, unless there is some way of figuring out 
which file in the old directory corresponds to while oid-file, and without 
beign able to get into the database to read the system files, thats a wee 
bit difficult ...

Next, figured to try and get in via STAND-ALONE, since I've previously 
dump'd data that way, to reload it ... course, that doesn't work, since I 
still need to be able to read the system tables, which is where this 
problem stems from ...

I'm still searching the 'net to see if there is somethign that I've 
overlooked ... but everything so far is drawing a deadend ... can someone 
suggest a web page I should read, a tool I could use, or something, to get 
the data out of this, that I'm not finding?  Or some way of 'fixing' relid 
16396? :)

Thanks ...



----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664

Responses

pgsql-hackers by date

Next:From: Benjamin AraiDate: 2005-01-14 02:13:13
Subject: Has anybody tried porting PostgreSQL to a "stack machine" or "accumulator machine"?
Previous:From: David FetterDate: 2005-01-14 01:43:31
Subject: Top-k optimizations?

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