| From: | Erik Jones <erik(at)myemma(dot)com> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Out of Memory errors while running pg_dump |
| Date: | 2008-02-06 04:00:31 |
| Message-ID: | D5302D19-8856-439A-8BD8-C2FE17CD395E@myemma.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)myemma(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-02-06 04:07:37 | Re: postgresql book - practical or something newer? |
| Previous Message | Joshua D. Drake | 2008-02-06 02:34:38 | Re: PostgreSQL 8.3.0 RPMs are available for download |