Re: Almost all access to database hangs (fwd)

"Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> writes:
>> However, if \dt hangs, the problem is probably in a system index;
>> pg_class has two indexes: pg_class_oid_index and pg_class_relname_index.

> I can do a select * on pg_class, but that's it. Anything else I tried
> hangs.

Sounds like a job for REINDEX. I have not had to do this myself, but
I think the procedure is (a) stop postmaster, (b) start a standalone
backend with -O -P, (c) tell it to REINDEX DATABASE. Not sure about
that, especially about the switches to start the backend with. Read
the documentation.

regards, tom lane