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