From: | Joe Lester <joe_lester(at)sweetwater(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: No More Processes |
Date: | 2004-02-12 04:11:50 |
Message-ID: | 955C99DA-5D11-11D8-90A2-000A95A58EA0@sweetwater.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
kern.maxprocperuid.... It's on OS 10.3 but not on 10.2 as far as I can
see. Anyway, I upgraded the box to 10.3.2. Then I set
kern.maxprocperuid in /etc/sysctl.conf... that seems to have done the
trick.
kern.maxprocperuid=512
Then I applied ulimit -u 512 at the shell level. It's working now.
Thanks.
On Feb 11, 2004, at 6:30 PM, Tom Lane wrote:
> Joe Lester <joe_lester(at)sweetwater(dot)com> writes:
>> I'm trying to run PostgreSQL 7.4.1 on Mac OS 10.2.6. I'm running into
>> problems when the number of process for the postgres user reaches 100.
>> When that happens I get a "No More Processes" message in the terminal
>> shell. From then on, that user is "locked". I can't even ssh into it.
>
> I think there is a sysctl setting that limits this; have you increased
> that?
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | muteki muteki | 2004-02-12 06:08:30 | Re: pg_class and relfilenode |
Previous Message | Tom Lane | 2004-02-12 03:14:54 | Re: Is a capital letters title for this ML blocked? |