PostgreSQL 12 Authentication type questions.

Hello Postgresql Team,

I have a question for you.

If we would like to implement ldap authentication as well as password authentication for some users, Is there any option with postgresql 12? I did tested password authentication and as well as ldap authentication users separately by touching pg_hba.conf file, it works.

But If i want to use two different users , one user with ldap authentication and another user with password authentication like in Oracle. Is it possible ? Please advise.

Also please confirm same user with mixed mode authentication like Microsoft SQL server, Is it possible?

Appreciate your quick response.

I think, you need pam-support.

Greetings
Uwe