Deploy PostgreSQL on AWS with Terraform – Amazon RDS vs. Amazon Aurora
#PostgreSQL #AWS #Terraform #Aurora #CloudDatabases #InfrastructureAsCode
Deploy PostgreSQL on AWS with Terraform – Amazon RDS vs. Amazon Aurora
In this video, we walk through deploying PostgreSQL on AWS using fully managed Platform as a Service offerings. You’ll learn how to set up Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition step by step with Terraform.
What You’ll Learn:
The key differences between RDS PostgreSQL and Aurora PostgreSQL
How to provision infrastructure using Terraform
Best practices for security, scaling, and high availability
Loading the Pagila sample database for realistic testing
Connecting with psql and pgAdmin to explore your data
Resources Deployed:
Custom VPC, subnets, and routing
Security groups for controlled access
RDS PostgreSQL instance with a read replica
Aurora cluster with writer and reader instances
AWS Secrets Manager credentials with random passwords
---
GitHub: https://github.com/mamonaco1973/aws-p...
README: https://github.com/mamonaco1973/aws-p...
---
00:00 Introduction
02:16 AWS Diagram
03:05 RDS vs Aurora
07:28 Prerequisites
08:22 Build the Code
09:16 Build Results
16:16 Demo