When connecting DevTest to a remote PostgreSQL database, getting this error:
Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "126.96.36.199", user "postgres", database "IAM_10_X_0", SSL off
The pg_hba.conf file on the PostgreSQL database does is not configured to accept connections from host.
You configure DevTest property files like you would do for any database, but for PostgreSQL, you need to add information of all the client hosts connecting to the database.
DevTest 10.6.0 and later
Edit file C:\Program Files\PostgreSQL\11\data\pg_hba.conf and add entry of DevTest host machine accessing the database. **
This file controls: which hosts are allowed to connect, how clients are authenticated, which PostgreSQL user names they can use, which databases they can access. Records take one of these forms:
See example below:
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all postgres 55.66.777.8/32 md5 <== this is the IP of the machine PostgreSQL database is running
host all postgres 188.8.131.52/32 md5 <== this is the IP of the machine accessing PostgreSQL
NOTE: If IAM, Enterprise database and Registry are all on separate machines, you will need an entry for each host.
** This would be the location of the pg_hba.conf file for what ever version of PostgreSQL you are running. This example is PostgreSQL 11.