no connection to server
От | Harald Massa |
---|---|
Тема | no connection to server |
Дата | |
Msg-id | 16628.1094816768@www7.gmx.net обсуждение исходный текст |
Список | 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 по дате отправления: