Skip site navigation (1) Skip section navigation (2)

Fw: Re: Fw: Re: connection refused

From: Bruce Hyatt <brucejhyatt(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Fw: Re: Fw: Re: connection refused
Date: 2008-12-20 03:18:26
Message-ID: 131603.23257.qm@web34406.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Accidentally replied instead of replied-to-all ...

--- On Fri, 12/19/08, Bruce Hyatt <brucejhyatt(at)yahoo(dot)com> wrote:

> --- On Tue, 12/16/08, Ognjen Blagojevic
> <ognjen(at)etf(dot)bg(dot)ac(dot)yu> wrote:
> 
> > The simplest way to test if your network/iptables is
> set
> > correctly is to try to telnet the Postgres server:
> > 
> >   telnet server.example.com 5432
> > 
> > If you get "Connect failed", you have a
> > network/iptables problem, if you get a blank screen,
> then
> > the network and iptables are both ok, and you should
> check
> > Postgres config files.
> 
> I got 'connect failed' but here's my iptables
> chains:
> 
> Chain INPUT (policy ACCEPT)
> target     prot opt source               destination
> RH-Firewall-1-INPUT  all  --  anywhere             anywhere
> 
> Chain FORWARD (policy ACCEPT)
> target     prot opt source               destination
> RH-Firewall-1-INPUT  all  --  anywhere             anywhere
> 
> Chain OUTPUT (policy ACCEPT)
> target     prot opt source               destination
> 
> Chain RH-Firewall-1-INPUT (2 references)
> target     prot opt source               destination
> ACCEPT     all  --  anywhere             anywhere
> ACCEPT     icmp --  anywhere             anywhere          
>  icmp any
> ACCEPT     ipv6-crypt--  anywhere             anywhere
> ACCEPT     ipv6-auth--  anywhere             anywhere
> ACCEPT     udp  --  anywhere             224.0.0.251       
>  udp dpt:5353
> ACCEPT     udp  --  anywhere             anywhere          
>  udp dpt:ipp
> ACCEPT     all  --  anywhere             anywhere          
>  state RELATED,ESTABLISHED
> ACCEPT     tcp  --  anywhere             anywhere          
>  state NEW tcp dpt:http
> REJECT     all  --  anywhere             anywhere          
>  reject-with icmp-host-prohibited
> 
> It doesn't look to me like anything is restricted
> (except icmp).
> 
> Per postgresql.conf: listening '*' addresses on
> port 5432.
> 
> pg_hba.conf IPv4:
> host    all         all     192.168.1.0   255.255.255.0  
> trust
> 
> The only possible anomaly I could find is that the
> configure-services gui reports postgresql status as '-p
> is stopped' but I can connect on the localhost.
> 
> TIA,
> Bruce


      

pgsql-novice by date

Next:From: Stephen ChoulartonDate: 2008-12-22 22:04:59
Subject: internet explorer patch
Previous:From: Nagle, Gail A (US SSA)Date: 2008-12-19 01:00:08
Subject: Re: Is it possible to query the database for the values of an enumerated type in 8.3.3?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group