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 |
