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
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?