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 1tg24d-007ADM-34 for pgadmin-support@arkaria.postgresql.org; Thu, 06 Feb 2025 13:37:43 +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 1tg24b-007YDX-BT for pgadmin-support@arkaria.postgresql.org; Thu, 06 Feb 2025 13:37:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg24b-007YCD-0U for pgadmin-support@lists.postgresql.org; Thu, 06 Feb 2025 13:37:41 +0000 Received: from mail-lj1-x22e.google.com ([2a00:1450:4864:20::22e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tg24W-003vs6-1w for pgadmin-support@postgresql.org; Thu, 06 Feb 2025 13:37:39 +0000 Received: by mail-lj1-x22e.google.com with SMTP id 38308e7fff4ca-3076262bfc6so8887841fa.3 for ; Thu, 06 Feb 2025 05:37:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1738849055; x=1739453855; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=Ah+d2iSKEzpxP8RNWXtuN+eySQoTKSTjameiWsCZH+Q=; b=ekclDB5/pQT0NCGxCYAXCTjQTlapV5DdDZt/P1WX6Ax96i3Vwvc6K6MnNrf/OykX+w PBNSpnh2Aq3pUtGcwlzUdT5eKqlMsARnNCSzgFqYstmYpbUb7UUkjAbo6inC4z6y3LJS e/JBqUjA+HnO/XGFBRIt/P4Yo4fMz3MRqEin1BmHuQDhI26fB2HJylZgdQ6bhhyVjFJk 3sQ58oDBNQRwJYXx37vukQXxBbcVY2NlkVryZTf/PseQhG4nQC9qoEDPIetB7S2zG+5W JEfMuyrKFsHdMwUOFED99LzjIo55GM6I2K2Zq4Die/IwbMyxoPcAAwm17iP0o+KnMqqH AA9Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738849055; x=1739453855; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Ah+d2iSKEzpxP8RNWXtuN+eySQoTKSTjameiWsCZH+Q=; b=dJlPs6ts30NdElqwfW0s2y9cMrxxuSyrqG2lLssqRQbOb+5YAloFVWqcaNGxTUHLFW NMcK6rg+h8UY+yQuuv0k2zfhsmQ6weHtHj7QK7ghG1eZpioKy7GN+52tnrJomwD8R1sA 7zFfK+FvHE3Q87cKx7hB2ZFsaO1exTea44QTuRH2dpMhhsDnBJAApmVJzXoFLt/oR+ic t45M9Ck9wiG/csPrf6lCvIgOHbfKqyX2dfbn4tHZbzggX79AQulL9CsaH6zYv3FNblkL Gmbz0UWNldEPl1JrY7cVK+B+xAeNebi17hz/RLd6IyeLOQoyTVNeYJmFmx7cbAqqNXy5 LnBg== X-Gm-Message-State: AOJu0YyRXNFprehwTay4wOG8umLDNQvlO5qRuzPy9jP/LWuGOBnexF/e AN+6A5D9TdOxZxFhHT6s6eIdeJZ/zKIhNPjZKJQ/DJkdf1UT/QRPhiZUfQA3afr/GOvzmsABuAE +SF6opTFqtxa9pVT5gWoXni6HBHjCY4Jjb+vIo2hlKxLBpgl6vc7P X-Gm-Gg: ASbGncusDTfll1RLfD5lIVnR7CoWduFNAP4G/fIQrJKtRFysg7a4oKqA0g/89e1hAbW 3IagqTsOALfxm3zZM0otG2DgYRM+2ulldZzhzh7tbyuLqZUgdXLTSxHOmNW0A0HtazhQCqc3VuI rMcsLWqVhDLYmjJQ1BtD85NyHguZnPdQ== X-Google-Smtp-Source: AGHT+IHu7Vlc9nhNJyYI9fBtly9QuY0p96TJCTsy7bhjJ+gQ47ai4G3/D8939tW8iR6AdIxC7Rcs3AZQOVuy4kp1s0w= X-Received: by 2002:a2e:a98d:0:b0:301:2d8d:a3ba with SMTP id 38308e7fff4ca-307cf37139dmr28577291fa.23.1738849054749; Thu, 06 Feb 2025 05:37:34 -0800 (PST) MIME-Version: 1.0 From: Akshay Joshi Date: Thu, 6 Feb 2025 19:07:23 +0530 X-Gm-Features: AWEUYZnHZ5jDDpc4RNoWddSfyiaGO-ebs7mG86SFScnIEQcz-IKnK6G4f_udEmk Message-ID: Subject: pgAdmin 4 v9.0 Released To: pgAdmin Support Content-Type: multipart/alternative; boundary="0000000000003a1201062d7958c7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003a1201062d7958c7 Content-Type: text/plain; charset="UTF-8" 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 at: 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: 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: https://www.pgadmin.org/download/ -- Akshay Joshi pgAdmin Project --0000000000003a1201062d7958c7 Content-Type: text/html; charset="UTF-8" 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 at:


=C2=A0=C2=A0= =C2=A0=C2=A0https://w= ww.pgadmin.org/docs/pgadmin4/9.0/release_notes_9_0.html


<= p dir=3D"ltr" style=3D"line-height:1.656;margin-top:0pt;margin-bottom:0pt">= pgAdm= in is the leading Open Source graphical management tool for PostgreSQL. For= more information, please see:


=C2=A0=C2=A0=C2=A0=C2=A0https://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 v= ersions.

As a result of this change, if version 8 is alread= y installed on the machine, the uninstaller will first run, followed by the= installation of version 9.


Notable changes in this release inclu= de:


Features:

  • Enhanced pgAdmin 4 with support for Wo= rkspace layouts.


Starting with this re= lease, pgAdmin introduces two layout options: the Classic layout, a familia= r design users know well, and the new Workspace layout, which provides a st= reamlined, distraction-free environment with dedicated areas for the Query = Tool, PSQL, and Schema Diff tools. The Workspace layout is set as the defau= lt, but users can easily switch to the Classic layout through the preferenc= es.

In the Workspace layout, the Query Tool, PSQL, a= nd Schema Diff tabs are organized and opened within their respective worksp= aces for a more focused experience.


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

  • Add support for OAuth= 2 profile array response, which handles the GitHub Private Email ID issue.<= /span>

  • Change button labels and color in the delete co= nfirmation dialog for all objects to improve UX.


<= span style=3D"font-size:11pt;font-family:Arial,sans-serif;color:rgb(0,0,0);= background-color:transparent;font-weight:700;font-variant-numeric:normal;fo= nt-variant-east-asian:normal;font-variant-alternates:normal;vertical-align:= baseline">Bugs/Housekeeping:

  • Fixed an issue where pgadmin cannot install into = the path with non-ASCII characters.

  • Fixed an is= sue where filter dialog save fails when the PostgreSQL server/database conn= ection is lost.

  • Fixed an issue where an error m= essage 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.

  • Fi= xed an issue where the option key was not registering in the PSQL tool.

  • Fixed an issue where copying query tool output ce= ll 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 scri= pt for the tablespace.

  • Change the logic of the = setval function, so that the next nextval of sequence will return exactly t= he specified value.



Builds for Windows and macOS ar= e available now, along with a Python Wheel,

Docker Container, RPM, D= EB Package, and source code tarball from:

=C2=A0=C2=A0=C2=A0=C2=A0https://www.pgadmin.org/download/


--

Akshay Joshi

pgAdmin Project

--0000000000003a1201062d7958c7--