Server Closed Connection Unexpectedly

From: David Siegal <dsiegal(at)thecsl(dot)org>
To: pgadmin-support(at)postgresql(dot)org
Subject: Server Closed Connection Unexpectedly
Date: 2005-01-05 19:55:49
Message-ID: Pine.LNX.4.58.0501051417290.27495@brave.cs.uml.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I'm hoping you can help me.

I am having trouble connecting to a remote Postgresql 7.4.2 database from
pgAdmin3 for Win32. I've tried using 2 different versions (1.02 and 1.20)
on 2 different Windows boxes in 2 different locations. I've tried
connecting as different users to different databases. Each time I
immediately get:

An error has occurred:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

The local pgadmin.log in debug mode shows something like:
2005-01-05 14:44:10 INFO : Destroying a connect dialogue
2005-01-05 14:44:10 STATUS : Connecting to database...
2005-01-05 14:44:10 INFO : Creating pgConn object
2005-01-05 14:44:10 INFO : Server name: csl-db-01.thecsl.org (resolved to: 129.63.24.86)
2005-01-05 14:44:10 INFO : Opening connection with connection string:
hostaddr=129.63.24.86 dbname=foobar user=foobar password=mypassword port=80
2005-01-05 14:44:11 QUERY : Set query (csl-db-01.thecsl.org:80): SELECT
pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE datname='foobar'
2005-01-05 14:44:11 ERROR : server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

2005-01-05 14:44:12 STATUS : Connecting to database... (1.50 secs)
2005-01-05 14:44:12 ERROR : Error connecting to the server: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

2005-01-05 14:44:13 INFO : Destroying pgConn object
2005-01-05 14:44:13 INFO : Destroying a pgServer object
2005-01-05 14:44:13 INFO : Creating a pgServer object
2005-01-05 14:44:13 INFO : Attempting to create a connection object...
2005-01-05 14:44:13 INFO : Creating a connect dialogue
2005-01-05 14:44:14 INFO : Destroying a connect dialogue
2005-01-05 14:44:14 INFO : pgServer object didn't initialise because the user aborted.
2005-01-05 14:44:14 INFO : Destroying a pgServer object

A look in the server's logs always shows something like this:
Jan 5 14:44:14 csl-db-01 postgres[4606]: [12-1] LOG: connection received: host=70.19.142.198 port=50833
Jan 5 14:44:14 csl-db-01 postgres[4606]: [13-1] LOG: connection authorized: user=foobar database=foobar
Jan 5 14:44:14 csl-db-01 postgres[4606]: [14-1] LOG: could not receive data from client: Connection reset by peer
Jan 5 14:44:14 csl-db-01 postgres[4606]: [15-1] LOG: unexpected EOF on client connection

I have no problem connecting to the database by other means (e.g.
hand-coded Java via jdbc, psql, as well as pgAdmin3 (1.02 and 1.20) from
a Debian box).

Any help would be greatly appreciated.

Thanks!
-David

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ian Barwick 2005-01-05 22:06:11 Re: compile problem with agadmin2-1.2.0 on SuSE 9.2 system
Previous Message Bruce Ferrell 2005-01-05 19:15:20 compile problem with agadmin2-1.2.0 on SuSE 9.2 system