Re: index "pg_authid_rolname_index" is not a btree

Andrus Moor wrote:
> Hard disk containing PostgreSql 8.1 database on Windows crashes and
> there was no new
> backup copy.
>
> I installed 8.1.9 to new computer and copied data directory from
> crashed disk to it.
> data directory contains a lot of files with a lot of data.
>
> Trying to connect to template0 or any other database in this cluster causes
> error
>
> Error connecting to the server: FATAL:  index "pg_authid_rolname_index" is
> not a btree

You can get around that particular problem by reindexing the pg_authid
table.  But my guess is that you'll find that there's corruption
elsewhere that's not so easily recoverable ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support