Re: LDAP with TLS is taking more time in Postgresql 11.5

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Mani Sankar <manisankar01695(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: LDAP with TLS is taking more time in Postgresql 11.5
Date: 2020-02-25 09:20:59
Message-ID: 862457adf1a223499e3ec2f50e1932d34cfc803b.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On Tue, 2020-02-25 at 01:20 +0530, Mani Sankar wrote:
> We have recently upgraded our postgres servers from 9.4 version to 11.5 version. Post upgrade we are see delay in authentication.
>
> Issue is when we are using ldaptls=1 the authentication takes 1 second or greater than that. But if I disable ldaptls it's getting authenticated within milliseconds.
>
> But in 9.4 even if I enable ldaptls it's getting authenticated within milliseconds any idea why we are facing the issue?

I would use a packet sniffer like Wireshark to examine the message flow and see where the time is spent.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nick Renders 2020-02-25 09:35:38 Re: Postgres 12.1 : UPPER() in WHERE clause restarts server
Previous Message Sonam Sharma 2020-02-25 08:01:13 Trigger

Browse pgsql-performance by date

  From Date Subject
Next Message Adrian Klaver 2020-02-25 15:54:31 Re: LDAP with TLS is taking more time in Postgresql 11.5
Previous Message Adrian Klaver 2020-02-24 20:58:20 Re: LDAP with TLS is taking more time in Postgresql 11.5