Re: Server Closed Connection Unexpectedly

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