X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 651ADD1B174 for ; Fri, 2 Jul 2004 13:44:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48442-10 for ; Fri, 2 Jul 2004 16:44:58 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 10BC8D1B170 for ; Fri, 2 Jul 2004 13:44:57 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i62GiuUN015695; Fri, 2 Jul 2004 12:44:56 -0400 (EDT) To: teknet@poczta.onet.pl Cc: pgsql-admin@postgresql.org Subject: Re: 7.4.3 initdb: could not create semaphores In-reply-to: <20040702132114Z2653033-22184+44473@kps3.test.onet.pl> References: <20040702132114Z2653033-22184+44473@kps3.test.onet.pl> Comments: In-reply-to teknet@poczta.onet.pl message dated "Fri, 02 Jul 2004 15:20:56 +0200" Date: Fri, 02 Jul 2004 12:44:55 -0400 Message-ID: <15694.1088786695@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/39 X-Sequence-Number: 14107 teknet@poczta.onet.pl writes: > could not create semaphores: No space left on device > DETAIL: Failed system call was semget(1, 17, 03600). > HINT: 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 10). > The PostgreSQL documentation contains more information about > configuring your system for PostgreSQL. > How can i sovle this problem ? You need to increase your kernel's settings for maximum number of semaphores. See the admin documentation that the error message is trying to point you to: http://www.postgresql.org/docs/7.4/static/kernel-resources.html regards, tom lane