Re: pg_restore out of memory

Tom Lane writes:

> Can we see the context-sizes dump that should've come out right before
> that in the log?

Hope this is what you are looking for.
Included a few lines before the error in case that is of any help.
These lines are from the postgresql log. Redirected stderr to a file.


pg_amop_opr_opc_index: 1024 total in 1 blocks; 328 free (0 chunks); 696 used
pg_amop_opc_strat_index: 1024 total in 1 blocks; 216 free (0 chunks); 808
used

pg_aggregate_fnoid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632
used

MdSmgr: 8192 total in 1 blocks; 6616 free (0 chunks); 1576 used

LOCALLOCK hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used

Timezones: 48616 total in 2 blocks; 5968 free (0 chunks); 42648 used

ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
ERROR:  53200: 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       1
               U3R1ZmZJdCAoYykxOTk3LTIwMDIgQWxhZGRpbiBTeX..."
LOCATION:  AllocSetRealloc, aset.c:907
STATEMENT:  COPY message_attachments (attachment_id, message_id, filename,
extension, attachment_size, name_real, parser_version,
attachment_search_text, attachment_body, delete_status, delete_status_date)
FROM stdin;


The table has no insert triggers, but does have a Foreign-key constraint.
"message_attachments_message_id_fkey" FOREIGN KEY (message_id) REFERENCES
messages(message_id)

It also has 3 indexes and 2 check constraints.