Re: LDAP security connection

From: Pierre Ochsenbein <pierreochsenbein(at)gmail(dot)com>
To: Holger Jakobs <holger(at)jakobs(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org, Ilya Kosmodemiansky <hydrobiont(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: LDAP security connection
Date: 2019-04-13 07:02:23
Message-ID: CA2A7A0A-1A19-43A2-9627-8CA1EA2DE493@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hmm... windows? What it is? :D

PGSQL run in RHV

> Le 13 avr. 2019 à 07:13, Holger Jakobs <holger(at)jakobs(dot)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.conf is 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(at)gmail(dot)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(at)gmail(dot)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 -

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nithin Johnson 2019-04-13 07:33:34 SELECT query fails after pg_upgrade as the conditional operator fails
Previous Message Holger Jakobs 2019-04-13 05:13:25 Re: LDAP security connection