Running Highly Available Postgres in AWS RDS
summary
Migration to AWS RDS for Postgres focuses on operational specifics: choose engine version (9.3–9.6), pick instance class for CPU/RAM, and pick storage general SSD or provisioned IOPS with up to 30,000 IOPS. RDS builds multi-AZ synchronous storage replication for automatic failover, does snapshot + incrementals for backups and archived WALs for point‑in‑time recovery, exposes parameter groups and CloudWatch monitoring, and restores to a new instance only — no live table-level restore and no host access.
AI-written summary · about
chapters (9)
- 0:00Introduction and motivation
- 1:32Historical database challenges
- 5:22Configuring an RDS instance
- 10:00Multi-AZ and network security
- 14:25Backup, monitoring and recovery
- 22:42Replicas and alerts
- 28:14Operational benefits
- 30:38Open source vs. proprietary
- 37:13Q&A and compliance
related talks
53mPostgres in Amazon RDS
18mPostgreSQL at Amazon
49mDeploying Highly Available, Durable Amazon RDS for PostgreSQL and for MySQL Databases
19mPostgreSQL at Amazon
40mPushing past PostgreSQL’s vertical scaling limits - Running Amazon RDS
14mBuilding a better PostgreSQL together
10mPostgres on AWS: Run 5X faster on metal, migrate anywhere
54mBreakout Session