Re: integrate Postgres Users Authentication with our own LDAP Server

On 9/5/19 7:51 π.μ., M Tarkeshwar Rao wrote:
>
> Hi all,
>
> We would need to integrate Postgres Users Authentication with our own LDAP Server.
>
> Basically as of now we are able to login to Postgress DB with a user/password credential.
>
> These user objects are the part of Postgres DB server. Now we want that these users should be authenticated by LDAP server.
>
> We would want the authentication to be done with LDAP, so basically the user credentials should be store in LDAP server
>
> Can you mention the prescribed steps in Postgres needed for this integration with LDAP Server?
>
The users must be existent as postgresql users. Authorization : roles, privileges etc also will be taken by postgresql definitions, grants, etc. But the authentication will be done in LDAP.
It is done in pg_hba.conf. There are two ways to do this (with 1 or 2 phases). We have successfully used both Lotus Notes LDAP and FreeIPA LDAP with our production PostgreSQL servers, I have tested
with openldap as well, so I guess chances are that it will work with yours.
>
> Regards
>
> Tarkeshwar
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt