Andreas Schmid wrote: > 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? I would run a network trace with timestamps to see where the time is spent. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
