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