From owner-freebsd-questions Fri Apr 12 8:34:16 2002 Delivered-To: freebsd-questions@freebsd.org Received: from dire.bris.ac.uk (dire.bris.ac.uk [137.222.10.60]) by hub.freebsd.org (Postfix) with ESMTP id 76BC837B400 for ; Fri, 12 Apr 2002 08:34:09 -0700 (PDT) Received: from mail.ilrt.bris.ac.uk by dire.bris.ac.uk with SMTP-PRIV with ESMTP; Fri, 12 Apr 2002 16:34:01 +0100 Received: from cmjg (helo=localhost) by mail.ilrt.bris.ac.uk with local-esmtp (Exim 3.16 #1) id 16w32J-0001qD-00; Fri, 12 Apr 2002 16:32:27 +0100 Date: Fri, 12 Apr 2002 16:32:27 +0100 (BST) From: Jan Grant X-X-Sender: cmjg@mail.ilrt.bris.ac.uk To: Culley Harrelson Cc: freebsd-questions Subject: Re: postgresql max_connections - out of semaphore sets In-Reply-To: <3083.66.52.74.21.1018624844.squirrel@admin.abcteach.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Fri, 12 Apr 2002, Culley Harrelson wrote: > I just tried to increase the max connections for postgresql and received the > following error: > > ============================= > bash-2.05a$ pg_ctl start -o "-c MAX_CONNECTIONS=64 -c SHARED_BUFFERS=168" -D > /usr/local/pgsql/data/ > postmaster successfully started > bash-2.05a$ IpcSemaphoreCreate: semget(key=5432004, num=17, 03600) failed: > No space left on device > > This error does *not* mean that you have run out of disk space. > > It occurs when either the system limit for the maximum number of > semaphore sets (SEMMNI), or the system wide maximum number of > semaphores (SEMMNS), would be exceeded. You need to raise the > respective kernel parameter. Alternatively, reduce PostgreSQL's > consumption of semaphores by reducing its max_connections parameter > (currently 64). > > The PostgreSQL Administrator's Guide contains more information about > configuring your system for PostgreSQL. > ============================= > > Is there an easy way to alter this or do I need to recompile the kernel (the > kernel is kind of a black box to me)? I am building a test box for what > will eventually be a production server so if I could do something different > in the install process to fix this that would be acceptable. I asked exactly this question a couple of weeks ago, with no response. There does not (as far as I can tell) appear to be a boot-time configuration for this, so you're stuck building a kernel with larger values for SEMMNI. This is really easy, however: check /usr/src/sys/i386/conf/GENERIC and LINT for the appropriate option definitions. Nevertheless, I'd _love_ to be corrected on this, because it is certainly a bit of a pain. jan -- jan grant, ILRT, University of Bristol. http://www.ilrt.bris.ac.uk/ Tel +44(0)117 9287088 Fax +44 (0)117 9287112 RFC822 jan.grant@bris.ac.uk "...er, that's my _spare_ axe." - Gimli in the Council of Elrond, FotR. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message