From owner-freebsd-questions@FreeBSD.ORG Mon Jan 9 13:21:23 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 6DF1D16A41F for ; Mon, 9 Jan 2006 13:21:23 +0000 (GMT) (envelope-from thelen@ccgis.de) Received: from sm7.simplethings.de (a15160313.alturo-server.de [217.160.128.151]) by mx1.FreeBSD.org (Postfix) with ESMTP id B080F43D45 for ; Mon, 9 Jan 2006 13:21:22 +0000 (GMT) (envelope-from thelen@ccgis.de) Received: from smm.simplethings.de ([85.88.4.201]) by sm7.simplethings.de with esmtp (Exim 4.50) id 1EvwxY-0007Pd-EP; Mon, 09 Jan 2006 14:21:21 +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 1EvwxY-0006Ox-5K; Mon, 09 Jan 2006 14:21:16 +0100 Received: from [192.168.2.66] (helo=[192.168.2.66]) by center.shared with esmtp (Exim 4.50) id 1EvwyP-0000Pc-AT; Mon, 09 Jan 2006 14:22:09 +0100 Message-ID: <43C26381.2040308@ccgis.de> Date: Mon, 09 Jan 2006 14:22:09 +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 13:21:23 -0000 At first I did't find ipc_check.pl. You'll need the postgresql source tree: contrib/ipc_check/ipc_check.pl. I also found ipcclean what may do the same like a reboot does... and ipcs gives some status information. 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" _______________________________________________ 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"