Add Entra Admins to PostgreSQL Flexible Server?

Question

Add Entra Admins to PostgreSQL Flexible Server?

Opened this issue 4 months ago · 4 comments

We use Workload Identities (managed identity, essentially) to connect our apps to PostgreSQL Flexible Server. Is there a way to add Entra admins to the server? Essentially, the equivalent of terraform's azurerm_postgresql_flexible_server_active_directory_administrator. I saw User but that seems to be for SQL auth users, not Entra identities.

Answer 1 · 2024-09-16T23:23:50.000Z

I thought that there was but now that I'm looking I don't see it. We'll take a look at adding this

Answer 2 · 2024-09-17T17:53:33.000Z

Awesome, thanks! Looking forward to it. We've been doing some prototyping with this to see if we can switch parts of our enterprise to a new deployment model (Azure Service Operator v2 + CDK8s) and bundling our infrastructure artifacts as an OCI artifact using ORAS (stored in ACR, deployed along with our microservices via ArgoCD), and so far it's all looking very promising.

Answer 3 · 2024-10-08T21:56:35.000Z

Moving this to 2.11 as I don't have time to finish it in 2.10.

Answer 4 · 2024-10-08T21:58:14.000Z

Thank you for the update!