Re: weird network issue

Could you send us the distro and version of Linux that you're using on these two boxes?

Just as a sanity check and assuming you have a telnet client on the .13 box, can you perform the following command:

telnet 192.168.111.11 5432

and then paste the output to us. I guess conceptually there's not a whole lot of difference between doing that and
usingpsql -h 192.168.111.11 but it might eliminate some layer of issues.  If you're familiar with nmap or similar
programsyou can accomplish the same thing to ping .11 on port 5432 

> -----Original Message-----
> From: kevin kempter [mailto:kevin@kevinkempterllc.com]
> Sent: Friday, March 28, 2008 12:56
> To: Jonathan Nalley
> Cc: 'pgsql-admin@postgresql.org'
> Subject: Re: [ADMIN] weird network issue
>
> Not sure. I'm not so well versed in the firewall/networking areas. I
> can however do an scp pull from both machines :
>
> scp a file from 192.168.111.13 while logged onto 192.168.111.11
> and
> scp a file from 192.168.111.11 while logged onto 192.168.111.13
>
>
> Can you point me where to look for firewall/iptables/SE issues?
>
>
> Thanks in advance
>
>
>
>
>
> On Mar 28, 2008, at 10:45 AM, Jonathan Nalley wrote:
>
> > are you running any kind of firewall/iptables/SELinux  where the
> > settings are perhaps not the same on the two machines?
> >
> >
> > From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-
> owner@postgresql.org
> > ] On Behalf Of kevin kempter
> > Sent: Friday, March 28, 2008 12:31
> > To: pgsql-admin@postgresql.org
> > Subject: [ADMIN] weird network issue
> >
> > Hi LIst;
> >
> > I have 2 Linux servers:
> > 192.168.111.11
> > 192.168.111.13
> >
> > Both are running postgres v 8.2.6
> >
> > I can ping the .11 box from .13 and vice versa
> > I can connect remotely from the .11 box to the .13 box but I cannot
> > connect to the .11 box from the .13 box.
> >
> > I can do this:
> >
> > on the 192.168.111.11 box:
> >
> > -bash-3.1$   psql -h 192.168.111.13
> > Welcome to psql 8.2.6, the PostgreSQL interactive terminal.
> >
> > Type:  \copyright for distribution terms
> >       \h for help with SQL commands
> >       \? for help with psql commands
> >       \g or terminate with semicolon to execute query
> >       \q to quit
> >
> > postgres=#
> >
> > However if I do this it fails:
> >
> > on the 192.168.111.13 box:
> >
> > -bash-3.1$   psql -h 192.168.111.11 postgres
> > psql: could not connect to server: No route to host
> >        Is the server running on host "192.168.111.11" and accepting
> >        TCP/IP connections on port 5432?
> >
> >
> >
> > Both boxes have the same copy of the postgresql.conf file and the
> > pg_hba.conf file.
> >
> > Here's the listen address setting (on the 192.168.111.11 box) from
> > the postgresql.conf file:
> > listen_addresses = '*'
> >
> >
> > I also checked (after a restart) that the listen address and port
> > was in fact as I thought
> > on 192.168.111.11 :
> >
> >
> > Welcome to psql 8.2.6, the PostgreSQL interactive terminal.
> >
> > Type:  \copyright for distribution terms
> >       \h for help with SQL commands
> >       \? for help with psql commands
> >       \g or terminate with semicolon to execute query
> >       \q to quit
> >
> > postgres=# show listen_addresses;
> > listen_addresses
> > ------------------
> > *
> > (1 row)
> >
> > postgres=# show port
> > ;
> > port
> > ------
> > 5432
> > (1 row)
> >
> > postgres=#
> >
> >
> > Here's the current pg_hba.conf file on 192.168.111.11 :
> >
> >
> >
> > # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> >
> > # "local" is for Unix domain socket connections only
> > local   all         all                               ident sameuser
> > # IPv4 local connections:
> > host    all         all         127.0.0.1/32          ident sameuser
> > # IPv6 local connections:
> > host    all         all         ::1/128               ident sameuser
> >
> > #DRW.  This should be tighted up once the db instances are figured
> out
> > host    all         all         192.168.111.0/24              trust
> >
> >
> >
> > I'm stumped..
> >
> > Anyone have any thoughts ?
> >
> > Thanks in advance.
> >
> >
>
>