Date: Mon, 09 Jan 2006 12:56:11 -0500 From: Mike jeays <mike.jeays@rogers.com> To: Benjamin Thelen <bt@ccgis.de> Cc: questions@freebsd.org Subject: Re: Postgresql 8.0 again Message-ID: <1136829371.5423.7.camel@chaucer.jeays.ca> In-Reply-To: <43C258B6.4050408@ccgis.de> References: <1136493870.1989.24.camel@chaucer.jeays.ca> <43C258B6.4050408@ccgis.de>
next in thread | previous in thread | raw e-mail | index | archive | help
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).
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1136829371.5423.7.camel>