HA and DR at a glance with Azure Database for PostgreSQL
summary
Demonstrates Azure Database for PostgreSQL configuring zone-redundant HA with synchronous local replication (near-zero RPO) and asynchronous multi-region DR via read replicas, showing a scripted Azure CLI + Bicep deployment, Entra ID auth, a Python app and Azure Data Studio demos. Forced local failover yields ~30 seconds of application downtime; geo failover and failback work with brief connection interruption. Shows Virtual Endpoints, read replicas with Promote to Primary, and geo‑redundant backups.
AI-written summary · about
chapters (9)
- 0:00Intro
- 0:38Fundamental problem
- 1:05Two key metrics: RTO & RPO
- 2:19HA vs. DR vs. Backups
- 4:24Business continuity in Azure
- 7:28Flexible Server Architecture
- 9:08Demo 1: Zone redundant HA
- 18:18Demo 2: Multi-region DR
- 26:00Geo redundant backups
related talks
47mPerfecting business continuity for Azure SQL DB
50mUnleashing the Power of Azure for PostgreSQL
09mMulti-Region Replication & DR for Distributed Postgres in Azure Cosmos DB
46mAzure SQL Database Business Continuity During Disaster
54mDesigning Azure Data Disaster Recovery Strategies
01h 01mAzure SQL Database-Business Continuity During Disaster
19mWhy we built Azure HorizonDB for PostgreSQL
49mEverything you always wanted to know about HA/DR for SQL Server on Azure VMs but were afraid to ask