Support cloud-native authentication (Managed Identities, IAM, etc.) for Postgres sources

[RTLS]

Description

Currently, connecting a Postgres source database requires using a static username/password. We’ve received requests to support cloud-native authentication mechanisms that don’t rely on static credentials.

For example:

• Azure: Managed Identities / Access Tokens
• AWS: IAM roles
• GCP: Cloud SQL IAM authentication

Current behavior

Only username/password authentication is supported for Postgres sources.

Desired behavior

Support managed identities and token-based authentication for Postgres sources across major cloud providers.

Notes

We currently support IAM roles for some AWS destinations.

This likely involves changes in connection setup and possibly leveraging underlying drivers or SDKs for each cloud provider.