Re: PGSTAT : COnnection Refused Error (pgsql 7.2-2 on

At 07:50 04/03/2002 -0500, you wrote:
>Tim,
>
>
>Please use Cygwin 1.3.10 since it is available now.

done

>1. Try starting postmaster from the command line.  Do you get the same
>error?

I am logged in as Administrator and i do


postmaster -i -D /usr/share/postgresql/data &

then it starts and within 4 secs it writes to stderr the same error message
as mentioned already earlier in the thread.


>2. Try deleting the cygipc files:
>
>     $ rm /tmp/cygipc* /tmp/MultiFile*
>
>Any difference?

I did, and no.

>3. Try to strace the problem:

I did your 'unlink and copy' procedure then

strace --output=strace.output postmaster -i -D /usr/share/postgresql/data

(not even in background, and all output to stdout)

err. it RAN! I managed to get pgAdmin to connect to it, and even got psql
working (which you may recall was a previous thread issue with it
crashing). Great! So how do you stop strace?? I ended up killing it from
another bash screen.

So then rm'd the postmaster.exe and re linked it, and tried again from the
command line, but this time with the additional -d=4 debug level.

I have cut/pasted this log output from debug level 4 at end of this post. I
have not appended strace.output as it was mega size.

>Any thing obvious in postmaster.log?

Well here it (below) is at '-d 4', but without strace.output (when I did
the strace on postmaster it worked so no error messages in log)

Jason, thanks for the help you give, you have been a REAL help so far. I
have a feeling this is SO incredibly simple to solve... especially as it
ran under strace.

Tim.

<snip>
postmaster: PostmasterMain: initial environ dump:
-----------------------------------------
         NUMBER_OF_PROCESSORS=1
         PROMPT=$P$G
         PWD=/var/log
         LOGONSERVER=\\OMNIBOOK450
         PROCESSOR_LEVEL=6
         OS2LIBPATH=C:\WINNT\system32\os2\dll;
         COMSPEC=C:\WINNT\system32\cmd.exe
         !C:=C:\cygwin\bin
         ALLUSERSPROFILE=C:\Documents and Settings\All Users
         SYSTEMDRIVE=C:
         COMMONPROGRAMFILES=C:\Program Files\Common Files
         PROCESSOR_REVISION=0502
         PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
         COMPUTERNAME=OMNIBOOK450
         WINDIR=C:\WINNT
         USERPROFILE=C:\Documents and Settings\Administrator
         PS1=\[\033]0;\w\007
\033[32m\]\u@\h \[\033[33m\w\033[0m\]
$
         PROGRAMFILES=C:\Program Files
         !::=::\
         USER=Administrator
         PROCESSOR_IDENTIFIER=x86 Family 6 Model 5 Stepping 2, GenuineIntel
         OS=Windows_NT
         OLDPWD=/usr/share/postgresql
         PROCESSOR_ARCHITECTURE=x86
         TEMP=/cygdrive/c/DOCUME~1/ADMINI~1/LOCALS~1/Temp
         SYSTEMROOT=C:\WINNT
         TMP=/cygdrive/c/DOCUME~1/ADMINI~1/LOCALS~1/Temp
         HOMEDRIVE=C:
         SHLVL=1
         MAKE_MODE=unix
         APPDATA=C:\Documents and Settings\Administrator\Application Data
         HOMEPATH=\
         USERDOMAIN=OMNIBOOK450
         USERNAME=Administrator
         TERM=cygwin
         HOME=/home/Administrator

PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin:/cygdrive/c/WINNT/system32:/cygdrive/c/WINNT:/cygdrive/c/WINNT/System32/Wbem:/cygdrive/c/java/bin:/usr/bin:.
         _=/usr/bin/postmaster
-----------------------------------------
FindExec: searching PATH ...
ValidateBinary: can't stat "/usr/local/bin/postgres"
FindExec: found "/usr/bin/postgres" using PATH
invoking IpcMemoryCreate(size=1441792)
FindExec: searching PATH ...
ValidateBinary: can't stat "/usr/local/bin/postmaster"
FindExec: found "/usr/bin/postmaster" using PATH
PGSTAT: connect(2): Connection refused
DEBUG:  proc_exit(1)
DEBUG:  shmem_exit(1)
DEBUG:  exit(1)
</snip>