How to Install and Set Up the PostgreSQL Client
Use the following instructions to install the PostgreSQL Client on all managed agents used to scan PostgreSQL.
Overview
PostgreSQL requires the native PostgreSQL client DLL and its associated SSL libraries and DLLs.
Install these on all managed agents used to scan PostgreSQL.
How to Install the PostgreSQL Client
Procedure:
- Download the latest installer for Windows x86-64 (example: postgresql-17.6-1-windows-x64 .exe)
- Launch the installer.
- On the Select Components screen:
- Select only Command Line Tools
- Select only Command Line Tools
- Edit the Environment Variables - System variables.
- Create a new system variable and add the path to the installed DLLs.
- Add this entry to the Path System Variable.
- For example: C:\Program Files\PostgreSQL\18\bin
- For example: C:\Program Files\PostgreSQL\18\bin
- Reboot your machine.
Common Errors
Resolve these errors with the procedure described in this article.
INFO- Database open returned: FAILURE
ERROR- Unable to open database (Module error: libpq.dll: The specified module could not be found. pq.dll: The specified module could not be found. DBMS API Library loading fails This library is a part of DBMS client installation, not SQLAPI++ Make sure DBMS client is installed and this required library is available for dynamic loading )