Re: Out of Memory errors while running pg_dump

On Feb 5, 2008, at 4:28 PM, Jeff Davis wrote:

> On Mon, 2008-02-04 at 16:11 -0600, Erik Jones wrote:
>>> Are you sure the postmaster is being launched
>>> under ulimit unlimited?
>>
>> ulimit -a gives:
>>
>> core file size        (blocks, -c) unlimited
>> data seg size         (kbytes, -d) unlimited
>> file size             (blocks, -f) unlimited
>> open files                    (-n) 256
>> pipe size          (512 bytes, -p) 10
>> stack size            (kbytes, -s) 10240
>> cpu time             (seconds, -t) unlimited
>> max user processes            (-u) 16357
>> virtual memory        (kbytes, -v) unlimited
>>
>
> If you are using FreeBSD, is it possible you ran into the kern.maxdsiz
> kernel tunable? It can only be adjusted at boot, I think.

We're on Solaris.

Erik Jones

DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com