AWS RDS Aurora Postgres Database Setup | Step by Step Tutorial

In this video, I show you how to setup an AWS Aurora Postgres Database in the console. I walk you through all the steps including database creation and vpc modifications to make your database accessible.
Looking to get hands on experience building on AWS with a REAL project? Check out my course - The AWS Learning Accelerator! courses.beabet...
🎉SUPPORT Daniel @ BE A BETTER DEV🎉
Become a Patron: / beabetterdev
📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚
Clean Code - amzn.to/37T7xdP
Clean Architecture - amzn.to/3sCEGCe
Head First Design Patterns - amzn.to/37WXAMy
Domain Driven Design - amzn.to/3aWSW2W
Code Complete - amzn.to/3ksQDrB
The Pragmatic Programmer - amzn.to/3uH4kaQ
Algorithms - amzn.to/3syvyP5
Working Effectively with Legacy Code - amzn.to/3kvMza7
Refactoring - amzn.to/3r6FQ8U
🎙 MY RECORDING EQUIPMENT 🎙
Shure SM58 Microphone - amzn.to/3r5Hrf9
Behringer UM2 Audio Interface - amzn.to/2MuEllM
XLR Cable - amzn.to/3uGyZFx
Acoustic Sound Absorbing Foam Panels - amzn.to/3ktIrY6
Desk Microphone Mount - amzn.to/3qXMVIO
Logitech C920s Webcam - amzn.to/303zGu9
Fujilm XS10 Camera - amzn.to/3uGa30E
Fujifilm XF 35mm F2 Lens - amzn.to/3rentPe
Neewer 2 Piece Studio Lights - amzn.to/3uyoa8p
💻 MY DESKTOP EQUIPMENT 💻
Dell 34 inch Ultrawide Monitor - amzn.to/2NJwph6
Autonomous ErgoChair 2 - bit.ly/2YzomEm
Autonomous SmartDesk 2 Standing Desk - bit.ly/2YzomEm
MX Master 3 Productivity Mouse - amzn.to/3aYwKVZ
Das Keyboard Prime 13 MX Brown Mechanical- amzn.to/3uH6VBF
Veikk A15 Drawing Tablet - amzn.to/3uBRWsN
🌎 Find me here:
Twitter - / beabetterdevv
Instagram - / beabetterdevv
Patreon - Donations help fund additional content - / beabetterdev
#AWS
#RDS
#Postgres
#Aurora

[@princemishkin1601]

This is the ONLY decent tutorial on creating and connecting to Aurora. Thank you!

[@BeABetterDev]

You're very welcome!

[@JoshPeak]

25:36-29:19 on why there is a network timeout was the least obvious thing to debug. I went straight to this channel since I was confident you would have had a screencast already covering how to do this. You are a legend. That ~4 minutes of video was critical. Thank you 🙏🏻

[@letmein985]

life-saved with all these security groups!

[@mathewkargarzadeh3158]

Excellent illustration on Postgres database creation how to connect to it!!. You made it easy to understand the process. Thank you for tine and effort for posting this. My gratitude to you !!!. Mat.

[@BeABetterDev]

You're very welcome!

[@gnupinguin]

The best tutorial for Aurora PostgreSQL setting. Thank you!

[@BeABetterDev]

Very welcome Ilja!

[@yogishankar1]

Thank you for creating this tutorial !!!

[@webdev1943]

thank you, you saved my day

[@BeABetterDev]

Glad I could help Ahmed!

[@lalithraaj3015]

Thanks a lot for this video🙂

[@BeABetterDev]

Most welcome 😊

[@joudawad1042]

Sir you just saved my day !! Thank you so much

[@hnguyen336]

As for public accessibility, can you show us what steps we have to take if we want it for production and setting public accessibility as no? Overall, great stuff! I reply on your channel when it comes to learning aws

[@BeABetterDev]

Hi H!
There are some great recommendations on this type of scenario at the following link: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.WorkingWithRDSInstanceinaVPC.html
Hope this helps!

[@Matthias53787]

That's what I came here for also. Is it a best practice to set Public=true for setup like when creating tables, and then turning it off?
Or do people run pgAdmin in an EC2? I tried this but for the life of me I can't install pgAdmin successfully 😢

[@LifeOfMohammed]

You never want the public to access your database! You should only allow internal routes and your frontend just call the API

[@thib_92]

good tutorial thanks

[@BeABetterDev]

You're welcome Thibaud!

[@mohityadav-ts4tp]

such a nice one

[@BeABetterDev]

Thank you! Cheers!

[@akhileshbangera9153]

Great video. Would like to knw.. before the database instance wala created, it was a reader instance. When you fast forwarded it was the "writer" instance. Can you please explain why?

[@jntlima]

Great video!
What is your suggestion to access the database when we have a private scenario, like a production one?

[@ohDindi]

did you find a solution to this?

[@pradeepnooney3056]

Thanks for the video

[@BeABetterDev]

You're very welcome Pradeep!

[@nikhilarora7848]

How to ensure that Aurora PostegreSql is CIS compliant?

[@jsantos1220]

Witch will be the monthly price on this db? im so confuse with that, the proxy option its like the expensive thing and i don't know if thats necessary for me.

[@sandeepsahu1716]

Hi sir, can u please help in how to do major version upgrade of postgres SQL version of Amazon rds database

[@takibahmed8859]

Sir can you explain granularity in simple words plz, Thank you

[@PrashantSingh-lj3tm]

As always great tutorial!
Would that work same for Aurora Serverless?

[@ektan000]

follow the same but why still cannot connect to the aurora postges

[@subrat12345]

Anyone working on migration of database in AWS - On premises to RDS or Aurora … I do have some doubts to clarify one on one

[@sandv2902]

Would that work same for Aurora Serverless?
Can you please help to create AWS service catalog with postgresql

[@ironF5]

it says "crypt key is missing" on my end

[@mobinalhassan]

13:50 public accessibility...

[@tiffanybonnici8003]

Great video! You are super cute!

[@Jellonova]

I can't connect to my database in pgadmin after following these steps :(

[@inkdry101]

Gotta love these AWS how to videos . AWS constantly changes their UI. Already outdated and irrelevant