Zero-Downtime Migration Plan: PostgreSQL 11 (On-Prem) → RDS PostgreSQL 14
1. Overview
2. High-Level Migration Phases
Phase 1 — Target Preparation (RDS)
Phase 2 — Source Preparation (PG11)
Phase 3 — Application Layer Preparation
Phase 4 — Initial Full Snapshot
Phase 5 — Restore Snapshot into RDS
Phase 6 — Start Logical Replication
Phase 7 — Pre-Cutover Validation
Phase 8 — Zero-Downtime Cutover via ProxySQL
Phase 9 — Stabilization and Cleanup
3. Key Characteristics of This Approach
4. Responsibilities Breakdown
5. Expected Outcomes
6. Notes