Postgres supports LDAP with config (pg_hba.conf). That config is not exposed on RDS.
With RDS, you can enable IAM authentication. This uses IAM for authentication. You must enable the feature on your RDS instance, create an IAM user / policy, and finally grant rds_iam to the database user. Users with iam authentication have to call "aws rds generate-db-auth-token" vs and use the response as their password when connecting.
It might be possible to further mix solutions or automate things on AWS, but, those are the building blocks.
There's a link with all the supported RDS Postgres extensions below.
References:
References:
* https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html
Best regards,
Best regards,
Dan Smith
On Tue, Mar 28, 2023, 01:01 Mukesh Rajpurohit <vivasvan1902@xxxxxxxxx> wrote:
Hi All,We are migrating pl/sql code from Oracle to PostgreSQL. We have the package DBMS_LDAP in oracle pl/sql code and need to migrate it to PostgreSQL pl/pgsql. Please let me know if DBMS_LDAP equivalent code/ utility is available in PostgreSQL also.My second related question is regarding ldap. Do we have any open source ldap equivalent extension/ utility in PostgreSQL which is supported in AWS RDS for PostgreSQLtoo? I can use AWS IAM for this purpose but I am looking for some extension/ open source utility for ldap etc which suffice this purpose.Thanks in advance.ThanksMukesh
