Good mornin,
Last night my computer crashed and after restart the postgresql
database claims about an error. Yes, I DO have a backup, but this lacks
about 2 days which I like to recover.
The error-message is:
ERROR: Index pg_proc_oid_index is not a btree
The pg_proc_oid_index file in the data/base/ directory has the size 0
Bytes - which I think is not correct.
I still can connect to the database. After a few error messages it somehow
works. But I still can't do a "vacuum" as the error rises again.
I guess in the file "pg_proc_oid_index" should be the index. So how can I
recreate the index again so that it works fine again?
So long,
Holger Mitterwald
--
Holger Mitterwald
Kneipenfuehrer Deutschland pub guide germany
http://www.mitterwald.de/kneipen/
