Add a PostgreSQL database instance
To monitor your PostgreSQL database instance with SolarWinds Observability, complete the following:
In SolarWinds Observability, click Add Data in the upper-right corner.
On the Add Data dialog, click Database.
On the initial Add Database Instance dialog, click PostgreSQL.
Click Add Host to install a new SolarWinds Observability Agent, or choose an existing SolarWinds Observability Agent. Click Next to continue.For more information about installing the SolarWinds Observability Agent, see the Add a self managed host topic.
Choose the On Host, or Off Host Capture method. Click Next to continue.
Choose On Host if the service is in the same physical or virtual machine as the OS where you will install the SolarWinds Observability Agent. Npcap must be installed if you are monitoring databases for on-host data gathering on a Windows installation.
Choose Off Host if the service is in a remote machine such as Amazon RDS, and the SolarWinds Observability Agent will be installed on a different machine in the network.
Enter the instance address and database for your instance. Enter the associated username, password, and bindings if applicable. Click Next to continue.
The monitoring user must have the
pg_monitorrole. See PostgreSQL system requirements for more information.
Click the Enable SSL toggle and enter your SSL credentials to enable SSL.
Copy and execute the installation script on your PostgreSQL instance. The script will ensure that the correct privileges are set up on your instance. Click Next to continue.
Verify the information entered on the Summary tab. Click Finish.
When you complete the configuration, SolarWinds Observability displays data collected for the Database Instance entity. See Entity Explorer for details.
See SolarWinds Observability introduction for an overview of Database Instance entities and how they work in SolarWinds Observability.