Monitor PostgreSQL running on AWS Lightsail

Follow

Srinivas Gattu

• December 25, 2018 17:31

Hi

 

I have my PostgreSQL on AWS Lightsail instance

 

I installed Cluster control on my local system (in a VM) and trying to monitor the PostgreSQL instance running on my AWS server

 

Logged in into Admin panel of local ClusterControl but cant see how to import that AWS PG instance

As it is asking for SSH password. I have only SSH PEM certificate provided by AWS

No password as such. I expected to be able to import the same file into ClusterControl

Please help

0

• 

  Ashraf Sharif

  • December 26, 2018 01:58

  Hi Srivinas,

  We've never tested the product with AWS Lightsail. However, most of the time, as long as the DB nodes are accessible via passwordless SSH, ClusterControl should be able to manage them.

  ClusterControl does need the SSH private/public key (PEM certificate or private key that you have) to connect via passwordless SSH to the DB nodes. Thus, no such password is needed. Do check the ClusterControl Requirements documentation at https://severalnines.com/docs/requirements.html

  Copy the SSH private key file (.pem) to the ClusterControl node and assign it with strict permission, accessible by sudoers or root. Then go to ClusterControl UI -> Import -> Import Existing Server/Cluster -> PostgreSQL and specify the correct key path on the ClusterControl server with the SSH username and port.

  When managing DB nodes located on the external network, ensure the security group/firewall allows connectivity to the required ports, as mentioned in the Requirements page.

  Regards,

  Ashraf

   

  0

  Comment actions Permalink

Please sign in to leave a comment.