Holger Mitterwald wrote:
>
> 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?
Well. Try to
create index proc_tmp on pg_proc (oid);
Now cd to database dir and cp proc_tmp to pg_proc_oid_index and
drop index proc_tmp;
Let's know if it helps.
Vadim
