Problems with missing OIDs
От | Alexander Lohse |
---|---|
Тема | Problems with missing OIDs |
Дата | |
Msg-id | 043A7BA3-8C72-4D9C-B7DD-52B183A2B313@humantouch.de обсуждение исходный текст |
Ответы |
Re: Problems with missing OIDs
|
Список | 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
В списке pgsql-admin по дате отправления: