Maximilian Tyrtania <mty@xxxxxxxxxxxxxxxx> writes: > <%2007-11-09 14:46:42 CETFATAL: 53000: insufficient file descriptors > available to start server process This is not a shared-memory problem. On my Mac, ulimit -n seems to be 256 by default, and you've got max_connections = 240 so nearly all of those will be eaten by semaphores. You could change the ulimit setting, back off max_connections, or apply this patch: http://archives.postgresql.org/pgsql-committers/2007-09/msg00399.php BTW, if you're really hoping to have 240 connections, you're gonna need to do something about ulimit -u too. $ ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) 6144 file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 256 pipe size (512 bytes, -p) 1 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 100 virtual memory (kbytes, -v) unlimited regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
