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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
