Connect to Postgres on AWS
Go the the Relational Database Service (RDS)
Click on the Database Instances List
Select the Database by its Identifier
Get the Database Hostname
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.
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.
Add your Machine IP to the Whitelist
Find the IP address of your machine. Oftentimes you can just search for this online.
Add your IP to the Inbound Rules to Connect to Postgres