Postgresql error "pg_ctl stop" is invoked after a "postmaster -i &" invocation

[Carlo Florendo]

Hello,

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:

$ df
Filesystem           1k-blocks      Used Available Use% Mounted on
D:\cygwin\usr\X11R6\lib\X11\fonts
                       5964480   3767476   2197004  64% 
/usr/X11R6/lib/X11/fonts
D:\cygwin\bin          5964480   3767476   2197004  64% /usr/bin
D:\cygwin\lib          5964480   3767476   2197004  64% /usr/lib
D:\cygwin              5964480   3767476   2197004  64% /
c:                     4000152   2838348   1161804  71% /cygdrive/c
d:                     5964480   3767476   2197004  64% /cygdrive/d
e:                     3992336   1434212   2558124  36% /cygdrive/e
f:                    17646768   9464944   8181824  54% /cygdrive/f
h:                    28313600   4579328  23734272  17% /cygdrive/h

The postgresql database is in /var/postgresql/data (which is actually 
d:\cygwin\var\postgresql\data)
I deleted all the PID lock files under /tmp but was still unsuccessful 
in restarting the db.  I get the same error above.

Attached is cygcheck.

Thanks!

Best Regards,

Carlo

-- 
Carlo Florendo
Astra Philippines Inc.
www.astra.ph

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: cygcheck.out
URL: <http://cygwin.com/pipermail/cygwin/attachments/20041209/ba1ffb54/attachment.ksh>
-------------- next part --------------
--
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/