Re: Postgresql under cygwin just stopped working.

if you run this command from a bash promt what does it output?  env

The paths cygwin is using should be listed in the output.  If it is not E then it will need to be changed.  When you
updated/ reinstalled did you move it from drive C to E?  I don't know if the cygwin installer is smart enough to remove
theprevious path references. 

I would guess that your path still has references to the C drive location.  usually new additions to the path are added
tothe end of the list.  Once cygwin finds a reference to the path it stops looking for others. 

start->settings->control panel->system->advanced->enviornment variables->bottom section of system variables should have
aline name path.  Remove the following if it is still in there 'C:\cygwin\bin;' (must have admin rights).  There should
bea 'E:\cygwin\bin;' in there. 

cygserver doesn't require you to specify a different install location.  It will find it via the environment variables
set(path). 

Otherwise you can start postmaster passing the location with the -D option.  In cygwin mapped network drives are
prefixedwith a /cygdrive.  So drive c is really /cygdrive/c.  postmaster -D /cygdrive/e/var/postgresql/data 


HTH


On Mon, Jul 19, 2004 at 10:11:56AM +0200, Martin Husted Hartvig wrote:
>
> I just installed postgres 7.4.3 on a win2000, here the default max
> connections was set to 40, thanks anyway.
>
> Installing on the win2000 gave me a problem and I found one of your
> mail/replies from the 1/7/2004
> (http://article.gmane.org/gmane.comp.db.postgresql.cygwin/2502), I have
> the precise same error and the only thing I can see that might course it
> is that I was forced to install cygwin in e:\cygwin and not in c:\cygwin.
> Is there anywhere I can set the -l parameter to postmaster like with
> pq_ctl or is there a other way around this problem?
>
> Regards,
> Martin
>
>
> On Thu, 15 Jul 2004 23:42:38 -0500, mike g <mike@thegodshalls.com> wrote:
>
> >Not sure to tell you the truth but cygwin postgres 7.4.1 sets the max
> >connections at 10 by default if I remember correctly.
> >
> >
> >On Thu, 2004-07-15 at 02:57, Martin Husted Hartvig wrote:
> >>As I had a backup of the databases I dropped the data folder and made a
> >>initdb, trying with both ipc-daemon and cygserver. When starting
> >>postgresql with ipc-daemon I got the same error, but starting with
> >>cygserver got me a little on the move with semmns and semmni error
> >>indications. When I changed the max_connections from 100 to 45 I was
> >>able
> >>to start postgresql and restore my databases from my backups. Could this
> >>have something to do with the Windows "secure" update from Microsoft?
> >>
> >>
> >>Regards,
> >>Martin
> >>
> >>
> >>On Wed, 14 Jul 2004 23:38:44 -0500, mike g <mike@thegodshalls.com>
> >>wrote:
> >>
> >>> With 7.3.1 you really should be using cygserver instead of the
> >>> ipc-daemon.  Was the cygserver config script run, installed as a
> >>> service, and running?
> >>>
> >>> Perhaps double check the directory permissions in case the X
> >>> installation changed any.
> >>>
> >>> Bad system call to me would indicate postgres is not able to request a
> >>> program or file it needs.  It is the dam$ shmat error that no one
> >>seems
> >>> to be able to solve.
> >>>
> >>> Reinstall cygwin as a last resort.
> >>>
> >>> HTH
> >>>
> >>> On Wed, 2004-07-14 at 07:20, Martin Husted Hartvig wrote:
> >>>> Hello List,
> >>>>
> >>>> I have been using PostgreSQL under CygWin for some time now and have
> >>>> been
> >>>> very glad, but this day it just stopped working. I can't see what the
> >>>> problem is, but 3 things has happend since yesterday where is ran
> >>fine:
> >>>>   1. I installed CygWin/X
> >>>>   2. My my laptop did'nt wake up after hypernate so I had to turn it
> >>off
> >>>>   3. I have just installed the Windows XP service upgrade
> >>>>
> >>>>
> >>>> I was using the IPC daemon2 as an NT service, but I have also tryed
> >>>> using
> >>>> the cygserver.
> >>>>
> >>>> When I try to start this happens:
> >>>>
> >>>> $postmaster -D /var/postgres/data/
> >>>> Bad system call
> >>>>
> >>>>
> >>>> and with debug level 5:
> >>>>
> >>>> $ postmaster -d 5 -D /var/postgres/data/
> >>>> [4004] DEBUG:  postmaster: PostmasterMain: initial environ dump:
> >>>> [4004] DEBUG:  -----------------------------------------
> >>>> [4004] DEBUG:   !::=::\
> >>>> [4004] DEBUG:   !C:=C:\cygwin\bin
> >>>> [4004] DEBUG:   ALLUSERSPROFILE=C:\Documents and Settings\All Users
> >>>> [4004] DEBUG:   ANT_HOME=C:\java\apache-ant-1.6.1
> >>>> [4004] DEBUG:   APPDATA=C:\Documents and Settings\mh\Application Data
> >>>> [4004] DEBUG:   CLIENTNAME=Console
> >>>> [4004] DEBUG:   COMMONPROGRAMFILES=C:\Program Files\Common Files
> >>>> [4004] DEBUG:   COMPUTERNAME=MH2
> >>>> [4004] DEBUG:   COMSPEC=C:\WINDOWS\system32\cmd.exe
> >>>> [4004] DEBUG:   CVS_RSH=/bin/ssh
> >>>> [4004] DEBUG:   CYGSERVER=server
> >>>> [4004] DEBUG:   CYGWIN=tty
> >>>> [4004] DEBUG:   HOME=/home/mh
> >>>> [4004] DEBUG:   HOMEDRIVE=C:
> >>>> [4004] DEBUG:   HOMEPATH=\Documents and Settings\mh
> >>>> [4004] DEBUG:   HOSTNAME=MH2
> >>>> [4004] DEBUG:
> >>>> INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
> >>>> /devel/info:/usr/autotool/stable/info:
> >>>> [4004] DEBUG:   JAVA_HOME=C:\j2sdk1.4.2
> >>>> [4004] DEBUG:   LOGONSERVER=\\MH2
> >>>> [4004] DEBUG:   MAKE_MODE=unix
> >>>> [4004] DEBUG:
> >>>> MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
> >>>> el/man::/usr/ssl/man:/usr/X11R6/man
> >>>> [4004] DEBUG:   NUMBER_OF_PROCESSORS=1
> >>>> [4004] DEBUG:   OLDPWD=/usr/bin
> >>>> [4004] DEBUG:   OS=Windows_NT
> >>>> [4004] DEBUG:
> >>>> PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
> >>>>
> >>DOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:/cygdrive/c/
> >>>> Program Files/Common Files/Adaptec
> >>>> Shared/System:/cygdrive/c/PROGRA~1/ULTRAE~1:/
> >>>> cygdrive/c/Program Files/nasm:/cygdrive/c/Program
> >>>> Files/cdrecord:/cygdrive/c/j2s
> >>>> dk1.4.2/bin:/cygdrive/c/java/apache-ant-1.6.1/bin:/usr/bin
> >>>> [4004] DEBUG:
> >>PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
> >>>> [4004] DEBUG:   PKG_CONFIG_PATH=/usr/X11R6/lib/pkgconfig
> >>>> [4004] DEBUG:   PROCESSOR_ARCHITECTURE=x86
> >>>> [4004] DEBUG:   PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5,
> >>>> GenuineInt
> >>>> el
> >>>> [4004] DEBUG:   PROCESSOR_LEVEL=6
> >>>> [4004] DEBUG:   PROCESSOR_REVISION=0905
> >>>> [4004] DEBUG:   PROGRAMFILES=C:\Program Files
> >>>> [4004] DEBUG:   PROMPT=$P$G
> >>>> [4004] DEBUG:   PS1=\[\033]0;\w\007
> >>>>          \033[32m\]\u@\h \[\033[33m\w\033[0m\]
> >>>>          $
> >>>> [4004] DEBUG:   PWD=/home/mh
> >>>> [4004] DEBUG:   SESSIONNAME=Console
> >>>> [4004] DEBUG:   SHLVL=1
> >>>> [4004] DEBUG:   SYSTEMDRIVE=C:
> >>>> [4004] DEBUG:   SYSTEMROOT=C:\WINDOWS
> >>>> [4004] DEBUG:   TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> >>>> [4004] DEBUG:   TERM=cygwin
> >>>> [4004] DEBUG:   TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> >>>> [4004] DEBUG:   USER=mh
> >>>> [4004] DEBUG:   USERDOMAIN=MH2
> >>>> [4004] DEBUG:   USERNAME=mh
> >>>> [4004] DEBUG:   USERPROFILE=C:\Documents and Settings\mh
> >>>> [4004] DEBUG:   WINDIR=C:\WINDOWS
> >>>> [4004] DEBUG:   _=/usr/bin/postmaster
> >>>> [4004] DEBUG:   TZ=RST-1RST-2,M3.5.0/2,M10.5.0/3
> >>>> [4004] DEBUG:  -----------------------------------------
> >>>> [4004] DEBUG:  searching PATH for executable
> >>>> [4004] DEBUG:  could not stat "/usr/local/bin/postgres": No such
> >>file or
> >>>> directo
> >>>> ry
> >>>> [4004] DEBUG:  found "/usr/bin/postgres" using PATH
> >>>> [4004] DEBUG:  invoking IpcMemoryCreate(size=10461184)
> >>>> Bad system call
> >>>>
> >>>> I tryed reinstalling the postgresql packages (7.3.1) from cygwin,
> >>but I
> >>>> have not ran a initdb yet. Any idea's?
> >>>> I would be very glad for any reply that could help solving this.
> >>Thanks.
> >>>>
> >>>> Regards,
> >>>> Martin
> >>>>
> >>>>
> >>>> ---------------------------(end of
> >>broadcast)---------------------------
> >>>> TIP 9: the planner will ignore your desire to choose an index scan if
> >>>> your
> >>>>       joining column's datatypes do not match
> >>
> >>
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 2: you can get off all lists at once with the unregister command
> >    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings