Re: Database log in - Mailing list pgsql-admin

From Heckler, Kim M
Subject Re: Database log in
Date
Msg-id SA1PR07MB8484CBE9384C96B04674EAA3867A2@SA1PR07MB8484.namprd07.prod.outlook.com
Whole thread Raw
In response to Re: Database log in  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
>> MichaelDBA <MichaelDBA@sqlexec.com> writes:
>> > I don't have a problem with hundreds or thousands of logins per minute 
>> > on RDS or bare metal, even with only 8 CPUs and 32GB RAM.  There is 
>> > something else in play here...
>> 
>> Yeah.  The OP didn't mention the authentication method in use, but I could believe some sort of 
>> performance glitch if it consults an external server (for Kerberos, AD, LDAP, etc).
>> Or maybe it's basically a network problem between client and server.
>> 
>>             regards, tom lane
>> 

Auth method is local password.  The AWS RDS Instance does have Kerberos enable so there is ONE role
that authenticates via AD.  I was thinking, maybe, that the local ID was mistakenly trying to authenticate
via AD, failing, and then authenticating locally??  I do have a ticket open with AWS to inquire about this.
Also, I will use strace to gather more info.

Thank you, Kim.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database log in
Next
From: lejeczek
Date:
Subject: max_wal_senders - stuck on