Prerequisites
This topic describes the client prerequisites when replicating to a Microsoft Azure Database for PostgreSQL target.
Qlik Replicate Server for Windows
-
The PostgreSQL ODBC Driver: PostgreSQL ODBC Driver psqlodbc_13_01_0000-x64 or above must be installed on the Qlik Replicate machine.
-
PgAdmin:
- Download and install pgAdmin 4 (Windows) on the Qlik Replicate machine.
- Add the "psql.exe" path to the system PATH.
-
Microsoft Visual Studio 2013 Redistributable (x86) - not (x64) - must be installed on the Qlik Replicate machine.
Qlik Replicate Server for Linux
Download PostgreSQL 13 ODBC driver, and client programs and libraries.
- Example PostgreSQL ODBC file name: postgresql13-odbc-13.02.0000-1PGDG.rhel8.x86_64.rpm
- PostgreSQL client programs and libraries file name: postgresql13-13.8-1PGDG.rhel<version>.x86_64.rpm
Then, open a shell prompt and do the following:
-
Stop the Replicate service:
./areplicate stop
-
Optionally, confirm that the service has stopped:
./areplicate status
-
Install PostgreSQL 13 client programs and libraries.
-
Install the ODBC driver for PostgreSQL 13.
-
Change the working directory to <Replicate-Install-Dir>/bin.
-
Copy the driver location to the site_arep_login.sh file:
echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/usr/lib:/usr/lib64:/usr/pgsql-13/lib" >> site_arep_login.sh
This will add the driver to "LD_LIBRARY_PATH" and update the driver location in the site_arep_login.sh file.
-
Optionally, confirm that the driver location was copied:
cat site_arep_login.sh
-
Makes sure that the /etc/odbcinst.ini file contains an entry for PostgreSQL, as in the following example:
[PostgreSQL Unicode(x64)]
Description = PostgreSQL ODBC driver
Driver = /usr/pgsql-13/lib/psqlodbc.so
Setup = /usr/pgsql-13/lib/psqlodbcw.so
UsageCount = 1
-
Start the Replicate service:
./areplicate start
-
Optionally, confirm that the service has started:
./areplicate status