Re: could not open relation with OID 2610 - Mailing list pgsql-admin

From Tom Lane
Subject Re: could not open relation with OID 2610
Date
Msg-id 11367.1253673880@sss.pgh.pa.us
Whole thread Raw
In response to could not open relation with OID 2610  (Maja Massarini <m.massarini@crscasa.it>)
List pgsql-admin
Maja Massarini <m.massarini@crscasa.it> writes:
> I'm no more able to connect to a database and the error is:
> FATAL: could not open relation with OID 2610

Ugh ... OID 2610 is pg_index.  It's a tad critical :-(

> Since I can't connect to the database I can't reindex the system tables.
> I just tried to connect to the database with the --single and -P options
> but without success.

That's what I would have tried.  I'm afraid the DB is probably toast,
if that didn't work.  You could try tracing the startup with a debugger
to see where it goes wrong, but getting anything out of it is going to
require serious amounts of work, with no guarantee of success.  How
desperate are you?

            regards, tom lane

pgsql-admin by date:

Previous
From: edino
Date:
Subject: could not send data to client: Broken pipe
Next
From: Tom Lane
Date:
Subject: Re: db size and tables size difference