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"
--
Taras Heychenko
