From owner-freebsd-questions@FreeBSD.ORG Mon Jan 9 17:56:15 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 2DB4116A41F for ; Mon, 9 Jan 2006 17:56:15 +0000 (GMT) (envelope-from mike.jeays@rogers.com) Received: from smtp104.rog.mail.re2.yahoo.com (smtp104.rog.mail.re2.yahoo.com [206.190.36.82]) by mx1.FreeBSD.org (Postfix) with SMTP id 9BB1443D45 for ; Mon, 9 Jan 2006 17:56:14 +0000 (GMT) (envelope-from mike.jeays@rogers.com) Received: (qmail 40104 invoked from network); 9 Jan 2006 17:56:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rogers.com; h=Received:Subject:From:To:Cc:In-Reply-To:References:Content-Type:Date:Message-Id:Mime-Version:X-Mailer:Content-Transfer-Encoding; b=qCmGDim9runDvu0kH1UbvKor20WHeVj0YC2N2wNOy4KSB12Dqvmd0NfpxE58K4DqqScOfUt4sbQCJj6yBbGj58H91IsWRg7SetpKOdVGqHkJr1jfibmlFC3xD/0ojtp/+mda3dGMCvvEiGOFm7lNR2nTA6AyLP173bw7FjQdSw0= ; Received: from unknown (HELO chaucer.jeays.ca) (mike.jeays@rogers.com@72.139.51.96 with plain) by smtp104.rog.mail.re2.yahoo.com with SMTP; 9 Jan 2006 17:56:10 -0000 From: Mike jeays To: Benjamin Thelen In-Reply-To: <43C258B6.4050408@ccgis.de> References: <1136493870.1989.24.camel@chaucer.jeays.ca> <43C258B6.4050408@ccgis.de> Content-Type: text/plain Date: Mon, 09 Jan 2006 12:56:11 -0500 Message-Id: <1136829371.5423.7.camel@chaucer.jeays.ca> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit 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 17:56:15 -0000 On Mon, 2006-01-09 at 13:36 +0100, Benjamin Thelen wrote: > 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" > > _______________________________________________ > 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" I got it to work with a kernel recompile with some additional parameters. It is there in the documentation if you read it carefully! (I obviously didn't).