[REPOST] Problem for dumping a 6.5.2 database
От | Bruno BAGUETTE |
---|---|
Тема | [REPOST] Problem for dumping a 6.5.2 database |
Дата | |
Msg-id | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAE9MEX6yt8kiI+AfHyR8vwQEAAAAA@baguette.net обсуждение исходный текст |
Ответы |
Re: [REPOST] Problem for dumping a 6.5.2 database
Re: [REPOST] Problem for dumping a 6.5.2 database |
Список | 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@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@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@baguette.net
В списке pgsql-general по дате отправления: