Configure PostgreSQL database integration

To integrate PostgreSQL with SolarWinds Observability SaaS:

1. In SolarWinds Observability SaaS, click Add Data at the top.

2. In the Add Data dialog Intro, click the Integrations tab, and then click PostgreSQL.

3. In the Add PostgreSQL DB dialog, select a host with the SolarWinds Observability Agent you want to use for PostgreSQL and click Next.

   To display only Agents running in a Kubernetes cluster, click the List only Agents... toggle.

   If you want to install a dedicated Agent on a dedicated host, add the host and then add the PostgreSQL integration. See Add a self-managed host.

   If you prefer using Docker, see Run the SolarWinds Observability Agent as a Docker image or Kubernetes deployment.

4. Select where PostgreSQL is located:

   • On Host: PostgreSQL runs on the same physical or virtual machine as the Agent.

   • Off Host: PostgreSQL runs on a different physical or virtual machine than the Agent.

5. Provide the user name, copy the script, and run it on the PostgreSQL.

   Collecting PostgreSQL metrics requires that the account used to collect the data has access to appropriate tables. If the account cannot access the tables, relevant metrics will not be collected.

6. Specify credentials to be used for authenticating the PostgreSQL integration in SolarWinds Observability SaaS.

   • Add New Credential

     Select this option to create new credentials. Provide a name for the credentials set and the requested details, such as password, API key, and client secret.

   • Use Existing Credential

     Select this option to use existing credentials. Select credentials from the list.

7. Review the configuration and click Deploy to deploy the changes to the agent.

   1. If the you are onboarding AWS, select Amazon RDS Postgresql. For on-premises, select PostgreSQL.

   2. Select the Database Deployment Type as PostgreSQL or Amazon RDS PostgreSQL.

   3. Provide a Display Name.

   4. Review the Collection Interval. The default is 30 seconds.

   5. In the DBMS Instance Address field, add the IP/FQDN of the server with the port number as <IP/FQDN>:<Port>.

   6. Select an option for Target Databases on Selected DBMS:

      • Select All: Monitor all databases available in your server.

      • Select Specific: Name the specific database you wish to connect to within your server.

      • All Except: Select all databases you want to exclude from monitoring. All others will be included.

8. To use encrypted communication between the Observability Agent and PostgreSQL, toggle the SSL Enabled option to On.

   When SSL is enabled, you can also specify the SSL Mode.

   SSL Mode:

   • Verify Full: The highest verification level. Ensures the server certificate is valid, trusted, and that the hostname matches the certificate.

   Certificates related:

   • SSL Authority Path

     Specify the location of the Certificate Authority (CA) file used to verify the authenticity of the PostgreSQL server’s SSL certificate.

     The file must contain PEM-encoded data.

     Example paths:

     /etc/solarwinds/certs/ca.pem
C:\ProgramData\SolarWinds\UAMSClient\plugin-storage\ca.pem

   • SSL Certificate Path

     Provide the location of the client’s public key certificate file, which is used for mutual authentication between the client and the PostgreSQL server.

     The file must contain PEM-encoded data.

     Example paths:

     /etc/solarwinds/certs/client_cert.pem
C:\ProgramData\SolarWinds\UAMSClient\plugin-storage\client_cert.pem

   • SSL Key Path

     Enter the location of the client’s private key file that corresponds to the client certificate.

     The file must contain encoded data and should be securely stored.

     Example paths:

     /etc/solarwinds/certs/client_cert.key
C:\ProgramData\SolarWinds\UAMSClient\plugin-storage\client_cert.key

When the installation is complete, you can continue to observe PostgreSQL data. Use the buttons on the Summary screen.

To view metrics collected for PostgreSQL, click Analyze > Metrics and search for postgresql. See Metrics Explorer for details.