guys i'm having some wierd problems with postgresql
i have tried it with versions 7.2 7.3 and 8
i get the same thing

when i run su -l pgsql -c initdb
i get :
The files belonging to this database system will be owned by user "pgsql".
This user must also own the server process.

Fixing permissions on existing directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
creating template1 database in /usr/local/pgsql/data/base/1... IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: No space left on device

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 32).

The PostgreSQL Administrator's Guide contains more information about
configuring your system for PostgreSQL.


initdb failed.

can you pls help?

what output does "ipcs" produce? What output does "sysctl kern.ipc | grep sem" produce?

kern.ipc.semmap: 30
kern.ipc.semmni: 10
kern.ipc.semmns: 60
kern.ipc.semmnu: 30
kern.ipc.semmsl: 60
kern.ipc.semopm: 100
kern.ipc.semume: 10
kern.ipc.semusz: 92
kern.ipc.semvmx: 32767
kern.ipc.semaem: 16384

but i've also found out
that i can reduce max_connections within postgresql
but i couldn't find anywhere how to do it

the wierd thing is that i set it up once
and it worked
after 1 day i uninstalled it
tried to install v8
to luck
then i tried to get back to v7 no luck again :-(

guys i really need your help on this