Replicate 7.0 PostgreSQL Source prerequisites

[john_wang]

PostgreSQL source prerequisites in Replicate 7.0 User Guide:

Client side

• Qlik Replicate Server for Windows:
  PostgreSQL ODBC Driver psqlodbc_12_02_0000-x64 only must be installed on the Qlik Replicate
  machine.

Environment

• Replicate Nov 2020 (7.0)
• PostgreSQL 12.2 client

Resolution

Fresh Install 10.3 first, then perform upgrade installation of 12.2

    Execute "psqlodbc_x64" in 10.3 package first, then execute it again in 12.2 package.

https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_10_03_0000-x64.zip
https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_12_02_0000-x64.zip

    Let's assume the installation default folder is: C:\Program Files\psqlODBC\1003\bin while you install 10.3

    Add below folder to the system variable PATH:

C:\Program Files\psqlODBC\1003\bin

Cause

Libintl-8.dll is a DLL with old versions (09.03 - 10.3) but it is not included with the 12.02 driver.

Replicate reports error if install psql ODBC version 12.02 only:

SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'PostgreSQL Source', type 'PostgreSQL Source'.. SYS,GENERAL_EXCEPTION,Stream component initialization function has failed for component 'PostgreSQL Source', type 'PostgreSQL Source'.,Error Initializing endpoint. Failed to load Postgres NLS driver Cannot load <libintl-8.dll, >: The operation completed successfully. Cannot load <libintl-8.dll>: The specified module could not be found.

Internal Investigation ID(s) 

support cases 02154903, 02153701