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 Availabilityfor 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: