REPOST:Memory Allocation error using pg_dump on 7.4

Started by frank churchabout 20 years ago2 messagesgeneral
Jump to latest
#1frank church
pgsql@adontendev.net

I repeatedly get this error whenever I try to backup a database

The command used is:

pg_dump -Fc -O -U username tablename > tablename.20060122

pg_dump: ERROR: invalid memory alloc request size 4294967290
pg_dump: SQL command to dump the contents of table "cc_ratecard" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid memory alloc request size
4294967290
pg_dump: The command was: COPY public.tablename(id, ...

Is there a bug somewhere in there?

Is there something which needs doing in regard to my memory allocation settings?

The table involved is one of the larger tables, but at only 400,000 records it
shouldn't be a problem.

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: frank church (#1)
Re: REPOST:Memory Allocation error using pg_dump on 7.4

frank church <pgsql@adontendev.net> writes:

I repeatedly get this error whenever I try to backup a database

pg_dump: ERROR: invalid memory alloc request size 4294967290
pg_dump: SQL command to dump the contents of table "cc_ratecard" failed:
PQendcopy() failed.

Looks like a corrupt-data problem to me. Please see the PG list archives
concerning ways to narrow down where the bad data is and get rid of it.

regards, tom lane