From: | "Bruno BAGUETTE" <pgsql-ml(at)baguette(dot)net> |
---|---|
To: | "'PostgreSQL-general'" <pgsql-general(at)postgresql(dot)org> |
Subject: | [REPOST] Problem for dumping a 6.5.2 database |
Date: | 2003-07-03 12:58:10 |
Message-ID: | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAE9MEX6yt8kiI+AfHyR8vwQEAAAAA@baguette.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I'm trying to dump a PostgreSQL 6.5.2. database table in order to add it
in a PostgreSQL 7.3.3 database but I'm encountering some errors :
When I try to do the dump, I get :
[bouchon(at)old_db]$ pg_dump -x -v -u -t tablename -D -f tablename_dump.sql
thedatabasename
Username:
Password:
-- last builtin oid is 17120
-- reading user-defined types
-- reading user-defined functions
getFuncs(): SELECT failed. Explanation from backend: 'pqReadData() --
backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
'.
If I connect to this database via psql and I make a \d tablename I get :
[bouchon(at)old_db]$ psql -u thedatabasename
Username:
Password:
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: thedatabasename
thedatabasename=> \d tablename;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request. thedatabasename=>
But I can do select * from thetablename where pk_id=10 even select *
from tablename without any problems.
I don't understand why the pg_dump is not working... :-(
Can you help me ?
Thanks in advance !
---------------------------------------
Bruno BAGUETTE - pgsql-ml(at)baguette(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Wille | 2003-07-03 14:32:03 | Re: Record locking in deadlock |
Previous Message | Thomas Bamesberger | 2003-07-03 12:51:10 | Re: ERROR: fixrdesc: no pg_class entry for pg_class |