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@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
Hi,
It is written on error log of psql. Postgres service sees your IP as 10.0.0.254, not 10.42.42.16. Most probably there is a NAT between your box and Postgres service. You should add following entry to pg_hba.conf and restart Postgres.
host all all 10.0.0.254/32 md5
Best regards.
İyi çalışmalar.
Samed YILDIRIM
10.11.2016, 15:47, "Ron Watkins" <rwatkins@xxxxxxxxxxxxxxx>:
