topic Re: Qlik replicate PostgreSQL as target error in Qlik Replicate

Qlik replicate PostgreSQL as target error

dineshkumarl — Sat, 05 Nov 2022 13:41:35 GMT

Hi, I am trying to use PostgreSQL as a target in Qlik Replicate. My PostgreSQL-12.1 is installed on RHEL 8 and Qlik replicate is installed on Windows server. I have installed psqlodbc driver-12.1 on windows server where Qlik Replicate is installed.

I have PgAdmin installed on windows server as well where Qlik Replicate is. I am able to connect to PostgreSQL using PgAdmin. However, when I try to test connection in Qlik replicate is receive error: "psql is not recognized as an internal or external command.

I have set the PATH variable on RHEL 8 directing to PostgreSQL binaries. But still wasn't able to succeed in making a connection from Qlik Replicate.

Error screenshot attached.

Re: Qlik replicate PostgreSQL as target error

Heinvandenheuvel — Sat, 05 Nov 2022 19:01:15 GMT

RTFM?

Did you read the Prerequisite section in the User Guide?

You need a path to psql in the (Windows) Replicate server.

"Prerequisites - The following topic describes the client prerequisites when replicating to a PostgreSQL target.
- The PostgreSQL ODBC Driver: PostgreSQL ODBC Driver psqlodbc_12_02_0000-x64 or
above must be installed on the Qlik Replicate machine.
- pgAdmin: The pgAdmin Open Source administration and development platform for PostgreSQL must be installed on the Qlik Replicate machine.
- Make sure that the psql.exe path (e.g. "C:\Program Files\PostgreSQL\1202\bin")
is added to the system PATH."

Verify by starting psql from a CMD command line.

Be sure to re-start the Replicate services to pick up the new path.

Hein.

Re: Qlik replicate PostgreSQL as target error

dineshkumarl — Sat, 05 Nov 2022 21:40:54 GMT

Hello Hein,

I had psqlodbc 13.02 on the Windows Server. I uninstalled and installed version 12.01 on it.

I reinstalled version 13.02. I was missing out on restarting Qlik Replicate services.

Thanks for helping me out. Cheers!