Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg7gW-007tbP-2v for pgsql-announce@arkaria.postgresql.org; Thu, 06 Feb 2025 19:37:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tg7gV-00AvMq-0z for pgsql-announce@arkaria.postgresql.org; Thu, 06 Feb 2025 19:37:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg7gT-00AvKW-Uf for pgsql-announce@lists.postgresql.org; Thu, 06 Feb 2025 19:37:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tg7gP-003b8z-1B for pgsql-announce@lists.postgresql.org; Thu, 06 Feb 2025 19:37:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=UL2tjqS4M4flDJtHsWXLSG2RPE2kF2udld/628PeyG4=; b=uEubKugdeeCJkgcJPUG/59NBLQ ud1DymnS2GVkJbqZ05J6Exh6b37Umh8yTtc+Tsdr1C1b04lGH+yY0CAwPleCjmDo+qAuKfFTNEx+5 SHszLsO0vQ8D0gBOzp0DNeWGIyg6Bluf3YvnIbG7fOtye0JcllxSPfrna13a7EkSAFcPf6FeRKdHh 9KtTOp64JwCiNQ+y3QXArulgqy3KCpiPhcnbnEwQpKyVx4XpSBmQQPanGASPnjrPUp3YqEHG0Gq8C 3yPXFVoUDjVBdGa+70+QmNtGaK9JrXEE/CqHvsbUzgH5HbDycq/ND78nNhSTe5Vm4uCzzXqxaBVsX Lhuz277w==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg7gO-00GtD0-Jf for pgsql-announce@lists.postgresql.org; Thu, 06 Feb 2025 19:37:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tg7gN-0007UY-5V for pgsql-announce@lists.postgresql.org; Thu, 06 Feb 2025 19:37:02 +0000 Content-Type: multipart/mixed; boundary="===============3690461057985265580==" MIME-Version: 1.0 Subject: pgAdmin 4 v9.0 Released To: PostgreSQL Announce From: pgAdmin Development Team via PostgreSQL Announce Reply-To: news@pgadmin.org Date: Thu, 06 Feb 2025 19:36:30 +0000 Message-ID: <173887059074.1064.11667820034003566944@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: ff5ec18ac74f75d841cdfacb5121c7cb4abe893724847e795e118712230ffd6d List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3690461057985265580== Content-Type: multipart/alternative; boundary="===============5471906985797091536==" MIME-Version: 1.0 --===============5471906985797091536== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable 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/pgadmin= 4/9.0/release_notes_9_0.html). =20 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 firs= t run, followed by the installation of version 9. Notable changes in this release include: =20 ### 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 la= yout, which provides a streamlined, distraction-free environment with dedic= ated areas for the Query Tool, PSQL, and Schema Diff tools. The Workspace l= ayout is set as the default, but users can easily switch to the Classic lay= out through the preferences. In the Workspace layout, the Query Tool, PSQL, and Schema Diff tabs are org= anized and opened within their respective workspaces for a more focused exp= erience. * Added the MAINTAIN privilege for PostgreSQL version 17 and above. * Add support for OAuth2 profile array response, which handles the GitHub P= rivate 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 spac= e 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 MATERIAL= IZED VIEW context menu. * Fixed an issue where Default Privileges and Privileges not working correc= tly. * Fixed an issue where quotes were missing in the CREATE script for the tab= lespace. * Change the logic of the setval function, so that the next nextval of sequ= ence 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 [tarba= ll area](https://www.pgadmin.org/download/). --===============5471906985797091536== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pgAdmin 4 v9.0 Released
 

pgAdmin 4 v9.0 Released

The pgAdmin Development Team is pleased to = announce pgAdmin 4 version 9.0. This release of pgAdmin 4 includes 25 bug f= ixes and new features. For more details please see the release notes.

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

Note: (Windows only)

In this release, the 'vX' suffix has been r= emoved from the application name. You will now see 'pgAdmin 4' as the app n= ame. Starting from version 8, we also removed the 'vX' folder from the defa= ult installation path, allowing users to seamlessly upgrade to major versio= ns. As a result of this change, if version 8 is already installed on the ma= chine, the uninstaller will first run, followed by the installation of vers= ion 9.

Notable changes in this release include:

Features:

  • Enhanced pgAdmin 4 with support for Workspa= ce layouts.

    Starting with this release, pgAdmin introdu= ces two layout options: the Classic layout, a familiar design users know we= ll, 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 easi= ly switch to the Classic layout through the preferences. In the Workspace layout, the Query Tool, PSQL, and Schema Diff tabs are org= anized and opened within their respective workspaces for a more focused exp= erience.

  • Added the MAINTAIN privilege for PostgreSQL= version 17 and above.

  • Add support for= OAuth2 profile array response, which handles the GitHub Private Email ID i= ssue.
  • Change button l= abels and color in the delete confirmation dialog for all objects to improv= e 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 connecti= on is lost.
  • Fixed an issue = where an error message from the database server needs space between two sen= tences.
  • Fixed an issue = where the query tool throws utf-8 decode error when using a cursor with bin= ary 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 sele= cted.
  • Remove the opti= on "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 logi= c 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 sou= rce code tarball from the tarball area.
This email was sent to you from pgAdmin Development Team. It was delivered = on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to pgAdmin Development Team.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============5471906985797091536==-- --===============3690461057985265580==--