PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 35 years of active development on the core platform.
Azure Active Directory (AAD) authentication in PostgreSQL Flexible Server
Microsoft Azure Active Directory (Azure AD) authentication is a mechanism of connecting to Azure Database for PostgreSQL using identities defined in Azure AD. With Azure AD authentication, you can manage database user identities and other Microsoft services in a central location, which simplifies permission management.
Today, we are proud to announce General Availability for AAD authentication feature in Azure Database for PostgreSQL - Flexible Server worldwide!
Benefits of AAD authentication in PostgreSQL Flexible Server
Benefits of using Azure AD include:
- Authentication of users across Azure Services in a uniform way
- Management of password policies and password rotation in a single place
- Multiple forms of authentication supported by Azure Active Directory, which can eliminate the need to store passwords
- Customers can manage database permissions using external (Azure AD) groups.
- Azure AD authentication uses PostgreSQL database roles to authenticate identities at the database level
- Support of token-based authentication for applications connecting to Azure Database for PostgreSQL
We invite you to learn more about data encryption in PostgreSQL - Flexible Server and Customer Managed Keys by reading following resources:
- Active Directory authentication - Azure Database for PostgreSQL - Flexible Server | Microsoft Learn
- Use Azure Active Directory for authentication with Azure Database for PostgreSQL - Flexible Server |...
- Manage Azure Active Directory Users - Azure Database for PostgreSQL - Flexible Server | Microsoft Le...
We look forward to hearing about your’ experience with this feature on Flexible server. We’re always eager to hear customer feedback, so please reach out to us at Ask Azure DB for PostgreSQL.
To learn more about our Flexible Server managed service, see the Azure Database for PostgreSQL service page.
