Thread: Re: PostgreSQL 12 Authentication type questions.

Re: PostgreSQL 12 Authentication type questions.

From
Anitha P
Date:

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 at a same time (like authentication type as password, global in oracle), 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 separately but not at the same time for different users.. 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 in Microsoft SQL server(same user with authentication type which is password as well as ldap), Is it possible?
 
Is it bug or there is a workaround? Please confirm.

Appreciate your quick response.

You can contact me @+919500114519 or +13132026377

Regards,
Anitha P.

Re: PostgreSQL 12 Authentication type questions.

From
Jeff Janes
Date:
On Fri, Oct 8, 2021 at 3:54 AM Anitha P <85anitha@gmail.com> wrote:

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 at a same time (like authentication type as password, global in oracle), 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 separately but not at the same time for different users..

Yes, you can have different methods at the same time for different users.  pg_hba has a user column for this purpose.  It is entirely unclear what specifically you tried, and what about it didn't work.  This is much too vague to be a valid bug report.

Cheers,

Jeff