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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | kevin kempter | 2008-03-28 16:56:19 | Re: weird network issue |
Previous Message | kevin kempter | 2008-03-28 16:31:09 | weird network issue |