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

Attachment: PGP.sig
Description: PGP signature



Reply via email to