[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Fwd: [ADMIN] psql: could not connect to server: No route to host
From: Ricardo Benatti <rbenatti () gmail ! com>
Date: 2012-04-26 11:49:11
Message-ID: CAH_Ci94G7ijLr7wG4zfQC2iMa+xuV9RTiF9F79ngussopMU=Fg () mail ! gmail ! com
[Download RAW message or body]
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_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<http://www.postgresql.org/mailpref/pgsql-admin>
[Attachment #3 (text/html)]
<br clear="all">the port is listening in VM ? <br><br><blockquote style="margin:0pt \
0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" \
class="gmail_quote"><div style="margin-left:40px"><span style="font-family:courier \
new,monospace">netstat -nat</span><br style="font-family:courier new,monospace">
<br style="font-family:courier new,monospace"><span style="font-family:courier \
new,monospace">Active Internet connections (servers and established)</span><br \
style="font-family:courier new,monospace"><span style="font-family:courier \
new,monospace">Proto Recv-Q Send-Q Local Address Foreign Address \
State </span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">tcp 0 0 <a \
href="http://0.0.0.0/" target="_blank">0.0.0.0:80</a> \
0.0.0.0:* LISTEN </span><br \
style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">tcp 0 0 <a \
href="http://127.0.0.1:3350/" target="_blank">127.0.0.1:3350</a> \
0.0.0.0:* LISTEN </span><br \
style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">tcp 0 0 <a \
href="http://0.0.0.0:22/" target="_blank">0.0.0.0:22</a> \
0.0.0.0:* LISTEN </span><br \
style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">tcp 0 0 <a \
href="http://0.0.0.0:631/" target="_blank">0.0.0.0:631</a> \
0.0.0.0:* LISTEN </span><br \
style="font-family:courier new,monospace">
<b><span style="font-family:courier new,monospace">tcp 0 0 <a \
href="http://127.0.0.1:5432/" target="_blank">127.0.0.1:5432</a> \
0.0.0.0:* LISTEN </span> \
</b><br></div></blockquote><div>
</div><br>released access [ postgresql.conf ] for connections tcp ??<br>
<br><blockquote style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex;font-family:courier new,monospace" \
class="gmail_quote"><div style="margin-left:40px"># - Connection Settings -<br><br>
#listen_addresses = '*' # what IP address(es) to \
listen on;<br> \
# comma-separated list of addresses;<br> \
<b># defaults to 'localhost', '*' = all</b><br>
# \
(change requires restart)<br>port = 5432 \
# (change requires restart)<br>max_connections = 100 \
# (change requires restart)<br></div></blockquote>
<br><br>your network is configured in: pg_hba.conf<br><br><br><blockquote \
style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex;font-family:courier new,monospace" \
class="gmail_quote"><div style="margin-left:40px">
# IPv4 local connections:<br>host all all <a \
href="http://127.0.0.1/32" target="_blank">127.0.0.1/32</a> \
trust<br>host all all <a \
href="http://192.168.0.0/16" target="_blank">192.168.0.0/16</a> \
trust<br>
</div></blockquote><br><br>Hope this help.<br><br style="color:rgb(0,0,153)"><b \
style="font-family:verdana,sans-serif">Ricardo Benatti<br></b><br><img \
src="https://docs.google.com/uc?id=0B9g5sOkB5ucMNDRiZDQ1NDMtYjdkZi00MmNhLWI1OTgtNzdjMWZkY2Q3MWU1&hl=en"><br>
<br>
<div class="gmail_extra"><br><br><div class="gmail_quote">---------- Forwarded \
message ----------<br>From: <b class="gmail_sendername">Kevin Kempter</b> <span \
dir="ltr"><<a href="mailto:cs_dba@consistentstate.com" \
target="_blank">cs_dba@consistentstate.com</a>></span><br>
Date: Thu, Apr 26, 2012 at 1:39 AM<br>Subject: [ADMIN] psql: could not connect to \
server: No route to host<br>To: <a href="mailto:pgsql-admin@postgresql.org" \
target="_blank">pgsql-admin@postgresql.org</a><br><br><br>Hi all;<br>
<br>
I've setup PostgreSQL to talk across servers thousand of times... not sure what \
I'm doing wrong, maybe I'm just over-tired.<br> <br>
<br>
I have 2 scientific linux VM's running in vmware workstation<br>
<br>
server <a href="tel:1%20-%20192.168.1.125" value="+5511921681125" target="_blank">1 - \
192.168.1.125</a><br> server 2 - <a href="tel:192.168.1.127" value="+551921681127" \
target="_blank">192.168.1.127</a><br> <br>
I've disabled selinux on both servers<br>
<br>
Ive instaled PostgreSQL 9.1.3 on both servers<br>
<br>
I have listen_addresses on server 1 set to '*'<br>
<br>
postgres=# show listen_addresses ;<br>
listen_addresses<br>
------------------<br>
*<br>
(1 row)<br>
<br>
<br>
I've added this to the pg_hba.conf file of server 1:<br>
host all all <a \
href="http://192.168.1.0/24" target="_blank">192.168.1.0/24</a> trust<br> \
<br> <br>
I can scp files between the servers<br>
<br>
Then from server 2 I run this:<br>
<br>
$ psql -h <a href="tel:192.168.1.125" value="+551921681125" \
target="_blank">192.168.1.125</a><br>
psql: could not connect to server: No route to host<br>
Is the server running on host "<a href="tel:192.168.1.125" \
value="+551921681125" target="_blank">192.168.1.125</a>" and accepting<br> \
TCP/IP connections on port 5432?<br> <br>
<br>
am i loosing my mind?<br>
<br>
<br>
thanks in advance<span><font color="#888888"><br>
<br>
-- <br>
Sent via pgsql-admin mailing list (<a href="mailto:pgsql-admin@postgresql.org" \
target="_blank">pgsql-admin@postgresql.org</a>)<br> To make changes to your \
subscription:<br> <a href="http://www.postgresql.org/mailpref/pgsql-admin" \
target="_blank">http://www.postgresql.org/<u></u>mailpref/pgsql-admin</a><br> \
</font></span></div><br></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic