Postgres Pro
Downloads
Home   >   mailing lists

index "pg_authid_rolname_index" is not a btree - Mailing list pgsql-general

From Andrus Moor
Subject index "pg_authid_rolname_index" is not a btree
Date
Msg-id 51C17B3FEC054840871D23521685FBDD@andrusnotebook
Whole thread Raw
Responses Re: index "pg_authid_rolname_index" is not a btree  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: There are procedures in Postgres 8.3?
Next
From: Pavel Stehule
Date:
Subject: Re: There are procedures in Postgres 8.3?