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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: VC++ psql build broken
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: VC++ psql build broken