Hello Experts,
I have a single machine SAS Viya 3.4, SAS ESP 5.2 deployed environment being hosted on Linux OS.
As a part of connectivity setup between ESP with Postgres DB using ODBC driver, I have configured the odbc.ini file as attached.
Before proceeding ahead with the ESP - Postgres configuration, I tried validating the same using isql test.
Unfortunately the isql test failed stating that the IP of the server mentioned in the odbc.ini is not present in pg_hba.conf
Tried adding the IP in the conf file however keep receiving the same error message further the entry gets reverted back in case of a service restart.
Have tried putting localhost, IP of server, actual hostname of server in the odbc.ini file but no success.
Can someone please help with this.