Re: pg_restore out of memory - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore out of memory
Date
Msg-id 1291.1182177742@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Ranieri Mazili
Date:
Subject: Setting Variable - (Correct)
Next
From: Michael Glaesemann
Date:
Subject: Re: [SQL] Setting variable