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
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?? |