Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 092E59F96CC for ; Fri, 9 Nov 2007 10:05:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 36640-03 for ; Fri, 9 Nov 2007 10:05:01 -0400 (AST) Received: from fischerappelt.de (mail.fischerappelt.de [217.110.127.211]) by postgresql.org (Postfix) with ESMTP id 8AEBE9F96C3 for ; Fri, 9 Nov 2007 10:05:08 -0400 (AST) Received: from [217.110.127.209] (account mty HELO [192.168.111.194]) by fischerappelt.de (CommuniGate Pro SMTP 5.1.7) with ESMTPA id 5585768 for pgsql-admin@postgresql.org; Fri, 09 Nov 2007 15:05:05 +0100 User-Agent: Microsoft-Entourage/11.3.6.070618 Date: Fri, 09 Nov 2007 15:05:05 +0100 Subject: insufficient file descriptors on Mac OS X From: Maximilian Tyrtania To: "pgsql-admin@postgresql.org" Message-ID: Thread-Topic: insufficient file descriptors on Mac OS X Thread-Index: Acgi2YcaxW3zVI7MEdya/wAX8gNwZg== Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.325 tagged_above=0 required=5 tests=AWL=0.324, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200711/73 X-Sequence-Number: 27316 I am trying to start the server (8.2.3 on Mac OS X 10.4.10 (8R2218) Kernel-Version:Darwin 8.10.1). I have 3Gb Ram available. My memory settings are: Maximilian-Tyrtanias-Computer-2:~ maximiliantyrtania$ sysctl -a | grep shm kern.exec: unknown type returned kern.sysv.shmmax: 134217728 kern.sysv.shmmin: 1 kern.sysv.shmmni: 1024 kern.sysv.shmseg: 32 kern.sysv.shmall: 32768 In postgresql.conf: . . . max_connections = 240 . . shared_buffers = 4MB All other values are still on their defaults. But, alas... Maximilian-Tyrtanias-Computer-2:/Users/maximiliantyrtania postgres$ /usr/local/bin/postgres -D /usr/local/pgsql/data/ <%2007-11-09 14:46:42 CETFATAL: 53000: insufficient file descriptors available to start server process <%2007-11-09 14:46:42 CETDETAIL: System allows 6, we need at least 20. <%2007-11-09 14:46:42 CETLOCATION: set_max_safe_fds, fd.c:432 I sure there is some additional setting I have to adjust, but i'm not sure which one. Any pointers? Maximilian Tyrtania