amazon-web-servicesamazon-ec2amazon-rds

AWS - How could I check if EC2 connected with RDS?


I created EC2 instance and security group for the RDS ( its type: PostgreSQL and source: launch-wizard-1 (EC2 has) ). And also I created the RDS instance.

Then, Is there any way how could I check if EC2 connected with RDS correctly?

The EC2 instance has no any data, it is just created.


Solution

  • There are two ways to try and connect to your RDS for testing:

    1. Install db client on the ec2 instance and check connectivity.This link will help you :

    https://github.com/snowplow/snowplow/wiki/Setting-up-PostgreSQL

    1. You can also connect from your localhost to the rds endpoint using putty and ssh tunneling.

    enter image description here

    Once connected you can use your local db client like dbeaver for connecting.