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

Started by Serkan Bektaşabout 24 years ago2 messagesgeneral
Jump to latest
#1Serkan Bektaş
sbektas@karincaint.com.tr

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

#2Neil Conway
neilc@samurai.com
In reply to: Serkan Bektaş (#1)
Re: HELP!.. "semget(key=2, num=17, 03600) failed: No

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