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

2020-02-25 Thread Thomas Munro
On Wed, Feb 26, 2020 at 7:37 AM Adrian Klaver wrote: > On 2/25/20 10:23 AM, Mani Sankar wrote: > > Hi Adrian, > > > > Both the machines are in same network and both are pointing towards the > > same LDAP server > > I don't see any errors in the Postgres logs. > > You probably should take a look at

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

2020-02-25 Thread Adrian Klaver
On 2/25/20 10:23 AM, Mani Sankar wrote: Hi Adrian, Both the machines are in same network and both are pointing towards the same LDAP server I don't see any errors in the Postgres logs. You probably should take a look at the LDAP server logs to see if there is anything there. You could als

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

2020-02-25 Thread Mani Sankar
Hi Adrian, Both the machines are in same network and both are pointing towards the same LDAP server Regards, Mani. On Tue, 25 Feb, 2020, 11:48 pm Adrian Klaver, wrote: > On 2/25/20 10:08 AM, Mani Sankar wrote: > > Hi Adrian, > > > > Should I want to try this configuration? > > I thought you wh

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

2020-02-25 Thread Adrian Klaver
On 2/25/20 10:08 AM, Mani Sankar wrote: Hi Adrian, Should I want to try this configuration? I thought you where already using this configuration? Are the 9.4 and 11.5 instances are on the same machine and/or network? In other words is ldapserver=XXX pointing at the same thing?

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

2020-02-25 Thread Mani Sankar
Hi Adrian, Should I want to try this configuration? Regards, Mani. On Tue, 25 Feb, 2020, 9:24 pm Adrian Klaver, wrote: > On 2/24/20 9:07 PM, Mani Sankar wrote: > Please reply to list also. > Ccing list. > > Hi Adrian, > > > > Thanks for replying. Below are the requested details. > > > > ##

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

2020-02-25 Thread Adrian Klaver
On 2/24/20 9:07 PM, Mani Sankar wrote: Please reply to list also. Ccing list. Hi Adrian, Thanks for replying. Below are the requested details. Configuration in 9.4 PG Version local all all ldap ldapserver=XX ldapport=3268 ldapprefix="ADS\" ldapsuffix="" ldaptls=1

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

2020-02-25 Thread Laurenz Albe
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

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

2020-02-24 Thread Adrian Klaver
On 2/24/20 11:50 AM, Mani Sankar wrote: Hi All, 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 ldap

LDAP with TLS is taking more time in Postgresql 11.5

2020-02-24 Thread Mani Sankar
Hi All, 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 millise