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 660 postmaster.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