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 <http://0.0.0.0/> 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_...@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<http://www.postgresql.org/mailpref/pgsql-admin>
