trouble connecting to DB

From: "tgs" <tgstambaugh(at)q(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: trouble connecting to DB
Date: 2009-07-19 06:12:25
Message-ID: BLU0-SMTP88C949FB4BDD7134445A1A51C0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi - I installed PostgreSQL 8.4 on Windows XP Pro using the packaged
installer with no errors, but am having a problem connecting. The symptoms
are:

1. When attempting to connect in PGAdmin III, I get an error message:
ERROR : Error connecting to the server: server closed the connection
unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

2. The Windows Application and System event logs show no unusual errors
just: 'Server Started and accepting connections'.

3. When I start the server, I get something like the following in the
postgresql log (in \pg_log):

2009-07-18 22:34:37 MSTLOG: database system was shut down at 2009-07-18
22:34:33 MST
2009-07-18 22:34:37 MSTLOG: database system is ready to accept connections
2009-07-18 22:34:37 MSTLOG: could not receive data from client: An
operation was attempted on something that is not a socket.
2009-07-18 22:34:37 MSTLOG: incomplete startup packet
2009-07-18 22:34:37 MSTLOG: autovacuum launcher started
2009-07-18 22:34:39 MSTLOG: could not receive data from client: An
operation was attempted on something that is not a socket.
2009-07-18 22:34:39 MSTLOG: incomplete startup packet

(The incomplete startup packet could repeat more times.)

Usually when I've seen the 'connection closed' message with other software,
it means an authentication error, so I've tried the following with no luck:

1. Verified the postgres user-id in Computer Management. It is a member of
no groups (seems strange to me, but apparently this is required.)
2. Verified the password by changing it in Computer Management/Users, and in
Services 'Login as' to be sure they matched and were what I thought.

3. I've also checked firewall (Comodo Pro) and antivirus (Avira) logs -
there are no entries showing postgres being blocked.
4. Also attempted the connect with firewall and antivirus turned off.
5. Since the postgres service is dependent on the RPC service, I verified it
was set to Automatic and running.

This is probably something simple and obvious, but I don't see it. Any help
would be appreciated.

Thanks,
Terry S. in AZ

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mohlomi Moloi 2009-07-20 07:28:25 Maximize columns in a table
Previous Message ...tharas 2009-07-19 03:07:02 Re: Rate of increase/decrease for a set of values