Francisco Reyes <lists@stringsutils.com> writes:
> Tried a pg_dump without -Fc to see if I could get that one table loaded.
> Still failed.
> psql:message-attachments-2007-06-15.sql:2840177: ERROR: out of memory
> DETAIL: Failed on request of size 88885765.
> CONTEXT: COPY message_attachments, line 60660: "2720290 7225017
> research/crew holds.sit sit 88885753 t 1
> U3R1ZmZJdCAoYykxOTk3LTIwMDIgQWxhZGRpbiBTeX..."
> Looked at the record in question and the length of the long column in that
> row is 88885753 (84MB).
If that actually is the length of the line, the only answer is to raise
the memory ulimit setting the postmaster runs under.
regards, tom lane