Thread: could not open relation with OID 2610

could not open relation with OID 2610

From
Maja Massarini
Date:
I'm no more able to connect to a database and the error is:

FATAL: could not open relation with OID 2610

The database was running inside a vmware virtual machine, the operating
system is Ubuntu server 8.04 and the postgresql version is 8.3.

I still can't figure out what happened more than a month ago and since
so long time passed we have no backups for it.

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.

There is anything I can do to try to fix it?

Thanks,

maja


Re: could not open relation with OID 2610

From
Tom Lane
Date:
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