index "pg_authid_rolname_index" is not a btree

From: "Andrus Moor" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: index "pg_authid_rolname_index" is not a btree
Date: 2009-08-18 12:35:49
Message-ID: 51C17B3FEC054840871D23521685FBDD@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

How to recover data from this cluster ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2009-08-18 12:48:19 Re: There are procedures in Postgres 8.3?
Previous Message John R Pierce 2009-08-18 12:24:52 Re: Best database model for canvassing (and analysing) opinion