Re: pg_dump failed

Milan Krajnak <milan_krajnak@abilitydev.com> writes:
> psql# \d
> getTables(): SELECT failed.  Explanation from backend: 'pqReadData() --
> backend
> closed the channel unexpectedly.

Standard questions: what shows up in the postmaster's log (stderr or
syslog depending on your setup) when this happens?  Is there a core
file dropped in the database subdirectory ($PGDATA/base/something/)?
If so, please get a debugger backtrace from it.

I get the impression that there may be corrupt data in your pg_class
file --- can you do "select * from pg_class" without a crash?
How about pg_user and pg_rewrite?

            regards, tom lane