An Azure managed PostgreSQL database service for app development and deployment.
Hi @Dutsadi Bunliang - welcome to the Microsoft Azure QnA.
Adding the specific documentation behind each of the points already raised here.
pg_oidc_validator is not available. It does not appear on the list of extensions Flexible Server supports, so setting the parameter does not install it.
pg_hba.conf is not editable. From Server parameters: “Because Azure Database for PostgreSQL is a managed database service, you don’t have host or operating system access to view or modify configuration files such as postgresql.conf.” pg_hba does not appear anywhere on that page, so there is no parameter for it either.
The supported methods are a closed list, not just an absence of documentation. From Microsoft Entra authentication: “Azure Database for PostgreSQL supports three modes of authentication: PostgreSQL authentication only, Microsoft Entra authentication only, and both PostgreSQL and Microsoft Entra authentication.” An OIDC provider outside Entra is not among them.
So for your users who are not in Entra ID, that leaves local PostgreSQL usernames and passwords, or representing those users in your Entra tenant. Since the supported set is enumerated, I would not plan around an external issuer arriving.
If this helps resolve your question, please accept the answer or leave an upvote. If not, share more details in a comment so we can continue the discussion and find the right solution.