LDAP: Auto user creation and role membership - Mailing list pgsql-general

From Daniel Scott
Subject LDAP: Auto user creation and role membership
Date
Msg-id s2j6835906b1005051349q7e8b9fcevcb882816ea0c3c04@mail.gmail.com
Whole thread Raw
Responses Re: LDAP: Auto user creation and role membership
List pgsql-general
Hi,

I have Postgres 8.4.3 running with gss authentication against Fedora's
FreeIPA (Integrated Kerberos, LDAP and some other services).

I would like to auto-create users and auto-map postgres roles with
users and groups within the FreeIPA LDAP directory. Can anyone tell me
if this is available in Postgres? Looking through the docs, it appears
that it is not, and I have to manage user creation and role membership
manually.

I found this post from 5 years ago:

http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg58156.html

But I haven't found anything mentioning this functionality since.

Is anyone else attempting to do this? I could probably write a script
or something to auto create postgres users from the LDAP directory
(and remove users who have been deleted from LDAP) and then
synchronise the roles with LDAP groups, but I don't want to repeat
this work if someone's already done it.

I'd also appreciate any hints or suggestions for ways to do this.

Thanks,

Dan

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Please help me debug regular segfaults on 8.3.10
Next
From: sunpeng
Date:
Subject: when to update pg_statistic relation?