From: | Ron Watkins <rwatkins(at)dssolutions(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | psql remote database access |
Date: | 2016-11-09 18:00:24 |
Message-ID: | abd561fd9692b8177d0bbdcc2028baf0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Im sure this has been addressed somewhere, but I wasn’t able to locate any
answers.
I have a postgres database running on a different host and I need to access
it remotely from another box.
Boxes are CentOS 6, and I opened the firewall port 5432 on the database
server host.
Also, on the database server host, I made the following entries to
/var/lib/pgsql/9.6/data/pg_hba.conf.
local all all md5
host all all 127.0.0.1/32 md5
host all all 10.42.42.16/24 md5
When I try to use psql to attach to the remote database, I get the
following error:
[root(at)host1 ~]# psql -h host2 -p 5432 -U postgres
psql: FATAL: no pg_hba.conf entry for host "10.0.0.254", user "postgres",
database "postgres", SSL off
From | Date | Subject | |
---|---|---|---|
Next Message | Samed YILDIRIM | 2016-11-10 13:53:07 | Re: psql remote database access |
Previous Message | Igor Neyman | 2016-11-08 18:56:30 | Re: PG 9..5 index performance Q's |