# Prerequisites

This topic describes the client prerequisites when replicating to a Google Cloud AlloyDB for PostgreSQL target.

## Qlik Replicate Server for Windows

* The PostgreSQL ODBC Driver: PostgreSQL ODBC Driver [psqlodbc_13_01_0000-x64](https://ftp.postgresql.org/pub/odbc/versions.old/msi/psqlodbc_13_01_0000-x64.zip) or above must be installed on the Qlik Replicate machine.

* PgAdmin:

  1. Download and install [pgAdmin 4 (Windows)](https://www.pgadmin.org/download/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](https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Installation/Server_Procedures.htm).

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](https://help.qlik.com/en-US/replicate/November2024/Content/Replicate/Main/Installation/Server_Procedures.htm).