Re: FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1 - Mailing list pgsql-general

Andrew Radamis <rust710@gmail.com> writes:
> I'm getting this error when I try to log into my database.
> *FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1

You've got a corrupted index.  You can probably fix it like this:

    export PGOPTIONS="-P"
    psql ..usual options..
    reindex index pg_class_oid_index;

After that, a dump/initdb/reload might be in order, since it's hard to
tell whether there are other problems lurking.  Some testing of your
hardware might be advisable too; and I'd suggest updating your Postgres
if it's not a recent release.

            regards, tom lane