Re: Two Factor Authentication and the Query Tool

On Mon, May 25, 2020 at 9:45 AM Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:

> Hi,
>
> On Fri, May 22, 2020 at 8:48 PM Potvin, Jérémi <
> Jeremi(dot)Potvin(at)cra-arc(dot)gc(dot)ca> wrote:
>
>> Hello,
>>
>>
>>
>> I currently have two factor authentication set up on my PG database going
>> to a Radius server.
>>
>>
>>
>> I can connect to the database using Pgadmin4 v4.2 just fine, but as soon
>> as I try to open a Query Tool window, I get an authentication error.
>>
>> That’s because pgAdmin is trying to pass the credentials of my initial
>> connection to the Query Tool for it to connect to the database. I cannot
>> reuse my initial credentials more than once.
>>
>>
>>
>> In another tool (Data Studio) that I use to connect to DB2 databases,
>> there’s an option to prevent this:
>>
>>
>>
>>
>>
>> Does anyone know if there’s a parameter in pgadmin or the config files
>> that can fix my issue?
>>
>> Would it be possible in later versions?
>>
>>
>>
> Not supported by pgAdmin 4 right now.
> Please create a feature request @
> https://redmine.postgresql.org/projects/pgadmin4 for the same.
>
The feature request is there. We will consider it for future release -
https://redmine.postgresql.org/issues/5403

>
> Thanks,
> Khushboo
>
>>
>>
>>
>>
>> Thank you in advance for your help,
>>
>> Jeremi
>>
>>
>>
>>
>>
>

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"