---
title: "How to Install and Set Up the PostgreSQL Client"
url: "https://dm0bkdes5q7a2ls.productfruits.help/en/article/new-article-40"
language: "en"
last_updated: "2025-12-18T05:00:42.236Z"
---

# 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:

1.  Download the latest installer for Windows x86-64  (example: postgresql-17.6-1-windows-x64 .exe)
2.  1.  [https://www.enterprisedb.com/downloads/postgres-postgresql-downloads](https://www.enterprisedb.com/downloads/postgres-postgresql-downloads)  
          
        ![](https://media.userguiding.com/files/knowledge-base/95602/file-1759343533323.png)
3.  Launch the installer.
4.  On the **Select Components** screen:
5.  1.  Select only **Command Line Tools**  
          
        ![](https://media.userguiding.com/files/knowledge-base/95602/file-1759343548758.png)
6.  Edit the **Environment Variables - System variables**.  
      
    ![](https://media.userguiding.com/files/knowledge-base/95602/file-1759344323058.png)
7.  Create a new system variable and add the path to the installed DLLs.
8.  Add this entry to the **Path System Variable**.
9.  1.  For example: ***C:\\Program Files\\PostgreSQL\\18\\bin***  
          
        ![](https://media.userguiding.com/files/knowledge-base/95602/file-1759344278807.png)
10.  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 )