David Siegal wrote:
> 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