Re: Postgresql error pg_ctl stop is invoked after a postmaster -i invocation
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/
Re: Postgresql error pg_ctl stop is invoked after a postmaster -i invocation
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. Thanks! Best Regards, Carlo -- Carlo Florendo Astra Philippines Inc. www.astra.ph -- 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/
Postgresql error pg_ctl stop is invoked after a postmaster -i invocation
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 Cygwin Configuration Diagnostics Current System Time: Thu Dec 09 10:26:47 2004 Windows 2000 Professional Ver 5.0 Build 2195 Service Pack 4 Path: D:\cygwin\lib\subversion\bin D:\cygwin\usr\local\bin D:\cygwin\bin D:\cygwin\bin D:\cygwin\sbin D:\cygwin\usr\sbin D:\cygwin\usr\X11R6\bin c:\WINNT\system32 c:\WINNT c:\WINNT\System32\Wbem d:\Microsoft Visual Studio\Common\Tools\WinNT d:\Microsoft Visual Studio\Common\MSDev98\Bin d:\Microsoft Visual Studio\Common\Tools d:\Microsoft Visual Studio\VC98\bin f:\Program Files\INUS Technology\RapidForm2004\Exchange f:\Program Files\INUS Technology\RapidForm2004\Exchange\intel_a\code\bin .\ Output from D:\cygwin\bin\id.exe (nontsec) UID: 1000(Carlo) GID: 513(None) 513(None) Output from D:\cygwin\bin\id.exe (ntsec) UID: 1000(Carlo)GID: 513(None) 0(root) 513(None) 544(Administrators) 545(Users) SysDir: C:\WINNT\system32 WinDir: C:\WINNT CYGWIN = `server' HOME = `D:\cygwin\home\Carlo' MAKE_MODE = `unix' PWD = `/var/postgresql/data/global' USER = `Carlo' ALLUSERSPROFILE = `C:\Documents and Settings\All Users' APPDATA = `C:\Documents and Settings\Carlo\Application Data' CATDEFAULTENVIRONMENT = `InterOpB11' COLORFGBG = `15;default;0' COLORTERM = `rxvt-xpm' COMMONPROGRAMFILES = `C:\Program Files\Common Files' COMPUTERNAME = `THORIN' COMSPEC = `C:\WINNT\system32\cmd.exe' CVS_RSH = `/bin/ssh' DISPLAY = `:0' HOMEDRIVE = `C:' HOMEPATH = `\Documents and Settings\Carlo' HOSTNAME = `thorin' INCLUDE = `D:\Microsoft Visual Studio\VC98\atl\include;D:\Microsoft Visual Studio\VC98\mfc\include;D:\Microsoft Visual Studio\VC98\include' INFOPATH = `/usr/local/info:/usr/info:/usr/share/info:/usr/autotool/devel/info:/usr/autotool/stable/info:' LIB = `D:\Microsoft Visual Studio\VC98\mfc\lib;D:\Microsoft Visual Studio\VC98\lib' LOGONSERVER = `\\THORIN' MANPATH = `/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/devel/man::/usr/ssl/man:/usr/X11R6/man' MSDEVDIR = `D:\Microsoft Visual Studio\Common\MSDev98' NUMBER_OF_PROCESSORS = `1' OLDPWD = `/var/postgresql/data' OS2LIBPATH = `C:\WINNT\system32\os2\dll;' OS = `Windows_NT' OSDS = `intel_a' PATHEXT = `.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH' PKG_CONFIG_PATH = `/usr/X11R6/lib/pkgconfig' PROCESSOR_ARCHITECTURE = `x86' PROCESSOR_IDENTIFIER = `x86 Family 15 Model 1 Stepping 2, GenuineIntel' PROCESSOR_LEVEL = `15' PROCESSOR_REVISION = `0102' PROGRAMFILES = `C:\Program Files' PS1 = `\[\033]0;\w\007 [EMAIL PROTECTED] \[\033[33m\w\033[0m\] $ ' SHLVL = `1' SYSTEMDRIVE = `C:'
