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

Re: weird network issue

From: Jonathan Nalley <jnalley(at)fgp(dot)com>
To: 'kevin kempter' <kevin(at)kevinkempterllc(dot)com>,"'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: weird network issue
Date: 2008-03-28 16:45:41
Message-ID: 2CDFACB9D6B4DB45A4E5E59D476E10F8A7E62E5414@exchange.grnvl.fgp.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of kevin kempter
Sent: Friday, March 28, 2008 12:31
To: pgsql-admin(at)postgresql(dot)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.



In response to

Responses

pgsql-admin by date

Next:From: kevin kempterDate: 2008-03-28 16:56:19
Subject: Re: weird network issue
Previous:From: kevin kempterDate: 2008-03-28 16:31:09
Subject: weird network issue

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