Postgres Pro
Downloads
Home   >   mailing lists

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

From Francisco Reyes
Subject Re: pg_restore out of memory
Date
Msg-id cone.1182166165.989492.8528.1000@zoraida.natserv.net
Whole thread Raw
In response to pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: pg_restore out of memory
List pgsql-general
Tree view 
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..."


Have I encountered a bug?

Looked at the record in question and the length of the long column in that
row is 88885753 (84MB).

Any suggestions?

pgsql-general by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: statistics on CRUD operations
Next
From: "EBIHARA, Yuichiro"
Date:
Subject: standard LOB support