Re: Postgresql 8.0 again
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 "[EMAIL PROTECTED]" > > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" 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). ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Postgresql 8.0 again
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 "[EMAIL PROTECTED]" ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Postgresql 8.0 again
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 "[EMAIL PROTECTED]" ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Postgresql 8.0 again
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 "[EMAIL PROTECTED]"