Re: 7.4.3 initdb: could not create semaphores - Mailing list pgsql-admin

From Tom Lane
Subject Re: 7.4.3 initdb: could not create semaphores
Date
Msg-id 15694.1088786695@sss.pgh.pa.us
Whole thread Raw
In response to 7.4.3 initdb: could not create semaphores  (teknet@poczta.onet.pl)
List pgsql-admin
teknet@poczta.onet.pl writes:
> 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 10).
>         The PostgreSQL documentation contains more information about
> configuring your system for PostgreSQL.

> How can i sovle this problem ?

You need to increase your kernel's settings for maximum number of
semaphores.  See the admin documentation that the error message is
trying to point you to:

http://www.postgresql.org/docs/7.4/static/kernel-resources.html

            regards, tom lane

pgsql-admin by date:

Previous
From: Jean-Christophe Weis
Date:
Subject: Re: unable to pass variable PGDATA2 into server environment
Next
From: "Bender, Cheryl"
Date:
Subject: Re: Dumping partial database content