Andrew Radamis <rust710(at)gmail(dot)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