There are many instructions on how to connect to PostgreSQL on Amazon Web Services but no one mentions one important point.
When you try to connect to AWS you get errors like this:
MySQL said: Can’t connect to MySQL server on … amazonaws.com
Unable to connect to hostamazonaws.com, or the request timed out.
This is due to lack of access rights. You need to change VPC Security groups:
Click on it and you will go to next page:
Then you need change inbound and outbound rules:
Choose “anywhere” or your ip address. Now try connecting to your PostgreSQL database again!