pg_dump problem

Поиск
Список
Период
Сортировка
От Noel Faux
Тема pg_dump problem
Дата
Msg-id 40A1CB2C.4070203@med.monash.edu.au
обсуждение исходный текст
Ответы ORDER BY and Unicode  ("M. Bastin" <marcbastin@mindspring.com>)
Re: pg_dump problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Fromme
Дата:
Сообщение: Re: Darn pop singers!
Следующее
От: Sandro Martinez
Дата:
Сообщение: ayuda