On Mon, 2004-07-19 at 11:25, Adam H.Pendleton wrote:
> 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 18.104.22.168: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?
I made a typo. :-(
Actually, I failed to pass the -i option to postmaster, which is nearly
as stupid. Your message above put me on the right track.
Many thanks for all the replies - all of which were helpful and useful.
I'm just sorry I hadn't paid more attention. I apologise if anyone
thinks I wasted their time with this.
In response to
pgadmin-support by date
|Next:||From: Glenn Strout||Date: 2004-07-19 20:38:18|
|Subject: Status of pgadmin for OSX|
|Previous:||From: Adam H.Pendleton||Date: 2004-07-19 10:25:12|
|Subject: Re: Cannot connect to postgresql|