How to Integrate the PostgreSQL Plugin

Introduction

This document provides a step-by-step guide to integrating the PostgreSQL Plugin into an existing host for monitoring PostgreSQL database performance. The process includes reviewing prerequisites, configuring the plugin, installation, dashboard setup, and uninstallation.

Steps to Integrate PostgreSQL Plugin

Step 1: Navigate to Metrics Integration

1. Log in to the application.

2. Navigate to the Integration section by clicking Metrics in the left-side panel.

   

Step 2: Expand the Database Systems Section

1. Scroll to the Database Systems section and click on the PostgreSQL Plugin.

   

Step 3: Follow Plugin Prerequisites

1. Expand the Plugin Prerequisites section to view and follow the required steps for PostgreSQL plugin installation.

Step 4: Plugin Configuration

1. Download the installation script using the provided command or script.

2. Assign execution permissions to the script by running the appropriate command.

   

Step 5: Plugin Installation

1. Select the target host from the available list.

   1. If the host is not listed, you must first Add the Linux Agent.

   
2. Execute the Installation Script:

   1. Once the host is selected, a customized installation script will be generated. Execute this script on the remote server/host to complete the PostgreSQL plugin installation.

Step 6: Install the Dashboard

1. Click the Install Dashboard button to set up a detailed metrics dashboard for monitoring PostgreSQL database performance, including resource utilization, query optimization, and error tracking.

   

Step 7: Verify Installation

1. Navigate to the Metrics Dashboard page.

2. Confirm that the PostgreSQL Dashboard is displayed, indicating successful integration and setup.