| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Francisco Reyes <lists(at)stringsutils(dot)com> |
| Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_restore out of memory |
| Date: | 2007-06-18 14:42:22 |
| Message-ID: | 1291.1182177742@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Francisco Reyes <lists(at)stringsutils(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2007-06-18 14:43:55 | Re: [SQL] Setting variable |
| Previous Message | Ranieri Mazili | 2007-06-18 14:34:21 | Setting Variable - (Correct) |