no connection to server

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

Browse pgsql-hackers-win32 by date

  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)