Andrew Radamis <rust...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
