Re: PostgreSQL doesn't accept connections when Windows
От | George Weaver |
---|---|
Тема | Re: PostgreSQL doesn't accept connections when Windows |
Дата | |
Msg-id | 008601c7205e$6549f9b0$6400a8c0@Dell4500 обсуждение исходный текст |
Ответ на | PostgreSQL doesn't accept connections when Windows Server is rebooted (George Weaver <gweaver@shaw.ca>) |
Список | pgsql-general |
----- Original Message From: "Thomas H.", etc. Thank you all for your replies and suggestions. I apologize for not replying earlier but the client is located several hours away and I have not been back to the site until yesterday. Here's an update of the situation (PostgreSQL 8.1.5 on Windows 2000 Server system). The server is not in a domain, but I followed Thomas' suggestion just the same (>"make sure you manually set "log on as a service" priviledges on the domain controller for the local postgres user"). Upon reboot of the Windows 2000 server: 1. PostgeSQL service starts without problem. 2. Server is listening on port 5435 as per postgresql.conf file (verified by netstat). 3. No other application using port 5435. 3. (PostgreSQL 7.3 version listening on port 5432 - no problems) 4. Attempts to connect to PostgreSQL 8.1 result in the following error message: C:\Program Files\PostgreSQL\8.1\bin>psql -h name.local -p 5435 feb01-06-01 psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. 5. There are no related entries in pg_log 6. The following error is in the Windows Event log: Event Type: Error Event Source: PostgreSQL Event Category: None Event ID: 0 Date: 14/12/2006 Time: 1:06:13 PM User: N/A Computer: SERVER Description: FATAL: could not reattach to shared memory (key=5435001, addr=01590000): Invalid argument 7. If PostgreSQL Service is restarted via Control Panel > Administrative Tools > Component Services, everything runs normally and there are no problems connecting. Any further thoughts? Thanks in advance, George
В списке pgsql-general по дате отправления: