pgAdmin 4 v6.3 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.3. This release of pgAdmin 4 includes 31 bug fixes and new features. For more details please see the release notes.

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

Notable changes in this release include:

Features:

• Added support for Two-factor authentication for improving security.

  Two-factor authentication (2FA) is an extra layer of security used when logging into websites or apps. With 2FA, you have to log in with your username and password and provide another form of authentication that only you know or have access to.

• Added support to disable the auto-discovery of the database servers.

  This feature allows you to disable the auto discovery of the database servers. Set AUTO_DISCOVER_SERVERS = False in config_local.py or config_distro.py.

• Include GSSAPI support in the PostgreSQL libraries and utilities on macOS.

Bugs/Housekeeping:

• Port Backup Global, Backup Server, and Backup object dialog in React.
• Upgrade Flask to version 2 and replace Flask-BabelEx with Flask-Babel
• Replace Alertify alert and confirm with React-based model dialog and alertifyjs notifiers with React-based notistack.
• Fixed schema diff owner related issue.
• Ensure that sort order should be maintained when renaming a server group.
• Ensure that the user should be allowed to set the schema of an extension while creating it.
• Fixed an issue where the user can't debug a function with a timestamp parameter.
• Fixed an issue where reverse engineering SQL was wrong for Aggregate.
• Correct the SQL definition for function/procedure with the Atomic keyword in PG14.
• Fixed an issue where SQLite database definition was wrong because the USER_ID FK references the table user_old which is not available.

Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from the tarball area.