| 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-15 11:46:36 |
| Message-ID: | cone.1181907996.308015.90473.1000@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane writes:
> The memory dump only comes out on stderr (I think because of paranoia
> about running out of memory while trying to report we're out of memory).
> Can you get the postmaster's stderr output?
>From stderr
pg_restore: restoring data for table "message_attachments"
pg_restore: [archiver (db)] Error from TOC entry 2146; 0 988154 TABLE DATA
message_attachments pgsql
pg_restore: [archiver (db)] COPY failed: ERROR: out of memory
DETAIL: Failed on request of size 134217728.
CONTEXT: COPY message_attachments, line 60490: "2720290 7225017
research/crew holds.sit sit 88885753 t
1U3R1ZmZJdCAoYykxOTk3LTIwMDIgQWxhZGRpbiBTeX..."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2007-06-15 12:00:11 | Re: pg_restore out of memory |
| Previous Message | Tom Allison | 2007-06-15 10:13:36 | Re: DeadLocks..., DeadLocks... |