Re: pg_restore out of memory

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore out of memory
Date: 2007-06-18 11:29:25
Message-ID: cone.1182166165.989492.8528.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message EBIHARA, Yuichiro 2007-06-18 11:41:59 standard LOB support
Previous Message Dave Page 2007-06-18 10:24:59 Re: pgadmin3 1.6.3 problem with geom fields