Date: Fri, 12 Apr 2002 16:32:27 +0100 (BST) From: Jan Grant <Jan.Grant@bristol.ac.uk> To: Culley Harrelson <culley@abcteach.net> Cc: freebsd-questions <freebsd-questions@freebsd.org> Subject: Re: postgresql max_connections - out of semaphore sets Message-ID: <Pine.GSO.4.44.0204121629590.17335-100000@mail.ilrt.bris.ac.uk> In-Reply-To: <3083.66.52.74.21.1018624844.squirrel@admin.abcteach.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.GSO.4.44.0204121629590.17335-100000>