| 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: | Whole Thread | Raw Message | 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 |