Re: Unable to dump database/table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Unable to dump database/table
Date
Msg-id 4906.1097504233@sss.pgh.pa.us
Whole thread Raw
In response to Unable to dump database/table  (Krok <krok@void.ru>)
Responses Re: Unable to dump database/table
List pgsql-bugs
Krok <krok@void.ru> writes:
> pg_dump: dumping contents of table users
> pg_dump: ERROR:  out of memory
> DETAIL:  Failed on request of size 536870920.
> pg_dump: SQL command to dump the contents of table "users" failed:
> PQendcopy() failed.
> pg_dump: Error message from server: ERROR:  out of memory
> DETAIL:  Failed on request of size 536870920.

Looks like corrupt data to me (specifically, a variable-width field
with a ridiculous length word).

You may care to consult the archives regarding methods for dealing with
this sort of problem.  If you're lucky, there's only one bad row ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Justin Clift
Date:
Subject: Re: Buggy timestamp generation code in PG 7.4.5 on FreeBSD
Next
From: Krok
Date:
Subject: Re: Unable to dump database/table