From owner-freebsd-questions@FreeBSD.ORG Mon Jan 9 12:35:21 2006 Return-Path: X-Original-To: questions@freebsd.org Delivered-To: freebsd-questions@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 48E9B16A41F for ; Mon, 9 Jan 2006 12:35:21 +0000 (GMT) (envelope-from bt@ccgis.de) Received: from sm7.simplethings.de (a15160313.alturo-server.de [217.160.128.151]) by mx1.FreeBSD.org (Postfix) with ESMTP id 815D743D49 for ; Mon, 9 Jan 2006 12:35:19 +0000 (GMT) (envelope-from bt@ccgis.de) Received: from smm.simplethings.de ([85.88.4.201]) by sm7.simplethings.de with esmtp (Exim 4.50) id 1EvwEz-0006hF-Ae; Mon, 09 Jan 2006 13:35:18 +0100 Received: from [212.79.172.180] (helo=center.shared) by smM.simplethings.de with esmtpsa (TLS-1.0:RSA_AES_256_CBC_SHA:32) (Exim 4.50) id 1EvwEz-0005tN-2I; Mon, 09 Jan 2006 13:35:13 +0100 Received: from [192.168.2.66] (helo=[192.168.2.66]) by center.shared with esmtp (Exim 4.50) id 1EvwFq-0000Jn-93; Mon, 09 Jan 2006 13:36:06 +0100 Message-ID: <43C258B6.4050408@ccgis.de> Date: Mon, 09 Jan 2006 13:36:06 +0100 From: Benjamin Thelen User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Mike Jeays References: <1136493870.1989.24.camel@chaucer.jeays.ca> In-Reply-To: <1136493870.1989.24.camel@chaucer.jeays.ca> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Score: 0.1 (/) Cc: questions@freebsd.org Subject: Re: Postgresql 8.0 again X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 09 Jan 2006 12:35:21 -0000 Reboot always helped for me. Otherwise see http://www.webservertalk.com/message292349.html. Maybe this helps. Best, Ben Mike Jeays schrieb: > I just re-installed postgresql80-server from the ports, and get exactly > the same error as from the package. This is on my 5.4 machine, were I > previously had a working copy. > > I have tried changing max_connections in the sample config file (setting > it down to 1 just to see if even that would work). I also tried the > following kernel setting changes (without a reboot), with no > improvement. > > sysctl -w kern.ipc.shmall=32768 > sysctl -w kern.ipc.shmmax=134217728 > sysctl -w kern.ipc.semmap=256 > > Error message from initdb > > ... > ... > creating configuration files ... ok > creating template1 database in /usr/local/pgsql/data/base/1 ... FATAL: > 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. > child process exited with exit code 1 > initdb: removing data directory "/usr/local/pgsql/data" > > Any more help will be very welcome! > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"