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@uw.edu / www.cip.uw.edu

On Oct 21, 2021, at 5:44 AM, Akshay Joshi <akshay.joshi@enterprisedb.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