weird network issue

From: kevin kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: weird network issue
Date: 2008-03-28 16:31:09
Message-ID: D5915B78-09F2-4062-A7D1-640F2B2E92B4@kevinkempterllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jonathan Nalley 2008-03-28 16:45:41 Re: weird network issue
Previous Message Achilleas Mantzios 2008-03-28 13:01:39 Re: off-topic - list files on linux