Connect to AWS

Table of contents

Connect to Postgres on AWS

Go the the Relational Database Service (RDS)

Screen Shot 2021-06-30 at 4.01.39 PM.png

Click on the Database Instances List

Screen Shot 2021-06-30 at 4.03.13 PM.png

Select the Database by its Identifier

Screen Shot 2021-06-30 at 4.07.24 PM.png

Get the Database Hostname

Screen Shot 2021-06-30 at 4.14.33 PM.png

Get the Database User and Password

These will have to be known to you or provided to you by someone on your team. AWS does support setting the root password which you can change by modifying the database.

Screen Shot 2021-06-30 at 4.17.33 PM.png

Firewalls and IP Whitelisting for Postgres

Your security settings may prevent access from anyone on the internet. AWS uses security groups to do much of its network level security. Click on the security groups to view the inbound rules that will allow your client machine to connect to the database.

Screen Shot 2021-06-30 at 4.23.10 PM.png

Add your Machine IP to the Whitelist

Find the IP address of your machine. Oftentimes you can just search for this online.

Screen Shot 2021-06-30 at 4.23.49 PM.png

Add your IP to the Inbound Rules to Connect to Postgres

Screen Shot 2021-06-30 at 4.25.11 PM.png

Table of Contents?

Spread the word