Resource temporarily unavailable
Hi everyone
From time to time i get the following error:
could not fork new process for connection: Resource temporarily unavailable
im using Postgres 7.4.5, with kernel 2.6.2
my conf is:
max_connections = 400
and system is:
www3:/etc/postgresql# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 256
virtual memory (kbytes, -v) unlimited
im totaly bogus, any ideas ?
Thanks
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------
"Ben-Nes Michael" <miki@canaan.co.il> writes:
From time to time i get the following error:
could not fork new process for connection: Resource temporarily unavailable
This generally means that the kernel has run out of memory.
my conf is:
max_connections = 400
Perhaps that is overly optimistic for your available hardware.
regards, tom lane
max_connections = 400
www3:/etc/postgresql# ulimit -a
max user processes (-u) 256
im totaly bogus, any ideas ?
Well, your allowing postgres to have 400 connection which is at least 400 processes if not a few more.
And you are ulimiting the postgres user to 256 processes. So the kernel says out of process space for that user.
Regards
Russell Smith
max_connections = 400
www3:/etc/postgresql# ulimit -a
max user processes (-u) 256im totaly bogus, any ideas ?
Well, your allowing postgres to have 400 connection which is at least 400
processes if not a few more.
And you are ulimiting the postgres user to 256 processes. So the kernel
says out of process space for that user.
Its the default values. can any one hint me where to change this ?
Regards
Russell Smith
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------