How to Set Up a Postgres Database on Amazon RDS

Amazon allows you to create a cloud-hosted database using its RDS (Relational Database Service). You can create a Postgres database on it, and use the database in Amazon’s “free tier”, which is helpful for small projects you may want to work on.

In this video, you’ll learn how to navigate to Amazon RDS, create a new Postgres database in the free tier, set up the security groups to allow connections, and connect to the database using an IDE on your computer.

Timestamps:
00:00 What you’ll need
00:27 Navigate AWS
01:46 Creating your new database
04:39 Connect to the database
06:17 Security group setup
08:14 Retry connection
09:15 Delete database from RDS

Links:

[njabulo]

This was lovely. Clear and concise step by step. Thank you!

[kostiantynkarzhanov]

Very good demonstration! Thank you so much! 💛

[Raul-sibn]

you are the only one I found solving the timeout problem. It worked like a charm!!
(although I still do not get why was happening. In my case it was created by default a kind of "accept all" rule, for every kind of inbound connection)
thanks a lot!

[sharqi_music]

Thank you so much man, we were stuck with that timeout error, after watching your video we fixed the error.😀😀

[backiarajirudayaraj]

Excellent video, faced issue due to sec setting, after adding inbound rule as explained in this video, it solved the issue, thanks a bunch

[loganbaxter]

Great video, very well explained and very easy to follow!

[zeusamorim]

Great video. Thanks for it, helped a lot

[arunbhati]

Hi Ben,
Great content, Thanks for sharing.

Can you please make a video on table history for audit logs in postgres?

[christophersalazar]

I couldnt connect due to the security group thank you!

[adrianrobertoaguilarsandic]

Excelent explanation, thanks and congratulations!

Thank you sir. I understand if 1 year is free. Is there any registration number limit?

[jason]

I have an app built with PERN stack and created seed data using Sequelize. Is there a way to migrate the seed data from my backend to the RDS database with pgAdmin or DBeaver? Or do I have to manually create my tables and add my data into the database?

[fwjjdvc]

hey thanks for your amazing video when I connect I get this error no pg_hba.conf entry for host "(ip-address)", user "postgres", database "postgres" aws rds no encryption

[muhammadfarhanagustrisasti]

Hai,
I want to know how to set up PostgreSQL in dbeaver, please...

[homokir]

Thank you! Solve timeout error with information that you gave in video.