Hi Mahendrakar, pgAdmin is not an OAuth2 client/Middleware. It is a PostgreSQL management tool/client. pgAdmin is not suited for your requirement.
On Fri, Nov 18, 2022 at 9:47 AM mahendrakar s <mahendrakarfo...@gmail.com> wrote: > Hi PgAdmin Hackers, > > I am working on oauth poc with Postgres, here the flow is: > Authentication Code with pkce > > In this flow, I need to configure or make changes to PgAdmin to > > 1. Pass additional parameters in the connection string like below for psql: > ./psql -U mahendrak...@microsoft.com -d 'dbname=postgres > oauth_client_id=xxxx oauth_client_secret=xxx > oauth_flow_type=auth_code' > I am not sure how to pass these params in PgAdmin or configure it > to pass them. > 2. PgAdmin needs to listen on redirection url so that the user can > sign in and obtain the auth_code. > 3 . PgAdmin needs to send the auth_code to libpq during the oauth flow. > 4. Libpq sends the refresh_token to PgAdmin ( and used in future to > get the access_token in which case PgAdmin sends it to libpq). > > Can you suggest what would be the best way to do this? > > Thanks, > Mahendrakar. > > > -- Thanks, Aditya Toshniwal pgAdmin Hacker | Software Architect | *edbpostgres.com* <http://edbpostgres.com> "Don't Complain about Heat, Plant a TREE"
