pg_dump problem

From: Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Cc: Di Wu <ever_wudi(at)yahoo(dot)com>
Subject: pg_dump problem
Date: 2004-05-12 06:58:52
Message-ID: 40A1CB2C.4070203@med.monash.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sandro Martinez 2004-05-12 07:07:12 ayuda
Previous Message Oliver Fromme 2004-05-11 14:31:43 Re: Darn pop singers!