Re: LDAP security connection - Mailing list pgsql-admin

From Pierre Ochsenbein
Subject Re: LDAP security connection
Date
Msg-id CA2A7A0A-1A19-43A2-9627-8CA1EA2DE493@gmail.com
Whole thread Raw
In response to Re: LDAP security connection  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Hmm... windows? What it is? :D

PGSQL run in RHV

> Le 13 avr. 2019 à 07:13, Holger Jakobs <holger@jakobs.com> a écrit :
>
> If you run PostgreSQL on Windows (don't know whether and how it works on other OS), writing sspi instead of md5 in
pg_hba.confis sufficient to connect it to Active Directory. 
>
> Add a pg_ident file to match PG users with AD users an you are done.
>
> Regards,
> Holger
>
> Am 12. April 2019 10:17:52 MESZ schrieb Ilya Kosmodemiansky <hydrobiont@gmail.com>:
>> Hi Pierre
>>
>> in general, there is nothing too complicated -
>> https://www.postgresql.org/docs/11/auth-ldap.html because LDAP is just
>> an authentication method.
>>
>> Details could be more tricky, but for that more details on your
>> requirements needed - do you use pgbouncer, do you need to sync roles
>> from AD etc.
>>
>> best regards,
>> Ilya
>>
>> On Fri, Apr 12, 2019 at 9:58 AM Pierre Ochsenbein
>> <pierreochsenbein@gmail.com> wrote:
>>>
>>> Dear community
>>>
>>> I would like to create a connection security to PostgreSQL from
>> Active Directory with auth LDAP.
>>> Have you some recommendation for make this steps?
>>>
>>> Have a great Friday
>>>
>>>
>
> --
> Holger Jakobs, Bergisch Gladbach
> +49 178 9759012
> - sent from mobile, therefore short -



pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: LDAP security connection
Next
From: Nithin Johnson
Date:
Subject: SELECT query fails after pg_upgrade as the conditional operator fails