Migration Checklist: provisioned Aurora PostgreSQL DB to Serverless Aurora PostgreSQL DB

🔧 1. Database Creation

• Choose Standard Create under database creation method
• Select Engine Type: Aurora (PostgreSQL-Compatible)
• Set Engine Version: Aurora PostgreSQL (Compatible with PostgreSQL 16.4)
• Choose Template: Dev/Test

---

⚙️ 2. Settings

• DB Cluster Identifier: postgres-serverlessV2-stage
• Master Username: postgres
• Credentials Management: Self-managed
• Enable Auto-generated password

---

🧠 3. Aurora Limitless Database

• Leave settings as default (No changes needed)

---

💾 4. Cluster Storage Configuration

• Select: Aurora Standard

---

🧮 5. Instance Configuration

• DB Instance Class: Serverless v2
• Capacity Range: 0.5 GiB to 8 GiB

---

🌐 6. Connectivity

• Do not connect to an EC2 compute resource
• Network Type: IPv4
• VPC: Use existing VPC from old staging DB
• DB Subnet Group: Use same subnet group as old staging DB
• Public Access: No
• Security Groups: Use same as old staging DB
• Availability Zone: Match old staging DB’s AZ
• RDS Proxy: Do not enable

---

📡 7. Additional Connectivity Configuration

• Database Port: 5432

---

🏷️ 8. Tags

• No tags required for now

---

📈 9. Monitoring

• Enable Database Insights (Standard)
• Enable Performance Insights
• Retention Period: 7 days (Free tier)

---

🛠️ 10. Additional Configuration

• Initial Database Name: stage_serverless_db
• DB Cluster Parameter Group: default.aurora-postgresql16
• DB Parameter Group: default.aurora-postgresql16