LDAP authentication slow

From: C GG <cgg0007(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: LDAP authentication slow
Date: 2018-05-29 14:09:47
Message-ID: CAJXW-z-K1h_2icOgdOaQZzX0d3dz-SQeLxHMi2EFP7Egy0q03Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This is PostgreSQL 9.5 -- We just enabled LDAP(S) authentication (to an
Active Directory server) for a certain grouping of users

pg_hba.conf

#...

hostssl all +ldap_group 0.0.0.0/0 ldap ldaptls="1" ldapserver="....
hostssl all all 0.0.0.0/0 md5

#...

I'm getting complaints from the users authenticating using ldap that
database operations are taking quite a bit longer than they were previously
when they were authenticating with MD5 stored passwords. Clearly, there's
more machinery at work with that kind of operation, but the increase in
time is way more that I would have estimated.

I still want them to be able to type in a password, so GSSAPI is out for an
alternative (right?) ... Is there something I can do to help speed things
up? If there any telemetry that I can generate (logs, stats, etc.) which
might be able to pinpoint a bottleneck?

Thanks all,

CG

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Dunavant 2018-05-29 14:26:42 Re: existence of a savepoint?
Previous Message Melvin Davidson 2018-05-29 13:59:40 Re: How to drop a value from an ENUM?