Proposal

The Postgres scaler only supports basic authentication through username and password, but it is now possible to authenticate to a Postgres server hosted in the cloud by using "access token".

The purpose of this issue is to add support to enable access token authentication within the Postgres scaler by extending it, possibly with additional parameters.

Use-Case

In Azure, a managed identity does not have a password associated to it, but can obtain short-lived credentials (called access tokens) to connect to certain resources. It is possible for an Azure managed identity to connect to an Azure Postgres Flexible server.

Is this a feature you are interested in implementing yourself?

Yes

Anything else?

I created this PR: #5589. I tested it in my own Azure subscription to see if it works with my own use case (related to Apache Airflow) and it worked.