Qlik Replicate: Failed to load Postgres driver Cannot load libpq-dll

[sureshkumar]

Testing the PostgreSQL Source Endpoint in Qlik Replicate may fail with the following error:

Failed to load Postgres driver. Cannot load libpq.dll

Resolution

You should have two entries in the system environment variables pointing to the following folders (default locations):

• C:\Program Files\PostgreSQL\12\bin
• C:\Program Files\psqlODBC\1202\bin

Both folders must include the libpq.dll file.

If the connection test fails even with libpq.dll present in both directories, then:

1. Copy the libpq.dll file from odbc\bin (C:\Program Files\psqlODBC\1202\bin) to  ~\Replicate\bin 
2. Restart the Qlik Replicate server service and the Replicate UI server service

Environment

• Qlik Replicate