public inbox for [email protected]  
help / color / mirror / Atom feed
From: pgAdmin Development Team via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: pgAdmin 4 v9.0 Released
Date: Thu, 06 Feb 2025 19:36:30 +0000
Message-ID: <[email protected]> (raw)

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.0. This release of pgAdmin 4 includes 25 bug fixes and new features. For more details please see the [release notes](https://www.pgadmin.org/docs/pgadmin4/9.0/release_notes_9_0.html).
 
pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more information, please see [the website](https://www.pgadmin.org/).


### Note: (Windows only)
In this release, the 'vX' suffix has been removed from the application name. You will now see 'pgAdmin 4' as the app name. Starting from version 8, we also removed the 'vX' folder from the default installation path, allowing users to seamlessly upgrade to major versions. As a result of this change, if version 8 is already installed on the machine, the uninstaller will first run, followed by the installation of version 9.

Notable changes in this release include:
 
### Features:
* Enhanced pgAdmin 4 with support for Workspace layouts.

    Starting with this release, pgAdmin introduces two layout options: the Classic layout, a familiar design users know well, and the new Workspace layout, which provides a streamlined, distraction-free environment with dedicated areas for the Query Tool, PSQL, and Schema Diff tools. The Workspace layout is set as the default, but users can easily switch to the Classic layout through the preferences.
In the Workspace layout, the Query Tool, PSQL, and Schema Diff tabs are organized and opened within their respective workspaces for a more focused experience.

* Added the MAINTAIN privilege for PostgreSQL version 17 and above.
* Add support for OAuth2 profile array response, which handles the GitHub Private Email ID issue.
* Change button labels and color in the delete confirmation dialog for all objects to improve UX.

### Bugs/Housekeeping:
* Fixed an issue where pgadmin cannot install into the path with non-ASCII characters.
* Fixed an issue where filter dialog save fails when the PostgreSQL server/database connection is lost.
* Fixed an issue where an error message from the database server needs space between two sentences.
* Fixed an issue where the query tool throws utf-8 decode error when using a cursor with binary data.
* Fixed an issue where the option key was not registering in the PSQL tool.
* Fixed an issue where copying query tool output cell is not working if any SQL text is selected.
* Remove the option "With no data (concurrently)" from the Refresh MATERIALIZED VIEW context menu.
* Fixed an issue where Default Privileges and Privileges not working correctly.
* Fixed an issue where quotes were missing in the CREATE script for the tablespace.
* Change the logic of the setval function, so that the next nextval of sequence will return exactly the specified value.


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](https://www.pgadmin.org/download/).

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pgAdmin 4 v9.0 Released
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox