Zero Downtime Postgres Migration to AWS RDS

In this video, I'll show you how to execute a zero-downtime migration to AWS RDS using native PostgreSQL logical replication and a secure Site-to-Site VPN tunnel.

Project Source Code: https://github.com/JoeyAlpha5/postgres-on-prem-aws-cloud-migration

🚀 Level up your Cloud Security with Sunbird Insyte:
Make sure your network architecture is fully compliant before moving massive datasets to the cloud. Sunbird Insyte continuously monitors your AWS infrastructure and automatically flags risky configurations like exposed VPC endpoints. https://www.sunbirdanalytics.com/insyte/index.html

💻 My IDE of Choice: JetBrains
Get a 25% discount on Personal JetBrains licenses using the code BornToCode_YT at checkout:
https://www.jetbrains.com/store/?§ion=personal&billing=yearly

Timestamps:
0:00 - The "Zero Downtime" Migration Strategy
0:21 - The On-Premise Setup (Local Postgres & Live Traffic)
0:45 - Creating the Secure AWS VPN Tunnel
1:07 - Connecting pgAdmin to the AWS RDS Instance
1:50 - Exporting and Importing the Database Schema
2:36 - Step 1: Setting up the Local Publisher
3:09 - Step 2: Setting up the AWS Subscriber
3:45 - The CRITICAL Sequence Reset

Видео Zero Downtime Postgres Migration to AWS RDS канала Born To Code