How to Set Up a Postgres Database on Amazon RDS

📝 Get my free SQL Cheat Sheets: www.databasest...
🎓 Learn and become confident in SQL: databasestar.m...
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:
console.aws.am... - the login page for Amazon AWS

[@njabulo5791]

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

[@DatabaseStar]

Glad you liked it!

[@kostiantynkarzhanov9216]

Very good demonstration! Thank you so much! 💛

[@DatabaseStar]

Thanks!

[@Raul-si7bn]

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!

[@DatabaseStar]

Thanks! Glad to hear this video helped solve the timeout issue for you.

[@backiarajirudayaraj7076]

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

[@DatabaseStar]

Thanks, glad it helped!

[@sharqi_music]

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

[@DatabaseStar]

Good to hear it was helpful!

[@loganbaxter7342]

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

[@DatabaseStar]

Glad it was helpful!

[@victoria.magnus]

Thanks for posting!

[@DatabaseStar]

You're welcome!

[@Nico-yy6qn]

Excellent content!

[@DatabaseStar]

Glad you think so!

[@zeusamorim9531]

Great video. Thanks for it, helped a lot

[@DatabaseStar]

Glad it helped!

[@christophersalazar6984]

I couldnt connect due to the security group thank you!

[@DatabaseStar]

Glad it helped!

[@a354681]

Thank you sir.

[@DatabaseStar]

You’re welcome!

[@ivanivanivanivan1592]

excellent content, thank u

[@DatabaseStar]

Glad you like it!

[@adrianrobertoaguilarsandic6999]

Excelent explanation, thanks and congratulations!

[@DatabaseStar]

Thanks!

[@arunbhati101]

Hi Ben,
Great content, Thanks for sharing.
Can you please make a video on table history for audit logs in postgres?

[@DatabaseStar]

Thanks! What do you mean by "table history for audit logs in postgres"? Do you mean a table that captures an audit log of changes made to your data? Or is there some setting or feature in Postgres that this relates to?

[@rubenoganesyan1669]

Thank you!

[@DatabaseStar]

You're welcome!

[@homokir]

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

[@DatabaseStar]

Glad it helped!

[@jason9468]

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?

[@DatabaseStar]

You can probably use either pgAdmin or DBeaver to perform an export of the data and tables into one or more SQL scripts, and then run those scripts onto the RDS database. This means you would export the tables you want to migrate, and ensure it includes both the "create table" command to create the table and the "insert" command to add the data. This would generate a SQL file, which can then be opened inside either pgAdmin or DBeaver, and can be run on the RDS database.

[@jason9468]

@@DatabaseStar thanks for the reply! I was able to use the Sequelize commands `sequelize db:migrate` and `sequelize db:seed:all`. I just set up my config.js file to target the Postgres database hosted on the AWS RDS instance, and running the commands updated my deployed database with the seed data like it would have with a local database

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

[@DatabaseStar]

No problem! I'm not sure, you'll have to check on the RDS website to find that information.

[@user-fw6jj8dv1c]

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

[@DatabaseStar]

You’re welcome! That error is not something I know how to fix, unfortunately

[@Victor_fTav]

did you fix that? same error here.

[@user-fw6jj8dv1c]

@@Victor_fTav Yeah, I totally forgot I asked this questions. It's been a while since I went on AWS. I think you have to finding something along the line of incoming rules(can't remember the details and add something like, postgres Ipv4).
PS: if I saw the console I should know what to do.

[@requizm]

1. Create a new group on Parameter Groups
2. Change rds.force_ssl to 0
3. Modify your database, select new group that you created
4. Reboot database

[@muhammadfarhanagustrisasti588]

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

[@DatabaseStar]

Hey, PostgreSQL is the database and DBeaver is a tool used to access the database. You can use DBeaver as shown in this video, or you can install Postgres on your own computer (instead of using Amazon RDS) and use DBeaver to access it.

[@terrasystemlabs]

can i make it public later? (3:29)

[@DatabaseStar]

I assume you can

[@saoudahmedkhan2549]

Great

[@DatabaseStar]

Thanks!