Re: pg_restore out of memory

Gregory Stark writes:

> What does the output of "ulimit -a" show?

In FreeBSD, as far as I know, what controls the size of a program is the
/boot/loader.conf and /etc/login.conf

The default /etc/login.conf has unlimited size.
/boot/loader.conf is set to max program size of 1.6GB

> Can you arrange to run ulimit -a in
> the same environment as the server?

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:

core file size (blocks, -c) unlimited
data seg size (kbytes, -d) 524288
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 11095
pipe size (512 bytes, -p) 1
stack size (kbytes, -s) 65536
cpu time (seconds, -t) unlimited
max user processes (-u) 5547
virtual memory (kbytes, -v) unlimited

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