Re: Unable to connect to server - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: Unable to connect to server
Date
Msg-id CAMkU=1z2vkZ4gWMd_U+Vt8AWKGHnGDR8LV2=0bSd3d0DYG59OA@mail.gmail.com
Whole thread Raw
In response to Unable to connect to server  ("Javali, Pramod" <Pramod.Javali1@T-Mobile.com>)
Responses RE: Unable to connect to server
List pgsql-bugs
This is unlikely to be a bug, it seems like an admin issue.

When I've seen this "server closed the connection unexpectedly" immediately upon connection, it is usually because a port forwarder has accepted the connection and tried to pass it on to the real server, but the forwarder got a connection refused error.  As it already accepted the connection, it can't pass the "refused" back to the client so instead just closes it without comment, which is unexpected.

If that is what is happening, you will not find any direct log messages in the PostgreSQL log about it, as no connection was ever established and so there is nothing to log.  But if something else is going on, you might get log messages so check for them.

Make sure that the PostgreSQL server is actually running, is listening on the right port and the right network interface, and that any port forwarder or firewall is configured correctly.

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize
Next
From: Laurenz Albe
Date:
Subject: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432