From: | Andreas Schmid <user462411(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Login with LDAP authentication takes 5 seconds |
Date: | 2018-05-28 14:26:28 |
Message-ID: | CAKeZVDov+j2ZfUuSXNN-98_Nn_kAXr2e7UmKHhFNODHuEnUwUg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I configured my PostgreSQL 10 DB on Debian 9.2 with LDAP authentication
(simple bind mode). While this basically works, it has the strange effect
that the first login with psql takes around 5 seconds. When I reconnect
within 60 seconds, the login completes immediately.
The LDAP server is behind a firewall. So for a test, in pg_hba.conf I put
the LDAP servers IP address instead of its DNS name (for parameter
ldapserver). Like that, all logins complete immediately. But in general I
prefer specifying the DNS name rather than the IP.
When I checked on the DB machine with the following commands
host my.ldap.server.org
dig my.ldap.server.org
both always returned the host name and IP address of the LDAP server
immediately.
Does anyone of you have an explanation for this, or a hint, where I could
do some further investigation?
Thanks,
Andy
From | Date | Subject | |
---|---|---|---|
Next Message | Nishant, Fnu | 2018-05-28 15:07:52 | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
Previous Message | Peter J. Holzer | 2018-05-28 09:34:51 | Re: case statement within insert |