Re: pg_dump failed - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump failed
Date
Msg-id 19917.1071243588@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump failed  (Milan Krajnak <milan_krajnak@abilitydev.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Greg Spiegelberg
Date:
Subject: Reindex database
Next
From: Sai Hertz And Control Systems
Date:
Subject: Tables Without OIDS and its effect