Taras Heychenko wrote: > > On 25 апр. 2012, at 06:24, Andrey N. Oktyabrski wrote: > > > On 25.04.12 03:54, Taras Heychenko wrote: > >> Увеличить параметры > >> kern.ipc.shmall: 8192 > >> kern.ipc.shmmax: 33554432 > >> пробовал -- меняет ошибку, но общую ситуацию не улучшает. > > Можно новую ошибку увидеть? Меняет ошибку - это же хорошо, это значит > > действо возымело эффект :-) > > Вот ошибка при увеличении shmmax и shmall вдвое. > > root@gw:~>/usr/local/etc/rc.d/postgresql initdb > The files belonging to this database system will be owned by user "pgsql". > This user must also own the server process. > > The database cluster will be initialized with locale C. > The default text search configuration will be set to "english". > > creating directory /usr/local/pgsql/data ... ok > creating subdirectories ... ok > selecting default max_connections ... 10 > selecting default shared_buffers ... 400kB > 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 13). > 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"
Покрутить через /boot/loader.conf kern.ipc.semmns , kern.ipc.semmni , kern.ipc.semmnu -- LEFT-(UANIC|RIPE) JID: [email protected] PGP fingerprint: 1BCD 7C80 2E04 7282 C944 B0E0 7E67 619E 4E72 9280
