Fwd: psql: could not connect to server: No route to host

Поиск
Список
Период
Сортировка
От Ricardo Benatti
Тема Fwd: psql: could not connect to server: No route to host
Дата
Msg-id CAH_Ci94G7ijLr7wG4zfQC2iMa+xuV9RTiF9F79ngussopMU=Fg@mail.gmail.com
обсуждение исходный текст
Ответ на psql: could not connect to server: No route to host  (Kevin Kempter <cs_dba@consistentstate.com>)
Ответы Re: psql: could not connect to server: No route to host  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
Дерево обсуждения

the port is listening in VM ?

netstat -nat

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State     
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN    
tcp        0      0 127.0.0.1:3350          0.0.0.0:*               LISTEN    
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN    
tcp        0      0 0.0.0.0:631             0.0.0.0:*               LISTEN    
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN    
 

released access [ postgresql.conf ] for connections tcp ??

# - Connection Settings -

#listen_addresses = '*'                 # what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost', '*' = all
                                        # (change requires restart)
port = 5432                             # (change requires restart)
max_connections = 100                   # (change requires restart)


your network is configured in:  pg_hba.conf


# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
host    all         all         192.168.0.0/16        trust


Hope this help.

Ricardo Benatti





---------- Forwarded message ----------
From: Kevin Kempter <cs_dba@consistentstate.com>
Date: Thu, Apr 26, 2012 at 1:39 AM
Subject: [ADMIN] psql: could not connect to server: No route to host
To: pgsql-admin@postgresql.org


Hi all;

I've setup PostgreSQL to talk across servers thousand of times... not sure what I'm doing wrong, maybe I'm just over-tired.


I have 2 scientific linux VM's running in vmware workstation

server 1 - 192.168.1.125
server 2 - 192.168.1.127

I've disabled selinux on both servers

Ive instaled PostgreSQL 9.1.3 on both servers

I have listen_addresses on server 1 set to '*'

postgres=# show listen_addresses ;
 listen_addresses
------------------
 *
(1 row)


I've added this to the pg_hba.conf file of server 1:
host     all             all             192.168.1.0/24        trust


I can scp files between the servers

Then from server 2 I run this:

$ psql -h 192.168.1.125
psql: could not connect to server: No route to host
       Is the server running on host "192.168.1.125" and accepting
       TCP/IP connections on port 5432?


am i loosing my mind?


thanks in advance

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

В списке pgsql-admin по дате отправления:

Предыдущее
От: Matheus de Oliveira
Дата:
Сообщение: Re: psql: could not connect to server: No route to host
Следующее
От: Kevin Kempter
Дата:
Сообщение: Re: psql: could not connect to server: No route to host