pg_dump problem
От | Noel Faux |
---|---|
Тема | pg_dump problem |
Дата | |
Msg-id | 40A1CB2C.4070203@med.monash.edu.au обсуждение исходный текст |
Ответы |
ORDER BY and Unicode
Re: pg_dump problem |
Список | pgsql-novice |
Hi all, We are trying to do a dump of our database using the command line. However, the dump falls over during a dump of a particular table. blast=> \d psiblast_round Table "public.psiblast_round" Column | Type | Modifiers ----------------------+-------------------+----------- id | integer | not null region_db_comparison | integer | round_number | smallint | matrix | character varying | runtime | integer | Indexes: psiblast_round_pkey primary key btree (id), psiblast_round_region_db_comp btree (region_db_comparison), psiblast_round_round_number btree (round_number) Foreign Key constraints: $1 FOREIGN KEY (region_db_comparison) REFERENCES region_db_comparison(id) ON UPDATE NO ACTION ON DELETE NO ACTION The matrix field holds a string which is very long, in some cases ~30K+ char long. The erorr throw is: pg_dump: message type 0x44 arrived from server while idle pg_dump: dumpClasses(): SQL command failed pg_dump: Error message from server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor We are using version: psql (PostgreSQL) 7.3.4-RH Is the var char the best type to hold such a long string and is this likely to be the source of the problem? There is another table which hold similar info, including the matrix field and we are able to dump that without any problems. Any help would be much appreciated. If there is any further info required, I'll do my best to get it :) Cheers Noel
В списке pgsql-novice по дате отправления: