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.