RDS Postgres with Read Replica

RDS Postgres with Read Replica

A complete CloudFormation template for production-grade Postgres on RDS. Multi-AZ primary, a read replica, automated backups, enhanced monitoring via Performance Insights, connection strings stored in Parameter Store, and automatic credential rotation with Secrets Manager — all wired together and ready to deploy.

What's Included

• Multi-AZ RDS Instance — automatic failover to a standby in a different AZ
• Read Replica — offload read traffic with a replica in the same or different AZ
• Automated Backups — configurable retention window, point-in-time recovery enabled
• Performance Insights — enhanced monitoring at 60-second granularity
• Parameter Store — host, port, and database name stored as SecureString parameters
• Secrets Manager Rotation — Lambda-backed automatic credential rotation on a configurable schedule

What You Get

• rds-postgres.yml — single CloudFormation template with all resources and outputs
• parameters.json — example parameters file for CLI deployments
• README.md — deploy instructions, parameter reference, and post-deploy checklist

How to Deploy

• Fill in parameters.json with your VPC, subnet IDs, and instance class
• Run aws cloudformation deploy --template-file rds-postgres.yml --parameter-overrides file://parameters.json
• Connection strings are output to Parameter Store under the prefix you specify

Requirements

AWS CLI configured, an existing VPC with private subnets in at least two AZs, and an IAM role with permissions to create RDS, SSM, and Secrets Manager resources.