Connecting to PostgreSQL

For the following products, OpenSSL 3.x is required in order to connect to PostgreSQL:

  • DataMagic Server for Linux (64-bit version) Ver.3.4.0 and later

  • DataMagic Server for zLinux Ver.3.4.0 and later

 

Regardless of whether TLS encrypted communication is used, the shared library files below are required.

Make sure that these two files exist after installing OpenSSL 3.x.

  • libssl.so.3

  • libcrypto.so.3

 

If a library is missing, the following error is output in the detailed message of the data processing log or the test connection to the database.

Example of output error

libssl.so.3: cannot open shared object file: No such file or directory

 

If you encounter difficulties installing OpenSSL, follow the steps below to replace libpq.so.5.17 with a file that does not need OpenSSL.

How to replace libpq.so.5.17

1. Move to "bin" in the installation directory for DataMagic.

2. Rename libpq.so.5.17 to any file name you prefer, such as libpq.so.5.17.ssl.

3. Rename libpq.so.5.17.nossl to libpq.so.5.17.

 

To connect DataMagic to PostgreSQL, set the environment variable as below.

LD_LIBRARY_PATH

For AIX, specify LIBPATH as the directory. For HP-UX, specify SHLIB_PATH as the directory.

Specify the execute module storage directory DMEXEP.

Available databases

For details about the PostgreSQL versions to which DataMagic can connect, access the following URL and check the website:

URL:  https://www.hulft.com/en/