Re: could not connect to the server error

"Stefano B." <stefano(dot)bonnin(at)comai(dot)to> writes:

> I have several java jdbc client applications that connect to my Postgres
> 8.0.4 server.
> "After some days" the server rejects the connections. There are no message
> in the log file. Only the local connections are permitted.
>
> I have tryed to make a connection with EMS postgresql and I receive the
> following error:
>
> could not connect to the server: Connection refused (0x0000274D/10061)
> Is the server running on host 213.212.159.153 and accepting TCP/IP
> connections on port 5432?

Are the client and server on different machines? Is there a firewall
or other network filter in between?

> the LOCAL CONNECTIONS are accepted.
> Could be a JDBC problem? It seems that "something" is still open and
> postgresql can't create a new connection. I had this problem with the
> older 8.0.x postgres version.

"Connection refused" means the connection attempt is being rejected at
the network layer--either the PG server isn't running, or there's a
firewall, or the kernel on the server machine is rejecting the packet.

Can you do 'telnet 213.212.159.153 5432' on the client machine and get
a successful connection?

-Doug