Re: pg_restore out of memory

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