topic Re: SAS ESP Connectivity to Postgres DB in Streaming Analytics

SAS ESP Connectivity to Postgres DB

ankitd — Thu, 03 Oct 2019 10:41:34 GMT

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.

Kalind_Patel — Tue, 08 Oct 2019 05:11:42 GMT

May i see the details of pg_hba.conf file which you've added?

Also please share the odbc.ini file details.

LalitPatel — Mon, 14 Mar 2022 01:52:43 GMT

I think it is because you are trying to connect SAS ESP server with your localhost, which is inaccessible to SAS ESP server.

You may try to make your localhost accessible to the Internet by "port forwarding".