Highly Available PostgreSQL Database Cluster Creation & Monitoring in Minutes
summary
Demo deploys a PostgreSQL cluster with EnterpriseDB using Terraform + Ansible, provisioning a 3-node cluster (1 master, 2 replicas) on AWS in minutes from a public GitHub repo. EFM agents provide EFM auto-failover and PEM collects metrics from agents for alerts and dashboards. Demo shows replication in sync, automatic promotion on failure, and online expansion to add replicas; versions 10–12 and AWS/vSphere providers are supported.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 3:23About EnterpriseDB
- 5:25Deployment Options
- 8:23Use Cases
- 13:07Use Case 1 High Availability
- 15:40Use Case 2 Fault Tolerance
- 18:16Use Case 3 Monitoring
- 19:47Demo
- 27:07Monitoring
- 33:57Summary
related talks
44mEfficiently Deploying PostgreSQL Instances: The Evolution
38mDeploying Database Clusters in the Cloud
49mDeploying Highly Available, Durable Amazon RDS for PostgreSQL and for MySQL Databases
55mHigh Availability with PostgreSQL and Pacemaker
41mPostgres Plus Cloud Database
46mBig databases, many servers, data center or cloud - it's all here!
35mBuilding a Production Grade PostgreSQL Cloud Foundry Service
50mEvolution Of PostgreSQL Replication and High Availability (upto ~ 99.999%)