Provisioning and Automating High Availability Postgres on AWS EC2
DBA at OmniTI on all things Postgres right from installation to automation. Doctoral student pursuing research in information processing at UMBC.
RDS is great. But sometimes you feel the need for more flexibility and customization that is just not possible with RDS. In this talk I will talk about why one might want to go with setting up and maintaining a HA postgres cluster on EC2 instead of RDS, following which I will go through each of the steps for setting up such a system and automating installation and upgrades, replication, backups and restores with S3, PITR, monitoring with Cloudwatch and failover. This talk is especially useful for people looking to gain a better understanding of how the various AWS tools can be used together for a HA postgres cluster, and as a HowTo guide on migrating from either RDS or one's own hosted cluster on to EC2.
- 50 min
- PGConf US 2017