Re: pg_restore out of memory

"Francisco Reyes" <lists@stringsutils.com> writes:

> kern.maxdsiz="1600MB" #1.6GB
> kern.dfldsiz="1600MB" #1.6GB
> kern.maxssiz="128M" # 128MB

It ought to be maxdsiz which seems large enough.

> The error that I got was:
> 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 (128MB)

What does the output of "ulimit -a" show? Can you arrange to run ulimit -a in
the same environment as the server? Either by starting the server in shell
manually or by putting ulimit -a in the startup script which starts the server
if you have one?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com