Error when connecting to our AWS postgres database from our on-prem 2012 server

djones53 — Wed, 19 Mar 2025 23:06:21 GMT

We are using Qlik to replicate between IBMi DB2 (source) and PostgreSQL on AWS RDS(target). We installed Qlik on our on-prem 2012 WIN server. We were able to successfully connect to our source DB but when we are trying to test the connection of the PostgreSQL on AWS RDS which is our target endpoint, we are getting the following error, we added the on-prem server’s IP address to the inbound rules of the AWS VPC on which the PostgreSQL is present but still facing the issue:

SYS-E-HTTPFAIL, Cannot connect to ODBC provider.

SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: root certificate file "C:\Windows\system32\config\systemprofile\AppData\Roaming/postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification.

We tried to disable the SSL certificate validation and then we are getting the following error:

SYS-E-HTTPFAIL, Cannot connect to ODBC provider.

SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: FATAL: no pg_hba.conf entry for host "10.179.136.15", user "v-token-pa-break-gl-9TJjzoVTJpZgaHvQ0Kwp-1666902015", database "product_definition", no encryption

We need some direction on how to resolve this issue!

Re: Error when connecting to our AWS postgres database from our on-prem 2012 server

sudheer-kumar-sp — Wed, 15 May 2024 20:26:06 GMT

How did you resolve this issue.

topic Error when connecting to our AWS postgres database from our on-prem 2012 server in Data Movement & Streaming

Error when connecting to our AWS postgres database from our on-prem 2012 server

Re: Error when connecting to our AWS postgres database from our on-prem 2012 server