Re: Superuser lost access to particular database

Francisco Reyes <lists@stringsutils.com> writes:
> Tom Lane writes:
>> SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' ORDER BY 1,2
>> so apparently something is fishy about the dependency data.  Can you
>> execute this query by hand and get results?

> Nothing happens when I try to run the query.

So pg_dump seems off the hook.  Can you run the query, attach to the
backend with gdb, and see what it's doing?

            regards, tom lane