Great, thank you!

Jeremi

From: Aditya Toshniwal <aditya.toshni...@enterprisedb.com>
Sent: May 25, 2020 1:08 AM
To: Potvin, Jérémi <jeremi.pot...@cra-arc.gc.ca>
Cc: PgAdmin Support List <pgadmin-support@lists.postgresql.org>; Khushboo Vashi 
<khushboo.va...@enterprisedb.com>
Subject: Re: Two Factor Authentication and the Query Tool


***ATTENTION***

This email originated from outside of the Government of Canada. Do not click 
links or open attachments unless you recognize the sender and believe the 
content is safe. For more information regarding reporting suspicious emails, 
please visit the KnowHow webpage: Suspicious emails - how to 
report<http://druid/KnowHow/sec-suseml-e.asp>

Ce courriel provient de l'extérieur du Gouvernement du Canada. Ne cliquez pas 
sur les liens et n’ouvrez pas les pièces jointes, à moins de connaître 
l'expéditeur et croire que le contenu est sécuritaire. Pour de plus amples 
renseignements sur la façon de signaler les courriels suspects, veuillez 
consulter la page Web SavoirFaire: Courriels suspects – Comment 
signaler<http://druid/savoirfaire/sec-suseml-f.asp>




On Mon, May 25, 2020 at 9:45 AM Khushboo Vashi 
<khushboo.va...@enterprisedb.com<mailto:khushboo.va...@enterprisedb.com>> wrote:
Hi,

On Fri, May 22, 2020 at 8:48 PM Potvin, Jérémi 
<jeremi.pot...@cra-arc.gc.ca<mailto:jeremi.pot...@cra-arc.gc.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:

[cid:image001.png@01D63268.28D9D380]

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"

Reply via email to