Problems with missing OIDs

From: Alexander Lohse <al(at)humantouch(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problems with missing OIDs
Date: 2007-11-02 22:11:07
Message-ID: 043A7BA3-8C72-4D9C-B7DD-52B183A2B313@humantouch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

after a disk-crash some weeks ago and a successful recovery, I now
find some strange issues in postgres.
I am not sure they are related to the crash, but I figure chances
are ...

One of them is: When trying to vacuum one database I get the following
message:
"ERROR: could not open relation with OID 36893600"
After browsing the archives I found similar threads and possible
recovery methods.

So, I already reindexed and vacuumed all pg_catalog, with no effect.

Now I searched and found a row in pg_index with

indexrelid => 36893600

Is it save to just drop this row? Or how do I find out which index is
affected?

Any help is very much apprechiated as this seems to affect our backup-
dumping as well!

Best regards,

Alex
______________________________________________________________

Alexander Lohse • Entwicklungsleitung & Projektmanagement
Tel +49 38374 752 11 • Fax +49 38374 752 23
http://www.humantouch.de

Human Touch Medienproduktion GmbH
Am See 1 • 17440 Klein Jasedow • Deutschland

Geschäftsführung:
Lara Mallien, Nele Hybsier, Alexander Lohse, Johannes Heimrath (Senior)
Handelsregister Stralsund • HRB 4192 • USt-IdNr. DE128367684

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2007-11-02 22:38:50 schema privilege question
Previous Message Alvaro Herrera 2007-11-02 19:30:52 Re: how to check objects dependency??