no instructions on how to enable pgaadauth_* functions

[dhduvall]

This page suggests using several functions whose names begin with pgaadauth_. When I try to use them, I get errors like

ERROR:  function pgaadauth_list_principals(boolean) does not exist

When I type \df in psql, the list of functions doesn't show any like this. I thought perhaps there was a server extension I needed to enable, but in the list of available extensions (az postgres flexible-server parameter show -n azure.extensions -o tsv --query allowedValues), none have a name containing ad, active, or dir. I'm not sure what else to try from here.

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: c454ed0e-944b-2933-ff30-5969ff0de1c9
• Version Independent ID: 6f69997e-b534-e573-154d-7116e189d3c9
• Content: Manage Azure Active Directory Users - Azure Database for PostgreSQL - Flexible Server
• Content Source: articles/postgresql/flexible-server/how-to-manage-azure-ad-users.md
• Service: postgresql
• Sub-service: flexible-server
• GitHub Login: @achudnovskij
• Microsoft Alias: anchudno

[ManoharLakkoju-MSFT]

@dhduvall Thanks for your feedback! We will investigate and update as appropriate.

[shaktisingh-msft]

Hi @achudnovskij,

Could you please look into this document request. Thanks

[achudnovskij]

Hi @dhduvall . Those functions are part of "pgaadauth" extension installed on "postgres" database once you enable Azure AD authentication on a Flexible Server. If you enabled the Azure AD authentication and still don't see the functions, please open a support ticket.

[dhduvall]

Thank you; I've done just that.

[GennadNY]

@dhduvall - can we close this?

[dhduvall]

Not yet; we're making progress in the support ticket, but there are still a couple of unanswered questions, and I think changes will need to be made to this page as a result. If you'd rather have that as a separate ticket, though, that's up to you.

[dhduvall]

The support ticket ID is 2211230010002257. I have everything I need, so I'll let you work it out on your end what needs to be closed and how.

[kabharati]

Closing this PR as support ticket 2211230010002257 to track the issue. Please feel free to reopen the PR if you need any other info.

[kabharati]

#please-close

[CristianAtMaersk]

Hi @dhduvall . Those functions are part of "pgaadauth" extension installed on "postgres" database once you enable Azure AD authentication on a Flexible Server. If you enabled the Azure AD authentication and still don't see the functions, please open a support ticket.

Hi @achudnovskij , I have provisioned a postgres DB through terraform with: authentication { active_directory_auth_enabled = true ... } But I don't see the extension installed on the database. Does the installation happen only when enabling through the Azure Portal?

Where can I open a support ticket for this?

[nikoliano]

Hi All, is there a resolution to this? I am also having this problem.

[umeshpawar2188]

facing same, any update on this