Hello,
I am trying to determine what might cause an issue like this. This was a large (several hundred GB) data warehouse server with PG 8.2.4. I can't really determine what caused this issue. We ended up restoring the data from a backup.
Here are some of the errors in the log:
postmaster.1:Jul 11 14:13:36 postgres[18051]: [8-1] ERROR: cache lookup failed for operator 660postmaster.1:Jul 11 15:27:00 postgres[26428]: [2-1] ERROR: cache lookup failed for operator 93
Attempting to list the tables using psql:
#\dt
ERROR: operator does not exist: oid = oid
LINE 6: JOIN pg_catalog.pg_roles r ON r.oid = c.relowner
^
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.
Deron