Home > mailing lists

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

From	Potvin, Jérémi
Subject	RE: Two Factor Authentication and the Query Tool
Date	May 25, 2020 14:43:20
Msg-id	0974783f32d34cd4a9d5cfe8b9603179@cra-arc.gc.ca Whole thread Raw
In response to	Re: Two Factor Authentication and the Query Tool (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
List	pgadmin-support

Tree view

Great, thank you!

Jeremi

From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: May 25, 2020 1:08 AM
To: Potvin, Jérémi <Jeremi.Potvin@cra-arc.gc.ca>
Cc: PgAdmin Support List <pgadmin-support@lists.postgresql.org>; Khushboo Vashi <khushboo.vashi@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

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

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

Hi,

On Fri, May 22, 2020 at 8:48 PM Potvin, Jérémi <Jeremi.Potvin@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:

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.