Re: pg_restore out of memory

"Francisco Reyes" <lists(at)stringsutils(dot)com> writes:

> There is no "ulimit -a" in cshell which is what I use.
> I guessed this may be a bash setting .. so tried that..
> The output of ulimit -a is:

The csh equivalent is just "limit".

> core file size (blocks, -c) unlimited
> data seg size (kbytes, -d) 524288

>
> Don't see any limit at 128MB, the size at which the program crashed.

You might try starting Postgres with
ulimit -d unliited
or
limit datasize unlimit

You're right that your limit is above 128M but the error just means it tried
to allocated 128M and failed, it may already have allocated 400M and been
trying to go over the 524M mark.

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