pg_dump failed

From: Milan Krajnak <milan_krajnak(at)abilitydev(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump failed
Date: 2003-12-12 09:49:34
Message-ID: 3FD98F2E.7070309@abilitydev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hello,

i've got the following problem:
OS - Solaris 8/9 on Sun SPARC
PGSQL 7.1.3

when i try to dump the database with pg_dump command i've got the
following error:

-- last builtin oid is 18539
-- reading user-defined types
-- reading user-defined functions
-- reading user-defined aggregates
-- reading user-defined operators
-- reading user-defined tables
getTables(): SELECT failed. Explanation from backend: 'pqReadData() --
backend
closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
'.

the same error appears when a try to display the database schema using
\d in psql shell e.g.

$ psql -U user db
psql# \d
getTables(): SELECT failed. Explanation from backend: 'pqReadData() --
backend
closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
'.

but when a type:
psql# \d table_name
everything works fine ...

what's wrong ?
pg_dump is really really really important for me ... thanx in advance ...

--
Milan Krajnak
senior software architect
e-mail: milan_krajnak(at)abilitydev(dot)com
phone: +421 2 50267546
fax : +421 2 50267500
Ability Development SK
http://www.abilitydev.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rhaoni Chiu Pereira 2003-12-12 12:39:59 ODBC Driver generates a too big "windows swap file" and it's too slow
Previous Message Olivier Hubaut 2003-12-12 08:11:55 How to disconnect a user?