Two Factor Authentication and the Query Tool - Mailing list pgadmin-support

From Potvin, Jérémi
Subject Two Factor Authentication and the Query Tool
Date
Msg-id ee22d93d6a5b419a97643666ca03bb65@cra-arc.gc.ca
Whole thread Raw
Responses Re: Two Factor Authentication and the Query Tool
List pgadmin-support

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?

 

 

 

Thank you in advance for your help,

Jeremi

 

 

Attachment

pgadmin-support by date:

Previous
From: Aditya Toshniwal
Date:
Subject: Re: How to suppress the Notifications Popup?
Next
From: Khushboo Vashi
Date:
Subject: Re: Two Factor Authentication and the Query Tool