From: | "Harald Massa" <ghum(at)gmx(dot)net> |
---|---|
To: | pgsql-hackers-win32(at)postgresql(dot)org |
Subject: | no connection to server |
Date: | 2004-09-10 11:46:08 |
Message-ID: | 16628.1094816768@www7.gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
- running Postgresql 8.0 beta1 from the binary MSI Installer,
and
- running Postgresql 8.0 beta2-dev2 from the binary MSI Installer,
Windows XP Professional Sevice Pack 2 (and Service Pack 1 before)
Stopped the running service, started Postgresql from the command line
to get some debugging output:
C:\Programme\PostgreSQL\8.0-beta1\bin>postmaster.exe -i
WARNING: could not find a match for Windows timezone "Westeuropõische
Normalzei
t"
LOG: database system was shut down at 2004-09-05 12:06:23 Westeuropõische
Norma
lzeit
LOG: checkpoint record is at 0/AB4B78
LOG: redo record is at 0/AB4B78; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 498; next OID: 17228
LOG: database system is ready
LOG: select() failed in statistics buffer: Ein Vorgang bezog sich auf ein
Objekt, das kein Socket ist.
LOG: statistics collector process (PID 2700) was terminated by signal 1
LOG: select() failed in statistics collector: Ein Vorgang bezog sich auf
ein Ob
jekt, das kein Socket ist.
####################################################
LOG: select() failed in statistics buffer: Ein Vorgang bezog sich auf ein
Objek
t, das kein Socket ist.
#######################################
this message gets repeated without something else happening ... no
connection attempt or anything.
#########################
#############################################################
LOG: incomplete startup packet
LOG: could not receive data from client: Ein Vorgang bezog sich auf ein
Objekt,
das kein Socket ist.
This gets printed out anytime I try to connect - no matter if from
psql or from pgadmin
on the client side:
C:\Programme\PostgreSQL\8.0-beta1\bin>psql -h localhost
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Any ideas what could be wrong? Googling led to around 3 people with
the same problem, but no solution yet.
- I did deactivate Antivir-Software from H+B Edv
- I did deactivate the windows firewall
- with the activated firewall I tried an exception for Port 5432 /
Postgresql
- I tried runnig psql as a service AND as a command Line Application
- Postgres runs as "postgres" User which was created by the msi-installer
- I checked via control-panel that the service is running when using the
Service
- LOG gets written each time I try to connect
if I deactivate the stats collector, this message "disappears" [LOG:
statistics collector process (PID 2700) was terminated by signal 1
LOG: select() failed in statistics collector: Ein Vorgang bezog sich auf
ein Ob
jekt, das kein Socket ist.
] (it does not appear again)
----------------
Any Ideas?
Harald
From | Date | Subject | |
---|---|---|---|
Next Message | Reini Urban | 2004-09-10 13:01:57 | Re: [HACKERS] more dirmod CYGWIN |
Previous Message | Reini Urban | 2004-09-10 10:02:21 | more dirmod CYGWIN (was: APR 1.0 released) |