LDAP security connection

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

LDAP security connection

Pierre Ochsenbein-2
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


Reply | Threaded
Open this post in threaded view
|

Re: LDAP security connection

Ilya Kosmodemiansky
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
<[hidden email]> 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
>
>


Reply | Threaded
Open this post in threaded view
|

Re: LDAP security connection

Holger Jakobs-2
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 <[hidden email]>:

>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
><[hidden email]> 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 -


Reply | Threaded
Open this post in threaded view
|

Re: LDAP security connection

Pierre Ochsenbein-2
Hmm... windows? What it is? :D

PGSQL run in RHV

> Le 13 avr. 2019 à 07:13, Holger Jakobs <[hidden email]> 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 <[hidden email]>:
>> 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
>> <[hidden email]> 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 -


Reply | Threaded
Open this post in threaded view
|

Re: LDAP security connection

bricklen
In reply to this post by Pierre Ochsenbein-2

On Fri, Apr 12, 2019 at 12:58 AM Pierre Ochsenbein <[hidden email]> wrote:
I would like to create a connection security to PostgreSQL from Active Directory with auth LDAP.
Have you some recommendation for make this steps?

Stephen Frost wrote a blog post recently about using Active Directory with Postgres, which may be useful to you:
Reply | Threaded
Open this post in threaded view
|

Re: LDAP security connection

Shreeyansh dba
In reply to this post by Pierre Ochsenbein-2
Hi Pierre,

Go through below link hope this will help you.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Apr 12, 2019 at 1:28 PM Pierre Ochsenbein <[hidden email]> 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