Date: Fri, 12 Apr 2002 08:20:44 -0700 (PDT) From: "Culley Harrelson" <culley@abcteach.net> To: <freebsd-questions@freebsd.org> Subject: postgresql max_connections - out of semaphore sets Message-ID: <3083.66.52.74.21.1018624844.squirrel@admin.abcteach.net>
next in thread | raw e-mail | index | archive | help
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. culley 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?3083.66.52.74.21.1018624844.squirrel>