| View previous topic :: View next topic |
| Author |
Message |
sergioag
n00b
Joined: 08 Nov 2007
Posts: 20
|
 Posted: Mon Oct 19, 2009 5:11 pm Post subject: PostgreSQL shows "could not fork new process" |
 |
|
Hi
I'm running a server that uses PostgreSQL 8.2.7 (dev-db/postgresql-8.2.7) for use with the Adempiere ERP. All is working fine except that whenever the "postgres" user has 30 running processes (which with Adempiere's connection pooling means a maxium of 3 users) is starts to refuse new connections and the log shows this errors:
| Code: | LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork new process for connection: Resource temporarily unavailable
LOG: could not fork autovacuum process: Resource temporarily unavailable
LOG: could not fork autovacuum process: Resource temporarily unavailable
|
I have tried setting nproc in /etc/security/limits.conf, recompiling postgresql with and without the "pam" use flag. Running "ulimit -u" shows 400, but still no luck.
Any ideas?
Thanks
Sergio Aguayo |
|
| Back to top |
|
 |
gerdesj
l33t
Joined: 29 Sep 2005
Posts: 621
Location: Yeovil, Somerset, UK
|
| Posted: Wed Oct 28, 2009 12:48 am Post subject: Re: PostgreSQL shows "could not fork new process" |
|
|
Any output from "dmesg" or in /var/log/messages?
Cheers
Jon |
|
| Back to top |
|
|
|
Other Things Gentoo
