News for hackers. Stuff that matters.
Re:PostgreSQL's Imperfections by LunaSea on Saturday April 04, 2020 @08:15AM (#22777816)
I think it's a bad idea for a database to start implementing third-part vendor related features.

That's the type of feature that should be implemented as a plugin.

Re:PostgreSQL's Imperfections by nijave on Saturday April 04, 2020 @08:35AM (#22777886)
You could just call it "ldap authentication". AD comes with an LDAP interface.
Re:PostgreSQL's Imperfections by anarazel on Saturday April 04, 2020 @08:43PM (#22782748)
Postgres does have ldap based auth, and also can authenticate against AD using sspi/gssapi.

The problem with that is that it requires users to have been created inside postgres first, and that you can't manage group membership inside AD.

Re:PostgreSQL's Imperfections by gregn610 on Sunday April 05, 2020 @06:37AM (#22784899)
yup, that's what I meant by authorisation, keeping the roles and groups in pgsql up to date.
Re:PostgreSQL's Imperfections by fanf2 on Saturday April 04, 2020 @08:39PM (#22782723)
Or Kerberos authentication (which AD also supports) https://www.postgresql.org/docs/current/gssapi-auth.html
Re:PostgreSQL's Imperfections by jtdev on Saturday April 04, 2020 @11:41AM (#22778881)
Yes, and that AD LDAP interface is riddled with MS specific deviations that require complying with MS’s way of doing LDAP.