Re: no connection to server

I've been working some off-list with Harald about this, and it turns out the reason for the error was a LSP (Layered Service Provider) installed on the TCP/IP stack that caused the winsock calls to fail. I have added this information (along with a link to a tool that can be used to determine it) to the pginstaller FAQ. We're also trying to figure out if we can find out exactly what goes wrong and why, but the problem does go away when the LSP is uninstalled.

//Magnus

>
>
>- 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
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>