Prerequisites

This topic describes the client prerequisites when replicating to a Google Cloud SQL 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:

  1. Download and install pgAdmin 4 (Windows) on the Qlik Replicate machine.
  2. 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:

1. Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.

2. Install PostgreSQL 13 client programs and libraries.

3. Install the ODBC driver for PostgreSQL 13.

4. Change the working directory to <Replicate-Install-Dir>/bin.

5. 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.

6. Optionally, confirm that the driver location was copied:

   cat site_arep_login.sh

7. Makes sure that the /etc/odbcinst.ini file contains an entry for PostgreSQL, as in the following example:

   [PostgreSQL]

   Description = PostgreSQL ODBC driver

   Driver = /usr/pgsql-13/lib/psqlodbc.so

   Setup = /usr/pgsql-13/lib/psqlodbcw.so

   UsageCount = 1

8. Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.