From: | CS DBA <cs_dba(at)consistentstate(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Canot access PostgreSQL via psql -h (Vmware Fusion) |
Date: | 2012-08-24 04:15:49 |
Message-ID: | 64CA6636-C7A2-4305-8A06-A133DEEFEAE7@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all;
I've fired up 2 CentOS 6.2 VM's via vmware fusion 5 (on a mac).
I disables selinux on both, and installed postgres 8.4.13 on both VM's
I set listen_addresses = '*'
and I added a trust entry for each server in the opposite server's pg_hba.conf file.
However I cannot access one server from the other one via psql -h <I.P. address>
I get the standard error:
psql -h 192.168.91.145
psql: could not connect to server: No route to host
Is the server running on host "192.168.91.145" and accepting
TCP/IP connections on port 5432?
I can ssh between servers, I see no entry in the postgres log per the connection attempt (I have log_connections set to on)
Currently I have networking set to "share with my mac" or NAT. I tried setting networking to "Private to my mac" with the same results. Tried Autodetect (Bridged) as well, no luck
Can anyone help me debug this?
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Schmitz | 2012-08-24 05:14:13 | Re: Canot access PostgreSQL via psql -h (Vmware Fusion) |
Previous Message | Bruce Momjian | 2012-08-24 02:47:48 | Re: Does pg_reset_stats() influence autovacuum? |