Re: Cannot connect to postgresql

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 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

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.

Cheers

Peter