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.
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).
This sounds like you're having some win32 system problem, maybe firewall related?
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
