Re: Cannot connect to postgresql

On Jul 18, 2004, at 4:03 PM, Peter Bradley wrote:

> netstat -l confirms that the server is listening on port 5432.
>
> If I try to telnet to port 5432 I get "Connection refused" both as my
> own user and as the postgres user.

If your postgresql server is indeed listening on TCP port 5432, and you 
issue a telnet command to that port, and get connection refused, then 
there are three probable reasons you cannot connect:

1) Postgresql is listening on a different interface than you are trying 
to connect to.  IOW, it might be listening on 1.2.3.4:5432, and you're 
telnetting to 127.0.0.1:5432.  Your netstat command should show what 
interface it's listening on (ideally, it should be 0.0.0.0:5432, which 
is all interfaces).

2) You've got a firewall installed, blocking port 5432.  A lot of 
firewalls return RST packets (which is what generates the connection 
refused message) to incoming connections.  Make sure iptables isn't 
blocking 5432.

3) You made a typo.  :-)

What is the result of looking at those three items?

ahp