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