How to connect to AWS Elastic Beanstalk Postgres DB using PSequel app

How to connect to AWS Elastic Beanstalk Postgres DB using PSequel app

Transcript

1. How to connect to AWS Elastic Beanstalk Postgres DB using PSequel app @zulhhandyplast Last update: 9th July 2016 01:40AM
2. Go to RDS Dashboard, select your DB instance and take note these values
3. Go to http://cmyip.net/ to get your local machine IP address
4. Go to https://console.aws.amazon.com/vpc/, click Security Groups and find a record based on #5 and #6 values from first step. And then, check the checkbox
5. Click on Inbound Rules and click on Edit button
6. Click Add another rule button
7. Put your local machine IP address followed by /32 and press Save button
8. Make sure you see Save Successful green alert
9. Put Host, Port, User and Database values based on the values from first step. Password is your DB password that you put during database creation process (not in this tutorial). Click Connect button
10. You’re now remotely connected to your AWS RDS Postgres database. Now you can see your DB structures, contents and do CRUD operation for that contents