Feature request support MS Entra ID Authentication from On-premises PostreSQL server

From: <rs(dot)trevk(at)gmail(dot)com>
To: <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Feature request support MS Entra ID Authentication from On-premises PostreSQL server
Date: 2024-02-10 17:26:29
Message-ID: 002501da5c46$49d4cd40$dd7e67c0$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

Don't know if I got this to the right group.

Proposal Template For a New Feature

One-line Summary: Feature request Natively integration support Azure
Microsoft Entra ID for authentication from On-premises PostreSQL server.

Business Use-case: Explain the problem that you are trying to solve with the
proposal.

Using new Authentciation method (entra ID) vs Ldap method for On-Premises
PostgreSQL server databases.

User impact with the change:

Trying to stream line accounts so we only have one place for Users and
accounts, for onboarding

and offboarding and our Echo system is starting to move to Azure, but we
still have On-premises PostgresSQL servers.

Our Security groups want us to use new Authentication methods and have
integration into MS Entra ID.

I know that I can from the Azure PostgreSQL log in with Azure Entra ID with
psql.exe and pgAdmin 4 and have this working for the Azure PostgreSQl
database.

But have not found a way to do this with our On-premises PostgreSQL server
databases.

There may be a method for already doing this but I have not found it, and I
am very new to PostgreSQL.

Thanks

Trevor.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Maiquel Grassi 2024-02-10 17:38:23 RE: Psql meta-command conninfo+
Previous Message Andrew Dunstan 2024-02-10 17:24:58 Re: recently added jsonpath method change jsonb_path_query, jsonb_path_query_first immutability