Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Message-ID:	<41B85BF2.3060304@x-ray.at>
Date:	Thu, 09 Dec 2004 15:06:42 +0100
From:	Reini Urban <rurban AT x-ray DOT at>
User-Agent:	Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8a4) Gecko/20040927
MIME-Version:	1.0
To:	Carlo Florendo <list-subscriber AT hq DOT astra DOT ph>
CC:	pgsql-cygwin AT postgresql DOT org, cygwin AT cygwin DOT com
Subject:	Re: Postgresql error "pg_ctl stop" is invoked after a "postmaster -i &" invocation
References:	<41B7B840 DOT 4060508 AT hq DOT astra DOT ph>
In-Reply-To:	<41B7B840.4060508@hq.astra.ph>
X-IsSubscribed:	yes

Carlo Florendo schrieb:
> I invoked:
> 
> "postmaster -i -D /var/postgresql/data  &"
> 
> and was able to start and connect to my database. Since the process was 
> made to run on the background, I wanted a way to stop it without doing a 
> "kill -9".  Thus, on another instance of my shell, I invoked :
> 
> "pg_ctl stop -D /var/postgresql/data"
> 
> Postgres says it was unsuccessful in shutting down the database.   
> However, doing a "ps" revealed that no postgres processes were running.
> 
> I then tried to restart the DB once again with:
> 
> "postmaster -i -D /var/postgresql/data  &"
> 
> This time, I got this errror:
> 
> $ postmaster -i -D /var/postgresql/data &
> FATAL:  could not create semaphores: No space left on device
> DETAIL:  Failed system call was semget(5432004, 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 40).
>        The PostgreSQL documentation contains more information about 
> configuring your system for PostgreSQL.
> 
> 
> I have a lot of diskspace.  Doing a "df" revealed:

Now the tricky part:
Did you actually read what the error message told you?

Honestly, I know of no other POSIX or Windows app which explains such a 
basic error in such helpful details. And I thought postgresql is already 
  ready for the dummy mode with the new windows port.

max_connections=40 is a bit high and your SEMMNS are way too low for 40.
5 are recommended for a busy system.

$ nano /etc/cygserver.conf
There you can edit the explained kernel params.

> $ df
...
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -