Thread: HELP!.. "semget(key=2, num=17, 03600) failed: No space left on device"

HELP!.. "semget(key=2, num=17, 03600) failed: No space left on device"

From
Serkan Bektaş
Date:
I had installed Postgresql 7.2 on FreeBSD 4.x
when I try to run initdb

  (bash-2.04# su -l pgsql -c initdb)

I get this error about semaphores.
--------------------
The files belonging to this database system will be owned by user "pgsql".
This user must also own the server process.

creating 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=2, 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.
Removing /usr/local/pgsql/data.
-----------------------------


But I don't know how to do ....

Can you help me ?

Serkan




Re: HELP!.. "semget(key=2, num=17, 03600) failed: No

From
Neil Conway
Date:
On Sat, 2002-03-02 at 10:55, Serkan Bektaş wrote:
> 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.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

http://developer.postgresql.org/docs/postgres/kernel-resources.html

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC