Re: Postgresql under cygwin just stopped working.
От | Martin Husted Hartvig |
---|---|
Тема | Re: Postgresql under cygwin just stopped working. |
Дата | |
Msg-id | opsbk04gmpp11tu2@pasmtp.tele.dk обсуждение исходный текст |
Ответ на | Re: Postgresql under cygwin just stopped working. (Mike G <mike@thegodshalls.com>) |
Ответы |
Re: Postgresql under cygwin just stopped working.
(Mike G <mike@thegodshalls.com>)
|
Список | pgsql-cygwin |
I'm still workin on this, and it just won't locate the log file position. I have made some dumps: The PATH didn't have a ref to cygwin, so I added it like you wrote: PATH %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;"C:\Program Files\Symantec\Norton Ghost 2003\";E:\cygwin\bin Here is what cygwin sees: $ set !C:='C:\Documents and Settings\mh\Desktop' !E:='E:\cygwin\bin' ALLUSERSPROFILE='C:\Documents and Settings\All Users' APPDATA='C:\Documents and Settings\mh\Application Data' BASH=/usr/bin/bash BASH_VERSINFO=([0]="2" [1]="05b" [2]="0" [3]="1" [4]="release" [5]="i686-pc-cygw in") BASH_VERSION='2.05b.0(1)-release' CLIENTNAME=MH2 COLUMNS=80 COMMONPROGRAMFILES='C:\Program Files\Common Files' COMPUTERNAME=SERVER COMSPEC='C:\WINNT\system32\cmd.exe' CVS_RSH=/bin/ssh CYGWIN=server DIRSTACK=() EUID=1002 GROUPS=() HISTFILE=/home/mh/.bash_history HISTFILESIZE=500 HISTSIZE=500 HOME=/home/mh HOMEDRIVE=C: HOMEPATH='\Documents and Settings\mh' HOSTNAME=Server HOSTTYPE=i686 IFS=$' \t\n' INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool/devel/info:/usr /autotool/stable/info: LINES=25 LOGONSERVER='\\SERVER' MACHTYPE=i686-pc-cygwin MAILCHECK=60 MAKE_MODE=unix MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/devel/man::/usr/ssl /man NUMBER_OF_PROCESSORS=1 OLDPWD=/usr/bin OPTERR=1 OPTIND=1 OS=Windows_NT OS2LIBPATH='C:\WINNT\system32\os2\dll;' OSTYPE=cygwin PATH='/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WINNT/system32:/cy gdrive/c/WINNT:/cygdrive/c/WINNT/System32/Wbem:"C:/Program Files/Symantec/Norton Ghost 2003/":/usr/bin' PATHEXT='.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH' PIPESTATUS=([0]="1") PPID=1 PRINTER= PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER='x86 Family 6 Model 8 Stepping 3, GenuineIntel' PROCESSOR_LEVEL=6 PROCESSOR_REVISION=0803 PROGRAMFILES='C:\Program Files' PROMPT='$P$G' PS1=$'\\[\\033]0;\\w\\007\n\\033[32m\\]\\u@\\h \\[\\033[33m\\w\\033[0m\\]\n$ ' PS2='> ' PS4='+ ' PWD=/home/mh SESSIONNAME=RDP-Tcp#3 SHELL=/bin/bash SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments:moni tor SHLVL=1 SYSTEMDRIVE=C: SYSTEMROOT='C:\WINNT' TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1 TERM=cygwin TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1 UID=1002 USER=mh USERDOMAIN=SERVER USERNAME=mh USERPROFILE='C:\Documents and Settings\mh' WINDIR='C:\WINNT' _=/var/postgresql/datahtg f= Trying to install as a service gives: $ cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /cygdrive/e/var/postgresql/datahtg -i" --dep cygserver --termsig INT --user mh --shutdown $ net start postmaster The postmaster service is starting. The postmaster service could not be started. A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. DEBUG: exit(1) hmmm.... starting the postmaster comes with this: $ /usr/bin/postmaster -d 5 -D /var/postgresql/datahtg DEBUG: /usr/bin/postmaster: PostmasterMain: initial environ dump: DEBUG: ----------------------------------------- DEBUG: !C:=C:\Documents and Settings\mh\Desktop DEBUG: !E:=E:\cygwin\bin DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data DEBUG: CLIENTNAME=MH2 DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files DEBUG: COMPUTERNAME=SERVER DEBUG: COMSPEC=C:\WINNT\system32\cmd.exe DEBUG: CVS_RSH=/bin/ssh DEBUG: CYGWIN=server DEBUG: HOME=/home/mh DEBUG: HOMEDRIVE=C: DEBUG: HOMEPATH=\Documents and Settings\mh DEBUG: HOSTNAME=Server DEBUG: INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool /devel/info:/usr/autotool/stable/info: DEBUG: LOGONSERVER=\\SERVER DEBUG: MAKE_MODE=unix DEBUG: MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev el/man::/usr/ssl/man DEBUG: NUMBER_OF_PROCESSORS=1 DEBUG: OLDPWD=/usr/bin DEBUG: OS2LIBPATH=C:\WINNT\system32\os2\dll; DEBUG: OS=Windows_NT DEBUG: PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN NT/system32:/cygdrive/c/WINNT:/cygdrive/c/WINNT/System32/Wbem:"C:/Program Files/ Symantec/Norton Ghost 2003/":/usr/bin DEBUG: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH DEBUG: PROCESSOR_ARCHITECTURE=x86 DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 8 Stepping 3, GenuineInt el DEBUG: PROCESSOR_LEVEL=6 DEBUG: PROCESSOR_REVISION=0803 DEBUG: PROGRAMFILES=C:\Program Files DEBUG: PROMPT=$P$G DEBUG: PS1=\[\033]0;\w\007 \033[32m\]\u@\h \[\033[33m\w\033[0m\] $ DEBUG: PWD=/home/mh DEBUG: SESSIONNAME=RDP-Tcp#3 DEBUG: SHLVL=1 DEBUG: SYSTEMDRIVE=C: DEBUG: SYSTEMROOT=C:\WINNT DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1 DEBUG: TERM=cygwin DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1 DEBUG: USER=mh DEBUG: USERDOMAIN=SERVER DEBUG: USERNAME=mh DEBUG: USERPROFILE=C:\Documents and Settings\mh DEBUG: WINDIR=C:\WINNT DEBUG: _=/usr/bin/postmaster DEBUG: TZ=RST-1RDT-2,M3.5.0/2,M10.5.0/3 DEBUG: ----------------------------------------- DEBUG: found "/usr/bin/postgres" using argv[0] DEBUG: invoking IpcMemoryCreate(size=8970240) WARNING: dup(0) failed after 3195 successes: Bad file descriptor DEBUG: max_safe_fds = 985, usable_fds = 3195, already_open = 5 DEBUG: found "/usr/bin/postmaster" using argv[0] E:\cygwin\bin\postgres.exe (4928): *** MapViewOfFileEx (0xF10000), Win32 error 4 87. Terminating. E:\cygwin\bin\postgres.exe (4924): *** MapViewOfFileEx (0xF10000), Win32 error 4 87. Terminating. DEBUG: reaping dead processes LOG: statistics collector process (PID 4928) exited with exit code 1 LOG: startup process (PID 4924) exited with exit code 1 LOG: aborting startup due to startup process failure DEBUG: proc_exit(1) DEBUG: shmem_exit(1) I'm only able to start postgres with the pg_ctl command. Regards, Martin On Mon, 19 Jul 2004 21:55:42 -0500, Mike G <mike@thegodshalls.com> wrote: > 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 the previous path references. > > I would guess that your path still has references to the C drive > location. usually new additions to the path are added to the 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 a line name > path. Remove the following if it is still in there 'C:\cygwin\bin;' > (must have admin rights). There should be a '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 prefixed with 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 >>
В списке pgsql-cygwin по дате отправления: