Re: pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)

Tom Lane wrote:
> "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com> writes:
>> Is there any solution to this other than adding memory, or am I
>> mis-understanding the error?
>
>> pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)
>> pg_dump: lost synchronization with server, resetting connection
>
> My bet is that this is actually a corrupt-data problem ...
> unless you actually have any 875MB fields in your table. The
> implication is that the length word of a variable-width field
> contains garbage. More than likely, the whole tuple is
> garbaged, but this happens to be the first visible symptom.
>
> There is plenty of discussion of recovering from data
> corruption in the archives, so go have a look.
>
>> v7.2.3 on RHAT 7.3 linux with 128MB RAM.
>
> Might want to think about an update sometime, too ;-)
>
> regards, tom lane

No, no 875MB fields -- the largest field is limited to 2048 chars.
Heading to the archives.

thanks,

reid