This page explains how to add PostgreSQL instances running on self managed Linux, including cloud hosted Linux, i.e. EC2. 

1. Go to  Configuration → Monitored servers → Add → PostgreSQL
   

   

2. Select Linux as the host operating system.

In the machine name field, enter the server you want to monitor.

Adding an instance

To add the PostgreSQL instance on a Linux machine, enter the machine IP address, under the machine name.
SQL Monitor adds the instance that is running on the machine.

1. You will need to provide two sets of credentials to connect to:
   • The host Linux machine on which the instance is running.
   • The PostgreSQL instance.

   SQL Monitor uses SSH to connect to a Linux host, you can either use password authentication or public key authentication, see Connecting to a Linux Machine. For the instance, enter the PostgreSQL credentials.

   SQL Monitor does not require any root privileges for the SSH connection.

2. When you click Add, SQL Monitor attempts to add the host machine and instance to the list of monitored servers:

   Once added, the server name can't be edited. If you typed the name incorrectly, the server will be added with a status of "Connection failed (Unreachable)". To fix this, remove the server and add it again.

   Once a connection is established and a data collection event succeeded, the status is displayed as Monitoring (Connected). If SQL Monitor encounters a problem and displays a different status, see Monitoring status explained.

Editing the credentials or properties of monitored servers

See Managing Monitored Servers.