Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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!