Azure AD authentication with PostgreSQL Flexible Servers | Citus Con: An Event for Postgres 2023

In this video of Azure AD expert Andrey Chudnovskiy’s talk at Citus Con: An Event for Postgres, learn about the security benefits of Azure AD authentication compared to password-based methods. This talk covers the process of managing PostgreSQL roles in the Azure Database for PostgreSQL managed service—for Azure AD Users, Groups, and Applications, as well as the process of obtaining tokens and connecting to PostgreSQL in different environments.

Andrey explains how Azure AD authentication works in Flexible Server in Azure Database for PostgreSQL—plus how to use Azure AD to provide a secure and convenient way to authenticate users/applications connecting to PostgreSQL databases.

Andrey Chudnovskiy is a Principal Software Engineering Manager @Microsoft leading Azure AD integration for the Postgres managed service on Azure, Azure Database for PostgreSQL, with a specific focus on the Flexible Server option. Andrey joined the PostgreSQL database world 3 years ago, after a decade of experience building applications and systems at both Microsoft and Google.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 02:12 What is Azure AD & how does it work with Flexible Server?
⏩ 06:45 Connect to Azure AD with Flexible Server
⏩ 12:37 Connect as Application & Impersonate as User
⏩ 20:02 Use Azure AD Groups & Advanced roles

✅ Learn more:

📌 Let’s connect:  

More resources:

#CitusCon #PostgreSQL #Azure

[sfpfims]

How can we increase the azure ad access token time, which is currently 5 minutes to 60 minutes.
I want to increase it to 10hrs.
How can I achieve it?

[BoYcLuE]

What frustrates me about these types of videos that "Help covers processes" is the content is covered like you would you would explain a theory. What is mean is, how difficult would it really had been to show a demo as you are describing the technical nuances?