Enable HTTPS on pgAdmin in Server Mode

From: Morten Bonnerup Rasmussen <morten(dot)rasmussen(at)bestseller(dot)com>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Enable HTTPS on pgAdmin in Server Mode
Date: 2023-12-18 12:12:45
Message-ID: GV1PR07MB8952C1AE10F85ACDBB06F03FE690A@GV1PR07MB8952.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi

I am working on deployment of pgAdmin 4 as part of a postgreSQL package in our enterprise environment.

I have currently installed pgAdmin in server mode on a Windows Server, but running into problems configuring OAUTH2 authentication. I have enabled Azure AD/Entra ID authentication based on the following guide by Asmita
How to Configure OAuth 2.0 with Azure AD in pgAdmin4 | by Asmita Thapliyal | Medium<https://medium.com/@asmita.thapliyal/how-to-configure-oauth-2-0-with-azure-ad-in-pgadmin4-2c1500d52d9d>

But redirect URI in Azure app registration requires a HTTPS link and I have not found a way to specify a server certificate (currently selfsigned for testing purposes).
I have not been able to find anything on config file and only references I have found online involves NGINX or similar, but I would prefer not introducing further complications if possible.
Know of any way to natively enabling HTTPS connection to pgAdmin?

Morten Bonnerup Rasmussen

TECH Reliability Services / Specialist

BESTSELLER A/S

FREDSKOVVEJ 1, 7330 BRANDE

DENMARK

[cid:36db829f-2335-444d-b681-53cfd5158df6]

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message marissa c 2023-12-18 20:48:12 Re: Pg Admin 4
Previous Message Ballolli, Vinayak (external - Project) 2023-12-18 06:43:20 RE: Unable to open PgAdmin application.