Re: Out of Memory errors while running pg_dump - Mailing list pgsql-general

From Erik Jones
Subject Re: Out of Memory errors while running pg_dump
Date
Msg-id D5302D19-8856-439A-8BD8-C2FE17CD395E@myemma.com
Whole thread Raw
In response to Re: Out of Memory errors while running pg_dump  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL 8.3.0 RPMs are available for download
Next
From: Greg Smith
Date:
Subject: Re: postgresql book - practical or something newer?