How to Set Up a Postgres Database on Amazon RDS

Подписаться 54 тыс.

Просмотров 22 тыс.

50% 1

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
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.amazon.com - the login page for Amazon AWS

Наука

Опубликовано:

7 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 44

@njabulo5791 3 месяца назад

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

@DatabaseStar 3 месяца назад

Glad you liked it!

@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!

@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!

@Raul-si7bn 9 месяцев назад

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 9 месяцев назад

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

@loganbaxter7342 Год назад

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

@DatabaseStar Год назад

Glad it was helpful!

@kostiantynkarzhanov9216 2 месяца назад

Very good demonstration! Thank you so much! 💛

@DatabaseStar 2 месяца назад

Thanks!

@Nico-yy6qn Год назад

Excellent content!

@DatabaseStar Год назад

Glad you think so!

@a354681 Год назад

Thank you sir.

@DatabaseStar Год назад

You’re welcome!

@ivanivanivanivan1592 Год назад

excellent content, thank u

@DatabaseStar Год назад

Glad you like it!

@zeusamorim9531 8 месяцев назад

Great video. Thanks for it, helped a lot

@DatabaseStar 8 месяцев назад

Glad it helped!

@rubenoganesyan1669 Год назад

Thank you!

@DatabaseStar Год назад

You're welcome!

@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?

@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.

@adrianrobertoaguilarsandic6999 Месяц назад

Excelent explanation, thanks and congratulations!

@DatabaseStar Месяц назад

Thanks!

@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.

@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 11 месяцев назад

@@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.