Re: pgAdmin 4 v6.1 Released

Hi Akshay, I want to really thank you and Khushboo Vashi for this new feature to authenticate via REMOTE_USER.

However, it's clear from the functionality that it only addresses working with pgAdmin when it is embedded inside uWSGI or mod_wsgi, and that's OK :)

To make it work with headers that come from another server, I added these lines to my config_local.py file:

# monkey patch the authentication class to use headers instead of environments
from flask import request
import pgadmin.authenticate.webserver

def get_user(self):
username = request.headers.get("X-Forwarded-User")
if not username or username == "(null)":
username
return username

pgadmin.authenticate.webserver.WebserverAuthentication.get_user = get_user

I wanted to share this with the list, too, in case someone else wants to add this functionality to their system. Thanks a ton!

-Paul

Paul Lockaby (he/him) / Senior Data Engineer
Center for an Informed Public / University of Washinton
plockaby(at)uw(dot)edu<mailto:plockaby(at)uw(dot)edu> / www.cip.uw.edu<http://www.cip.uw.edu>

On Oct 21, 2021, at 5:44 AM, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com<mailto:akshay(dot)joshi(at)enterprisedb(dot)com>> wrote:

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.1.

This release of pgAdmin 4 includes 30 bug fixes and new features. For more details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/6.1/release_notes_6_1.html.

pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Features:

*
Added support for indent guides in the browser tree.
*
Added support for advanced table fields like the foreign key, the primary key in the ERD tool.
*
Added support to allow tables to be dragged to the ERD Tool.
*
Added index creation when generating SQL in the ERD tool.
*
Added support for authentication via the web server (REMOTE_USER).
*
Added support to enable/disable rules.

Bugs/Housekeeping:

*
Fixed OAuth2 integration redirect issue.
*
Ensure that the query highlighting color in the query tool should be less intensive.
*
Fixed an issue where the browser tree doesn't show all contents on changing resolution.
*
Ensure that columns should be displayed in the order of creation instead of alphabetical order in the browser tree.
*
Fixed background color issue in the browser tree.
*
Added support for composite foreign keys in the ERD tool.
*
Fixed an issue where the users are unable to load the databases behind an HTTP reverse proxy.
*
Fixed an issue where each click to refresh the collection node, the number of objects decreasing by tens or more.
*
Fixed browser tree sort order regression issue.
* Fixed an issue where the blank string is stored instead of NULL in the server table of an SQLite database.

Builds for Windows and macOS are available now, along with a Python Wheel,
Docker Container, RPM, DEB Package, and source code tarball from:
https://www.pgadmin.org/download/
--
Akshay Joshi

pgAdmin Project