Presented by:

0d2d9af879fc8a60a29f6d77145637b0

Payal Singh

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.

Date:
2017 March 31 09:00
Duration:
50 min
Room:
America
Conference:
PGConf US 2017
Language:
English
Track:
Operations
Difficulty:
Medium