When attempting to use the Automation Engine or Utilities pointing to a postgres DB, the processes fail with the following error:
U00029120 UCUDB: Function LoadLibrary failed. Library 'UCUPGS' error 'The specified module could not be found.
Release : 12.3
Component : AUTOMATION ENGINE, UTILITIES
Windows Setup
The following .dll files must be added to the bin folder of the Automation Engine and the Utilities, or must be included in the Windows path:
Additionally, for PostGres versions lower than 11.0:
These files are part of the psqlodbc package and can be downloaded from https://www.postgresql.org/ftp/odbc/versions/dll/. Make sure to use the latest version for your PostgreSQL installation.
UNIX
Make sure that a PostgreSQL client is installed.