Skip site navigation (1) Skip section navigation (2)

Re: Postgresql error "pg_ctl stop" is invoked after a "postmaster

From: Carlo Florendo <list-subscriber(at)hq(dot)astra(dot)ph>
To: Reini Urban <rurban(at)x-ray(dot)at>
Cc: pgsql-cygwin(at)postgresql(dot)org, cygwin(at)cygwin(dot)com
Subject: Re: Postgresql error "pg_ctl stop" is invoked after a "postmaster
Date: 2004-12-10 01:00:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-cygwin
Reini Urban wrote:

> 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?

Oh sheeesh!  I'm so sorry.  (How come I didn't see the hint?....sorry, 
must've been my sleepiness.)  No, I didn't read everything.  And yes, 
the explanation is really straightforward and to the point ( I realized 
after I read it.) . 

Apologies for the noise.


Best Regards,


Carlo Florendo
Astra Philippines Inc.

In response to

pgsql-cygwin by date

Next:From: Ruby WunDate: 2004-12-10 16:04:11
Subject: Problem with Postmaster
Previous:From: Reini UrbanDate: 2004-12-09 14:06:42
Subject: Re: Postgresql error "pg_ctl stop" is invoked after a "postmaster

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group