Re: PANIC: could not open critical system index 2662

C GG <cgg0007@gmail.com> writes:
> When trying to restart the PostgreSQL 9.2 database for our JIRA
> installation, we're getting
> "PANIC:  could not open critical system index 2662" ... I've tried various
> things like turning on zero_damaged_pages but postmaster still crashes on
> connect when attempting to pg_dump.

2662 is pg_class_oid_index :-(

Try starting a single-user backend with the ignore-system-indexes flag,
and doing "REINDEX INDEX pg_class_oid_index".  If that works, I'd try
reindexing the rest of the system just to see how bad things are.

If that doesn't work, it's time to hire professional help --- there are
several companies that specialize in PG data recovery.

                        regards, tom lane