Re: PostgreSQL doesn't accept connections when Windows

----- 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