Seamless Migration to Azure Database for PostgreSQL
summary
Step‑by‑step migration process with concrete tools: use Azure Database Migration Service for online minimal‑downtime moves or PG dump/pg_restore and pg_dump/pg_restore/pg_admin for offline transfers, integrate pgBouncer for connection pooling, and use Azure Arc when running Postgres outside Azure. Flexible Server supports elastic compute (scale compute in ~20 seconds) and online storage scaling, zone‑redundant HA with zero RPO, reserved capacity that can save up to 60%, and advanced features like vector search with embeddings for semantic queries.
AI-written summary · about
chapters (19)
- 0:00Seamless PostgreSQL migration
- 1:24Migration planning and assessment
- 8:40Azure PostgreSQL service options
- 15:37Why migrate to flexible server
- 19:20Compute tiers and cost optimization
- 21:52Elastic compute and storage scalability
- 24:17Extensions and customization
- 25:20Monitoring and performance
- 26:25Azure Advisor recommendations
- 27:51Enterprise security features
- 31:24Data encryption and compliance
- 32:53High availability and recovery
- 35:26AI and vector search
- 41:39Embedding data with Azure OpenAI
- 45:59Migration steps and tools
- 46:42Schema migration tools
- 50:18Built-in migration demo
- 51:00Connection pooling with PG Bouncer
- 52:10Q&A on SQL migration
related talks
26mWhat Enterprises like about Azure Database for PostgreSQL - Flexible Server
25mWhat’s New with Azure Database for PostgreSQL- Flexible Server
32mWhat makes Azure Database for PostgreSQL Great for Developers?
50mUnleashing the Power of Azure for PostgreSQL
31mBuild scalable and secure enterprise apps on OSS databases Q&A
34mData modeling for those who want to save time and money!
57mDeveloping powerful and intelligent apps using the Azure managed PostgreSQL service
24mMigrating from Oracle to Azure Database for PostgreSQL, Seamlessly