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(at)\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>