Connecting PostgreSQL to AWS RDS

What is AWS RDS?

Amazon Relation Database Services is relational database service by AWS. You can think of it as virtual server that allows you to store your database and connect to database engines such as Amazon Aurora, MySQL, MariaDB, Oracle, Microsoft SQL Server, and PostgreSQL.

For the current project I am working on, I used PostgreSQL as my database engine. In order to connect it to AWS, I followed the following tutorial from amazon: https://aws.amazon.com/getting-started/tutorials/create-connect-postgresql-db/

Additionally I also watched some youtube videos on the topic. I found that most of the videos do not tell you to change your VPC security group, which is very crucial for the connection. You need to add a rule to the inbound to allow RDS to connect to PostgreSQL, otherwise it will not work!

comments powered by Disqus