topic Re: PostgreSQL connection error in Qlik Replicate

PostgreSQL connection error

allann — Wed, 01 Jun 2022 20:09:28 GMT

We're trying to connect to a PostgreSQL source but running in to an error.

I also made sure the prereqs were followed: Prerequisites ‒ Qlik Replicate but not sure if editing pg_hba was correct. Is trust right?

Does anyone have other suggestions?

SwathiPulagam — Wed, 01 Jun 2022 20:13:47 GMT

Seems like you didn't set up the Postgres driver correctly.

Please share the odbcinst.ini and arep_login.sh file or you can create a case.

Thanks,

Swathi

allann — Wed, 01 Jun 2022 20:33:12 GMT

I see. Here's the ini file but I cannot locate the sh file.

SwathiPulagam — Wed, 01 Jun 2022 20:43:47 GMT

I see your Replicate server is on windows and arep_login.sh is a Linux file.

I reviewed your ODBCINST text and I see you installed a 32-bit drivers instead of 64-bit driver.

You have to uninstall all the existing Postgres drivers and follow the below user guide link for your reference:

Thanks,

Swathi

allann — Fri, 03 Jun 2022 15:57:06 GMT

We downloaded the 64 bit drivers but as you saw on the ODBCINST file, it shows as 32. I'm not sure what's going on.

Also, as the prerequisites show PostgreSQL 12, does it matter if the source databases are older versions?

Steve_Nguyen — Fri, 03 Jun 2022 18:56:57 GMT

1. see what is stated in user guide :

You have to uninstall all the existing Postgres drivers and follow the below user guide link for your reference:

Qlik Replicate Server for Windows:

PostgreSQL ODBC Driver psqlodbc_12_02_0000-x64 only must be installed on the Qlik Replicate machine.

Information note

Make sure that the psql.exe path (e.g. "C:\Program Files\PostgreSQL\1202\bin") is added to the system PATH.

2. you would then need to stop and restart the Replicate server service.