Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-hackers-win32 by date

Next:From: Reini UrbanDate: 2004-09-10 13:01:57
Subject: Re: [HACKERS] more dirmod CYGWIN
Previous:From: Reini UrbanDate: 2004-09-10 10:02:21
Subject: more dirmod CYGWIN (was: APR 1.0 released)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group