Prerequisites

The following section describes the prerequisites for working with Qlik Replicate and an AWS Aurora Cloud for PostgreSQL database source.

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:

   ./areplicate stop

2. Optionally, confirm that the service has stopped:

   ./areplicate status

3. Install PostgreSQL 13 client programs and libraries.

4. Install the ODBC driver for PostgreSQL 13.

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

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

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

   cat site_arep_login.sh

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

9. Start the Replicate service:

   ./areplicate start

10. Optionally, confirm that the service has started:

    ./areplicate status

Required permissions

The user specified in the General tab when Setting general connection properties must be granted the following permissions in the AWS Aurora Cloud for PostgreSQL database:

• For Full Load replication: Standard SELECT on the source database
• For Apply Changes replication: See Setting up AWS Aurora Cloud for PostgreSQL for CDC (Change data capture).

• When the Apply Changes and/or Store Changes task replication option is enabled, the user specified in the AWS Aurora Cloud for PostgreSQL source endpoint’s General tab must be granted superuser permissions.