Re: Database log in

Поиск
Список
Период
Сортировка
От Heckler, Kim M
Тема Re: Database log in
Дата
Msg-id SA1PR07MB8484CBE9384C96B04674EAA3867A2@SA1PR07MB8484.namprd07.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Database log in  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Database log in
Следующее
От: lejeczek
Дата:
Сообщение: max_wal_senders - stuck on