Re: pg_restore out of memory - Mailing list pgsql-general

From Francisco Reyes
Subject Re: pg_restore out of memory
Date
Msg-id cone.1181866011.327885.38963.5001@35st.simplicato.com
Whole thread Raw
In response to pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: pg_restore out of memory  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Tom Allison
Date:
Subject: Re: DeadLocks..., DeadLocks...
Next
From: Tom Allison
Date:
Subject: Re: DeadLocks..., DeadLocks...