Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F09639F9713 for ; Fri, 9 Nov 2007 12:55:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 03500-07 for ; Fri, 9 Nov 2007 12:55:42 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id BDA419F9594 for ; Fri, 9 Nov 2007 12:55:48 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lA9Gti4i011674; Fri, 9 Nov 2007 11:55:45 -0500 (EST) To: Maximilian Tyrtania cc: "pgsql-admin@postgresql.org" Subject: Re: insufficient file descriptors on Mac OS X In-reply-to: References: Comments: In-reply-to Maximilian Tyrtania message dated "Fri, 09 Nov 2007 15:05:05 +0100" Date: Fri, 09 Nov 2007 11:55:44 -0500 Message-ID: <11673.1194627344@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/76 X-Sequence-Number: 27319 Maximilian Tyrtania 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