3.2 — Configure Azure Database for PostgreSQL

[davidortinau]

Description

Replace the emulated PostgreSQL with Azure Database for PostgreSQL Flexible Server. The AppHost already declares PostgreSQL; this work configures it for Azure provisioning and ensures EF Core migrations run on deployment.

Dependencies

• Depends on 3.1 — Create azure.yaml manifest for Aspire deployment #48 (Create azure.yaml)

Acceptance Criteria

• AppHost updated: .PublishAsAzurePostgresFlexibleServer() on postgres resource
• Connection string uses managed identity (no password in config)
• EF Core migrations run automatically on deployment
• Database backup policy configured
• Connection pooling optimized for Azure
• Tested locally with emulator first, then preview with azd
• Staging and production databases provisioned successfully

Technical Notes

• Aspire generates Bicep for Azure PostgreSQL Flexible Server
• Managed Identity for authentication (no credentials needed)
• Migration bundle or init container approach for schema updates
• Monitor performance after Azure deployment

---

Phase: 3 | Size: XL | Owner: Zoe (Lead)

[davidortinau]

Closing — PostgreSQL with persistent storage configured in AppHost.cs.