| Index | index by Group | index by Distribution | index by Vendor | index by creation date | index by Name | Mirrors | Help | Search |
| Name: pgadmin4-desktop | Distribution: openSUSE Tumbleweed |
| Version: 9.8 | Vendor: openSUSE |
| Release: 1.1 | Build date: Wed Oct 8 08:33:57 2025 |
| Group: Productivity/Networking/Web/Utilities | Build host: reproducible |
| Size: 31604 | Source RPM: pgadmin4-9.8-1.1.src.rpm |
| Packager: http://bugs.opensuse.org | |
| Url: http://www.pgadmin.org | |
| Summary: Desktop application for pgAdmin4 | |
pgAdmin 4 is a rewrite of the pgAdmin3 management tool for the PostgreSQL database. This package provides a small python script that can be used to start pgAdmin4 as a regular user and provides a simple ui as a system tray icon to open more windows or quit. Note that his script is not related to the official pgAdmin4 runtime application and is NOT supported by the pgAdmin project but only provided for convenience.
PostgreSQL
* Wed Oct 08 2025 Antonio Larrosa <alarrosa@suse.com>
- Add node_modules.sums as source in the spec file
* Thu Oct 02 2025 Antonio Larrosa <alarrosa@suse.com>
- update to 9.8:
* Supported Database Servers
- PostgreSQL: 13, 14, 15, 16 and 17
- EDB Advanced Server: 13, 14, 15, 16 and 17
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.5
* New features
- Add menu items for truncating foreign tables.
- Added Debian Trixie as a supported platform for pgAdmin.
- Allow user to configure security related gunicorn parameters.
- Change the default pgAdmin theme to System.
* Housekeeping
- Remove usage of BrowserFS as it is deprecated.
* Bug fixes
- Pin Paramiko to version 3.5.1 to fix the DSSKey error
introduced in the latest release.
- Fixed an issue where pgAdmin config migration was failing
while upgrading to v9.7.
- Fixed Cross-Origin Opener Policy (COOP) vulnerability in the
OAuth 2.0 authentication flow (CVE-2025-9636, bsc#1249151).
- Fixed an issue where editor shortcuts fail when using Option
key combinations on macOS, due to macOS treating Option+Key
as a different key input.
- Fixed an issue where the pgAdmin configuration database
wasn't being created on a fresh install when an external
database was used for the configuration.
- update to 9.7:
* Supported Database Servers
- PostgreSQL: 13, 14, 15, 16 and 17
- EDB Advanced Server: 13, 14, 15, 16 and 17
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.2
* New features
- Add support for automatic updates in the pgAdmin 4 Desktop
application on macOS.
- Added GENERIC_PLAN, MEMORY, SERIALIZE option to
EXPLAIN/EXPLAIN ANALYZE command.
- Add support for changing cursor blink rate within the
editors.
- Add support for server tag-based filtering in the Object
Explorer.
- Added support for builtin locale provider while creating
Collation.
* Housekeeping
- Replace keyword PROCEDURE with FUNCTION while creating
trigger and event trigger.
- Introduced an ‘Editor’ preferences category and migrated
all editor related settings into it.
* Bug fixes
- Fixed an issue where custom column widths in the result grid
of Query Tool or View/Edit Data were reset after re-executing
a query.
- Fixed the issue where updating the name of a table column
does not reflect in the corresponding primary key constraint.
- Fixed an issue where pgAdmin failed to update the server
connection status when the server was disconnected in the
background and a refresh was performed on that server.
- Make Dashboard tables to be vertically resizable.
- Fixed an issue in Firefox where the query window would shift
to the left after opening the history tab or selecting a
column header in the results grid.
- Fixed an issue where CPU usage was very high on Windows when
opening the psql tool.
- Ensure DB restriction type is preserved while import and
export server.
- Fixed incorrect behaviour of the option deduplicate items
after creating the index.
- Added PKEY index in the index statistics summary.
- Fixed an issue where adding breakpoints caused errors, and
stepping out of a nested function removed breakpoints from
the parent function.
- Ensure the scratch pad in the Query Tool is not restored
after it is closed.
- Update the documentation for parameters that require file
paths.
- Fixed an issue where downloading images on the ERD tool was
not working in desktop mode.
- Ensure that disabling “Save Application State” in
Preferences prevents tool data from being saved and stops it
from being restored on application restart.
- update to 9.6:
* Supported Database Servers
- PostgreSQL: 13, 14, 15, 16 and 17
- EDB Advanced Server: 13, 14, 15, 16 and 17
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.2
* New features
- Ensure that keyboard shortcuts are displayed in tooltips,
context menus, and the main menu.
- Implemented a server-side cursor to enhance performance when
retrieving large datasets.
- Added support for setting a custom SESSION_DIGEST_METHOD in
pgAdmin 4 to facilitate FIPS compliance.
- Enable the PKCE workflow for OAuth 2 authentication.
* Housekeeping
- Ensure that pgAdmin 4 is compatible with PG/EPAS v18.
- Use ‘Drop’ instead of ‘Delete’ for object commands to make
destructive actions more deliberate.
* Bug fixes
- Fixed an issue where windows installer is not signing tmp
files generated by InnoSetup.
- Fixed an issue in the Search Objects tool where selecting a
node occasionally selected an incorrect node.
- Improved the application state restoration by leveraging
rc-dock layout and ensure the order and layout of tabs is
maintained on restore.
- Fixed an issue where json editor in result grid was crashing
if null value is set in the json editor.
- Update zstd library link to 1.5.7 in Dockerfile.
- update to 9.5:
* Supported Database Servers
- PostgreSQL: 13, 14, 15, 16 and 17
- EDB Advanced Server: 13, 14, 15, 16 and 17
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.2
* New features
- Add a new permission to allow disabling “Change Password”
feature for a pgAdmin role.
- Added role-based restrictions for editing server connections.
- Added support for customizing keyboard shortcuts in the Query
Tool’s Edit menu.
- Add a search box to enable searching within the preferences
tab.
- Added support to preserve the workspace, query windows, and
pgAdmin state during an abrupt shutdown or restart.
- Open preferences in a new tab instead of a dialog for better
user experience.
- Supports JSON logging for gunicorn process within Docker.
* Bug fixes
- Improved PL/pgSQL code folding and support nested blocks.
- Add a flag to allow access to system Python packages on
recent Linux distributions.
- Fixed an issue where utilities such as pg_dump and pg_restore
failed to log error messages when required dependency files
were missing.
- Fixed an issue where the Schema Diff Tool incorrectly
reported differences due to variations in the order of the
privileges.
- Fixed an issue in SQL syntax highlighting where the same
color was used for both variable names and datatypes.
- Fixed an issue in the query tool where using multiple cursors
to copy text resulted in only the first line being copied.
- Ensure that Keyboard shortcuts for save and download actions
should not called when their respective UI buttons are
disabled.
- Fixed an issue where data export using a query opened the
wrong dialog type.
- Fixed an issue where data export using a query failed when
the query contained a newline character.
- Fixed a UI layout issue that occurred after upgrading from
pgAdmin v9.2 when all tabs had been closed prior to the
upgrade.
- Fixed an issue where the Columns node was not visible under
Catalog Objects.
- update to 9.4:
* Supported Database Servers
- PostgreSQL: 13, 14, 15, 16 and 17
- EDB Advanced Server: 13, 14, 15, 16 and 17
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.2
* New features
- Enabled large file downloads for desktop users within the
query tool.
- Add all missing options to the Import/Export Data
functionality, and update the syntax of the COPY command to
align with the latest standards.
- Add support for exporting table data based on a custom query.
* Bug fixes
- Fixed an issue where the result grid slowed down when any
column contained a large amount of data.
- Fix the issue where an error is displayed when a table is
dropped while a query is running.
- Fixed an issue where the options key was not working as
expected in the PSQL tool.
- Fixed an issue where correct error message not displayed when
sql statement contains Arabic letters.
- Enhance contrast for selected and hovered items in the Object
Explorer to improve visibility and accessibility.
- Fixed an issue where the query tool returns “cannot unpack
non-iterable Response object” when running any query with a
database name change.
- Handle result grid data changes in View/Edit Data mode by
automatically reconnecting to the server if a disconnection
occurs.
- Implement API fetch error display for select dropdown.
- Fixed an issue where light theme briefly appears when pgAdmin
loads or tools open, even when a dark or system UI theme is
preferred.
- Fixed issues related to column range selection using
shift + click.
- Fixed an issue where pgAdmin failed to focus when previously
unfocused and then quit.
- update to 9.3:
* Supported Database Servers
- PostgreSQL: 13, 14, 15, 16 and 17
- EDB Advanced Server: 13, 14, 15, 16 and 17
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.2
* New features
- Add support for type constructors for PostGIS spatial types.
- Added ability to use SQL in the “DB Restriction” field.
- Add support for custom roles and role permissions management
in pgAdmin.
- Added support for font ligatures.
* Bug fixes
- Add Cache-Control no-cache,no-store,must-revalidate header to
dynamically generated utils.js file.
- Fixed an issue where shift + click on rows/columns for range
selection did not work in the query tool data output window.
- Fixed an issue where the debugger hangs when stepping into
nested function/procedure.
- Fixed an issue where the scroll position in the Object
Explorer was not retained when switching workspaces.
- Ensure that graph data is updated even when the Dashboard tab
is inactive.
- Fixed an issue where Ctrl/Cmd+A in cell editor would select
all rows.
- Fixed an issue where drag and drop function with no
parameters does not work.
- Fixed an issue where changes to foreign key constraints were
not detected in the schema diff.
- Change the shortcut for canceling a running query as it
conflicts with the shortcut to open a new query tool.
- Fixed an issue where filtering on a view caused an error.
- Fixed an issue where the query tool went blank when
converting history dates to the appropriate locale format.
- Ensure that the server list is alphabetically sorted in the
Query Tool/PSQL workspace.
- Fixed an issue where the user management tab is not opening
in the classic layout.
- Allow OAuth 2 login using the username claim if the email is
absent from the user profile.
- Rebase patches:
* package_deps.patch
* package_git_local.patch
- Update vendored packages.
* Fri Apr 11 2025 Antonio Larrosa <alarrosa@suse.com>
- Add patch to try to fix reproducible builds by disabling
webpack optimizations that seem to help with this:
* fix-reproducible-builds.patch
* Tue Apr 08 2025 Antonio Larrosa <alarrosa@suse.com>
- update to 9.2:
* supported database servers
- postgresql: 13, 14, 15, 16 and 17
- edb advanced server: 13, 14, 15, 16 and 17
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.2
* New features
- Added an ability to configure the font family for SQL
editors.
- Added support to automatically open a file after it is
downloaded in the desktop mode.
- Added support for post-connection SQL execution, which will
be run automatically on each connection made to any database
of the server.
- Add support for restoring plain SQL database dumps.
- Added support for creating Directory nodes in EPAS.
- Change icon buttons to show tooltip even when disabled.
- Add an option to load/replace the servers.json file on each
container startup.
- Open user management in a separate tab instead of a dialog to
enhance UI/UX.
* Housekeeping
- Added Security.md file.
* Bug fixes
- Ensure that modal dialogs are not triggered more than once to
avoid duplicates.
- Change session files garbage collection strategy.
- Fixed an issue where pgAdmin should fallback to main screen
if the last opened screen is disconnected.
- Fixed an issue where the PSQL terminal displays keyname for
non alphanumeric keys.
- Fixed an issue where geometries in the geometry viewer will
render partially when the container was resized.
- Change the stop/terminate icon at all the places for better
UX.
- Fixed an issue where the Schema Diff was not displaying the
difference query when a table had a UNIQUE NULLS NOT DISTINCT
constraint.
- Fixed an issue where the query tool data grid did not respect
the default value for columns of domain type when the domain
had a default value.
- Ensure the newly added parameters in the server dialog are
incorporated into the Import/Export Servers functionality.
- Fixed an issue where updating the grantee was not correctly
applying the privileges.
- Fixed an issue where the upgrade_check API returned an
unexpected keyword argument ‘cafile’ due to changes in the
urllib package supporting Python v3.13.
- Fixed an issue where delete/rename was done on wrong file
after sorting in Storage Manager.
- Fixed an XSS vulnerability issue in the Query Tool and
View/Edit Data (CVE-2025-2946, bsc#1240748).
- Fixed a remote code execution issue in the Query Tool and
Cloud Deployment (CVE-2025-2945, bsc#1240746).
- Fixed an issue where query tool is crashing on macOS 15.4 due
to a locale issue.
- update to 9.1:
* supported database servers
- postgresql: 13, 14, 15, 16 and 17
- edb advanced server: 13, 14, 15, 16 and 17
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.2
* New features
- Added an option to open the file in a new tab within the
query tool.
- Add support for one to one relationship in the ERD tool.
- Enable the ability to close the ‘Welcome’ tab in the Query
Tool/PSQL Workspace.
* Housekeeping
- Added support for Python 3.13
* Bug fixes
- Fixed an issue where pgAdmin does not support pg_vector
column length/precision.
- Fixed an issue where pasting text containing JSON data into
the query tool grid would result in incorrect parsing.
- Fixed an issue where the query tool was not treating IDENTITY
columns as columns with default values when inserting new
rows.
- Fixed an issue where the ERD tool fails to open a saved file
containing parent-child relationship within the same table.
- Fixed Docker image entrypoint.sh email validation.
- Fixed an issue where the User Management and Change Password
dialogs were hidden when selecting a menu while a workspace
other than ‘Default’ was active.
- Fixed an issue where the column order displayed was incorrect
for exclusion constraints with multiple columns.
- Ensure the saved passwords are decrypted with the correct
encryption key for external authentication in server mode.
- Fixed an issue where drop-down menus were hidden behind the
dock.
- Fixed an issue where deleting rows in the query tool would
delete all rows in the table when ‘Select All Remaining Rows’
was used.
- update to 9.0:
* supported database servers
- postgresql: 13, 14, 15, 16 and 17
- edb advanced server: 13, 14, 15, 16 and 17
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.0
* New features
- Change button labels and color in delete confirmation dialog
for all objects to improve UX.
- Enhanced pgAdmin 4 with support for Workspace layouts.
- Added the MAINTAIN privilege for PostgreSQL version 17 and
above.
- Add support for OAuth2 profile array response, which also
takes care of the GitHub Private Email ID issue.
* Housekeeping
- Show the python version used for the pgAdmin server in the
about dialog.
* Bug fixes
- Change the logic of setval function, so that the next nextval
of sequence will return exactly the specified value.
- Fixed an issue where pgadmin cannot install into 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 option key was not registering in PSQL
tool.
- Fixed an issue where Schema Diff not produce difference
script for Index definition with where condition.
- Correct the documentation for the MFA configuration.
- Fixed an issue where error message from the database server
need space between two sentences.
- Fixed an issue where query tool throws utf-8 decode error
when using cursor with binary data.
- Allow deleting the entry while creating/adding new label to
enumeration type.
- Fixed an issue where properties dialog throwing an error for
Materialized View.
- Fix a formatting issue in View/Edit tool generated SQL where
some filters are applied.
- Fixed an issue where tooltip on a dropdown button is blocking
access to dropdown menu.
- Fix the error occurring while loading preferences on startup.
- Fixed an issue where copying query tool output cell is not
working if any SQL text is selected.
- Ensure master password pop up is not shown on setting
MASTER_PASSWORD_REQUIRED to false.
- Remove the option “With no data (concurrently)” from Refresh
MATERIALIZED VIEW context menu.
- Fix an issue where wrong information is shown after using the
filter on the Dashboard> State tab.
- Fixed an issue where PSQL tool is not opening if database
name have HTML characters in the name.
- 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.
- update to 8.14:
* supported database servers
- postgresql: 12, 13, 14, 15, 16 and 17
- edb advanced server: 12, 13, 14, 15, 16 and 17
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.0
* New features
- Allow setting NULL ordering for columns in view/edit data
filter dialog.
- Show auto-complete column names in filtered rows dialog of
table and filter options of view/edit data tool.
- Allow the use of a pgpass file in the pgAdmin container via
Docker secrets.
- Fixed multiple issues and improved ERD auto-layout.
- Add support for passing connection details as placeholders in
the passexec command.
- Add support to deploy pgAdmin in a container with
readOnlyRootFilesystem to true.
- Added support for a builtin locale provider in the Database
dialog.
- Added support for adding tags on a server node.
* Bug fixes
- Fixed an issue where Ctrl/Cmd + A was not selecting all data
in query tool data grid.
- Fixed an issue where querying a foreign table gives the error
‘ForeignTableCommand’ object has no attribute ‘auto_commit’.
- Fixed an issue where indent with space was not aligning to
next tab position.
- Fixed an issue where pgAdmin crashes on accessing the
dashboard state tab when database is super busy.
- Fixed an issue related to the query tool update connection
after the server disconnected from the object explorer.
- Fixed an issue where a column name change in the edit dialog
of the table node does not show the updated column name.
- Fixed an issue where query tool should show results and
messages only from the last executed query.
- Fixed an issue where query tool throws syntax error if a
newly added row is untouched and saved.
- Ensure the crypt key is retrieved correctly on backend
server restart.
- Fixed an issue in schema diff where an error message popup
was showing some garbage without any info.
- Fixed an issue where query tool should not prompt for unsaved
changes when there are no changes.
- Add a user preference to enable/disable alternating row
background colors in the data output of query tool.
- Fixed an issue where doing Ctrl/Cmd+C on a selected text in a
cell editor of data output in the query tool copied the
complete text.
- Fixed an issue where auto-width of wide columns in data
output is incorrectly calculated.
- Ensure correct custom SSL certificate passed in connection
string.
- update to 8.13:
* supported database servers
- postgresql: 12, 13, 14, 15, 16 and 17
- edb advanced server: 12, 13, 14, 15 and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 17.0
* New features
- Replace infinite scrolling with pagination in query tool data
output for better UX and performance.
- Add an object menu option to disconnect all server and
database connections.
- Alternate the background color of rows to enhance
readability.
- Allow to pass PGADMIN_CONFIG_CONFIG_DATABASE_URI from docker
secrets.
- Format dashboard graph metrics for better readability.
- Added support for auto-detecting and setting the End-of-line
character (LF/CRLF) in the query tool editor.
- Make the background color for the serial number and header
cells distinct.
* Housekeeping
- Updated the react-menu library from v2 to v4.
- Remove bootstrap from the runtime code.
- Remove the dependency on python packages eventlet and
greenlet.
* Bug fixes
- Fixed an issue to allow the Enter key to save data in the
result grid text editor.
- Move ‘About pgAdmin 4’ to app menu on macOS.
- Fixed an issue where the query tool was crashing when an
empty geometry was being rendered.
- Fixed an issue where role properties were not loading.
- Fix multiple issues related to debugger params dialog input.
- Fixed an issue where the dock layout was not saved upon
closing a tab.
- Fixed an issue where the copy shortcut CTRL +C was not
working in the Query Tool data grid.
- Fixed an issue where Dashboard tab showing ‘Something went
wrong’.
- Fixed an issue where cursor selection is not visible in the
PSQL tool.
- Allow OAuth2 params OAUTH2_NAME, OAUTH2_DISPLAY_NAME,
OAUTH2_ICON, OAUTH2_BUTTON_COLOR to be optional.
- Add appropriate minimum width and height setting for desktop
apps to avoid app accidentally going below visibility levels.
- Fixed an issue where graphical explain keeps the node details
open even after plan changed.
- Fixed an issue in the debugger where function arguments of
the character data type were being truncated.
- Fix the issue where rows do not retain shading when
scrolling.
- Use PG17 as the default in the container.
- update to 8.12:
* supported database servers
- postgresql: 12, 13, 14, 15, 16 and 17
- edb advanced server: 12, 13, 14, 15 and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.4
* New features
- Added feature to restore preferences to their default values.
- Add a new config variable - ALLOW_SPECIAL_EMAIL_DOMAINS to
allow special domains for pgAdmin user emails.
- Allow running non-continuous selected SQL code blocks in the
query tool.
* Housekeeping
- Improved the extendability of the SchemaView and
DataGridView.
* Bug fixes
- Fix the query tool restore connection issue on the server
disconnection from the left side object explorer.
- Revamp the current password saving implementation to a
keyring and reduce repeated OS user password prompts.
- Fixed an issue where users could not use pgAdmin if they did
not have access to the management database.
- Fixed an issue where servers listed in the servers.json file
were being reimported upon container restart.
- Added support for OIDC based OAuth2 authentication.
- Fixed an issue where cursor moves to end of line when editing
input fields.
- Fixed an issue where “Quit App” confirmation modal in desktop
app is not respecting “Confirm on close or refresh?”.
- Fixed an issue where different client backend shows all SQL
are same.
- Fixed a security issue where the OAuth2 client ID and secret
exposed through the web browser (CVE-2024-9014).
- update to 8.11:
* supported database servers
- postgresql: 12, 13, 14, 15, 16 and 17
- edb advanced server: 12, 13, 14, 15 and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.3
* New features
- Add a home button to the geometry viewer to set original zoom
level when the viewer was opened.
* Housekeeping
- Upgrade react-data-grid fork to latest and change pgAdmin
accordingly.
- Introduce custom React Hook useSchemaState to simplify
SchemaView component.
* Bug fixes
- Fixed an issue where refreshing the Schema Diff tool opened
in a new tab caused an error.
- Fix server heartbeat logging error after deleting the server.
- Fixed an issue where the Generate Script ignored filter
conditions when a parent node was selected.
- Fixed an issue where delete object(shortcut key) affecting
both text and Object Explorer items.
- Fix an issue where ERD tool should to be able to open saved
pgerd file when using keyboard shortcuts.
- Updated the documentation for web server authentication.
- Fixed an issue where the REVOKE statement in the create
script was throwing an error if the role contained special
characters.
- Improve code highlighting in query editor.
- Fix an issue where the wheel package is not getting installed
on the arm64-based macOS version < 14.
- Fixed an issue where column resizing is not working in search
objects dialog.
- Fixed an issue where the value in the find box is not
updating with selected text in editor if find is already open
and re-triggered.
- Fixed paths for Flatpak broken after Electron changes.
- update to 8.10:
* supported database servers
- postgresql: 12, 13, 14, 15, 16 and 17
- edb advanced server: 12, 13, 14, 15 and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.3
* New features
- Add support for Postgres Server Logs for Text, CSV and JSON
format in plain and tabular formats. Upgrade React to
version 18.
- Add a keyboard shortcut to close active tab panel.
- Add support for highlighting selection matches in the query
editor.
* Housekeeping
- Replace pgAdmin NW.js container with Electron container.
- Updated to the latest version of the Notistack library.
- Ensure that pgAdmin 4 is compatible with PostgreSQL v17.
- Automatically apply virtualization in the DataGridView of
SchemaView if the schema contains only one collection.
- Add the git commit hash details to the About dialog.
* Bug fixes
- Fixed an issue where paste operation in query tool data grid
should skip bytea columns and put the value as NULL instead.
- Fixed an issue where the taskbar icon appeared as a red
square for the query tool and schema diff when opened in a
new window.
- Fix issue with missing new added records in download file.
- Fixed an issue where the File Open dialog did not show files
without a dot extension.
- Ensure pgAdmin never makes network requests to Google etc.
- Fixed an issue where pop-up notifications from Object
Explorer wouldn’t get dismissed automatically if the Query
Tool was opened.
- Fixed the permission denied issue for functions of the
pgstattuple extension when accessing statistics with a
non-admin user.
- Ensure processes related notifiers disappears.
- Updated entrypoint.sh to utilize the email-validator package
for email validation.
- Fixed an issue where users could not insert characters at the
desired location, as it was added to the end of the line.
- Fixed an issue where sorting the database activity table on
the dashboard by any column caused the details to expand in
the wrong position.
- Fix an issue where the preferences JSON file has no effect
when an external database is used.
- Fixed an issue where theme preview under theme options was
broken in pgAdmin server mode.
- Fixed an issue where users could not autofill their saved
passwords in the connect server dialog in the browser.
- Fixed an issue where Generate Script button should be
disabled if no objects are selected in the schema diff
result.
- Fixed an issue where ERD Open/Save shorcuts were not
working on Windows/Linux.
- Add a precautionary check for the query tool connection
cursor to fix the error ‘NoneType’ object has no attribute
‘_query’.
- Fixed an issue where boolean values in node details of
graphical explain plan were not interpreted correctly.
- Fixed an issue where Reassign/Drop Owned dialog not opening
for Role.
- Ensure pgadmin does not try to connect to the server if saved
password is not available.
- Ensure that pgAdmin works when opened in an iframe.
- update to 8.9:
* supported database servers
- postgresql: 12, 13, 14, 15 and 16
- edb advanced server: 12, 13, 14, 15 and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.3
* New features
- Provide option to set theme based on OS theme preference.
* Housekeeping
- Remove the usage of MUI makeStyles as it doesn’t support
React 18.
* Bug fixes
- Disable the query tool editor input if any SQL is being
loaded to prevent users from typing.
- Fixed an issue where resizable data editors in query tool
should not be allowed to resize beyond the app window bounds.
- Fixed new line indentation in query editor and add a user
preference to disable it.
- Ensure that a user can connect to a server using SSL
certificates and identity files from a shared storage.
- Fixed an issue where object explorer toolbar button not
showing shortcut in the tooltip.
- Add support for comments on RLS policy object.
- Fixed an issue where changing a column name should reflect in
all the constraints in table object dialog and ERD table
dialog.
- Fixed an issue where dark theme shows white background when
all tabs are closed.
- Ensure preferences can be loaded using preferences.json.
- Fixed an issue where the schema diff incorrectly marked
tables as different due to schema-qualified trigger functions
in the trigger definitions.
- Fixed an issue where backslash breaks syntax highlighting.
- Search Objects dialog should focus on search input on open.
- Fixed incorrect sorting of size in statistics tab.
- Fixed an issue where query tool shortcuts for find/replace
are not working.
- Fixed migration failure while using external database.
- Fixed an issue where query tool auto-complete stops working
after connection change.
- Fix the permissions issue in the pgAdmin installation
directory on Debian and RHEL-8 platforms (CVE-2024-6238).
- Fixed an issue where delete button in Users data was enabled
for incorrect rows.
- Rebase and update patches:
* package_deps.patch
* package_git_local.patch
- Bump dependencies versions
- Fix update-vendor.sh script to work with rpm 4.20.
- Replace the npx command from `npx eslint --no-eslintrc ...` to
`npx eslint --no-config-lookup ...`
* Mon Dec 09 2024 Steve Kowalik <steven.kowalik@suse.com>
- Switch {Build,}Requires on Flask-Security-Too back to Flask-Security.
* Mon Jun 17 2024 Antonio Larrosa <alarrosa@suse.com>
- update to 8.8:
* supported database servers
- postgresql: 12, 13, 14, 15, and 16
- edb advanced server: 12, 13, 14, 15, and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.3
* Bug fixes
- Fix an issue where user authentication fails with special
characters in password.
- Fixed an issue where canceling a query without privilege does
not display any message on query tool.
- Fix the issue where docker with SSL v8.7 fails to start.
- Fixed an issue where the size displayed as 'NaN B' for all
databases in the statistics tab.
- Fixed an issue where backup and restore operations failed
with the error 'This build does not support compression with
gzip'.
- update to 8.7:
* supported database servers
- postgresql: 12, 13, 14, 15, and 16
- edb advanced server: 12, 13, 14, 15, and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.3
* New features
- Added support for the 'Add to macros' feature and fixed
various usability issues.
- Added support for executing the query at the cursor position
in the query tool.
- Changes in Query Tool, Debugger, and ERD Tool shortcuts to
remove the use of Accesskey which will allow them to be
customized.
- Added support for viewing PGD Clusters.
- Enhance the Delete dialog by highlighting the names of the
objects to be deleted in bold.
- Added support for platform Ubuntu 24.04 and Fedora 40.
* Housekeeping
- Upgrade react-table from v7 to v8.
- Replace the current FontAwesome based PSQL tool icon with MUI
Terminal icon.
* Bug fixes
- Ensure that Schema Diff does not indicate a table as
different when the trigger names are the same but the trigger
function body is different.
- Disable ERD for system catalogs.
- Disable Debugger for system catalogs.
- Fixed an issue where drag and drop publication and
subscription name in SQL editors was not working.
- Fixed an issue of the pgAdmin window size increasing each
time it was reopened.
- Update the documentation for preferences dialog and keyboard
shortcuts.
- Fixed an issue where pgAdmin fails to start when Ubuntu OS is
upgraded to a major version.
- Remove query info notifier timeout field from Query Tool
Preferences Dialog.
- Fixed incorrect highlighting for C-Style escape strings in
SQL editor.
- Fixed an issue where the recover password button was enabled
even when no email was provided.
- Fixed an issue where resetting the password from the password
reset link was not working.
- update to 8.6:
* supported database servers
- postgresql: 12, 13, 14, 15, and 16
- edb advanced server: 12, 13, 14, 15, and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.1
* New features
- Added the new columns "last_seq_scan" and "last_idx_scan"
from the pg_stat_all_tables and pg_stat_all_indexes tables
respectively to the Statistics tab.
- Added support for excluding multiple tables while taking
Backup.
* Housekeeping
- Update UI library MUI from v4 to v5, more details here
- Upgraded Flask, Flask-Security-Too, Werkzeug, and other
dependencies, ensuring compatibility with Python 3.7.
* Bug fixes
- Fixed all input boxes in pgAdmin to show browser auto-fill
only where it is relevant.
- Install dbus-python, an in-direct dependency of the Keyring
package as a system package for Debian platforms.
- Fixed an issue where debugger was not scrolling automatically
on stepping.
- Fixed an XSS vulnerability in the /settings/store endpoint
(CVE-2024-4216, bsc#1223868).
- Fixed an issue where double dollar quoted code is treated as
string in syntax highlighter.
- Fixed an issue where pressing backspace should remove the
spaces and not the entire tab width, on enabling
'Use spaces?' in the preferences.
- Fixed an issue where incorrect select/exec scripts were
generated for functions/procedures.
- Fixed an issue where connection to the database is not
automatically re-established after connectivity drop.
- Fixed an issue when closing the view data second tab; it
raises the error that the 'ViewCommand' object has no
attribute 'auto_commit'.
- Fixed violates check constraint issue when creating a pgAgent
schedule.
- Fixed Multi-Factor Authentication bypass vulnerability
(CVE-2024-4215, bsc#1223867).
* Mon Apr 08 2024 Antonio Larrosa <alarrosa@suse.com>
- update to 8.5:
* supported database servers
- postgresql: 12, 13, 14, 15, and 16
- edb advanced server: 12, 13, 14, 15, and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.1
* New features
- Added support for provider, deterministic, version and RULES
parameter while creating collation.
- Added support for EDB Job Scheduler.
- Added support for viewing Log Based Clusters.
- Added support for UNIX socket in entrypoint.sh for Docker
implementation.
* Bug fixes
- Fixed an issue in Schema Diff where Columns with sequences
get altered unnecessarily.
- Fixed an issue where user was unable to share a newly
registered server.
- Bug fixes and improvements in pgAdmin CLI.
- Fixed an issue where the 'Save Password' option for SSH
tunneling password was consistently disabled.
- Fixed schema diff wrong query generation for table, foreign
table and sequence.
- Fixed an issue where table properties were not updating from
properties dialog.
- Fixed an issue where maximize icon is missing from query
tool panel.
- Fix an issue in table dialog where changing column name was
not syncing table constraints appropriately.
- Fixed rollback and commit button activation on execute
button click.
- Fixed an issue where taking backup of a shared server was
using server owner's user name.
- Fix an issue in editor where replace option in query tool
edit menu is not working on non-Mac OS.
- Fix an issue in editor where Format SQL shortcut and
multiline selection are not working.
- Fix an issue in editor where "Use Spaces?" Preference of
Editor is not working.
- Fixed an issue where Triggers, Rules, Indexes were absent
from the Schema Diff when comparing views.
- Fix an issue in query tool where toggle case of selected
text loses selection.
- Fix query tool autocomplete results when cursor is in
between the SQL query.
- Fix an issue in query tool where custom keyboard shortcuts
are not working for some.
- Fixed the issue where the update-user CLI command doesn't
change the password.
- Fixed issue related to email authentication of Two-factor
authentication.
- Fixed a remote code execution issue in the validate binary
path (boo#1222390, CVE-2024-3116).
- update to 8.4:
* supported database servers
- postgresql: 12, 13, 14, 15, and 16
- edb advanced server: 12, 13, 14, 15, and 16
* bundled postgresql utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.1
* New features
- Allow preferences customization using a configuration file.
- Add support for JSON log format.
- Add --yes option for skipping the confirmation prompt while
deleting the user via CLI for scripting purpose.
* Housekeeping
- Upgrade CodeMirror from version 5 to 6.
- Added documentation for Dashboard's System Statistics tab.
- Separate the application name, branding & version information
from the configuration file.
- Upgrade python packages cryptography to 42.0.x and
Flask-Security-Too to 5.3.x.
* Bug fixes
- Fix multiple issues where PasswordExecCommand was not working
in server mode and PasswordExecCommand was not loaded when
importing servers.
- Fix the tabbed panel backward/forward shortcut for tabs.
- Fixed an issue where dependencies and dependents were not
showing if a composite type is used as an attribute in
another composite type.
- Fix an issue where constraint check control is enabled in the
edit table dialog.
- Fix an issue where the scripts created by generate script of
Schema diff for Table with sequence was not working earlier.
- Ensure that the OAuth2 session is logged out when users log
out from pgAdmin.
- Remove role related checks on the UI dashboard when
terminating session/query and let PostgreSQL take care of it.
- Fix an issue where type column in dependents/dependencies tab
is not showing correct label.
- Unsafe Deserialization and Remote Code Execution by an
Authenticated user in pgAdmin 4 (boo#1221172, CVE-2024-2044).
- Replace the requirement for cryptography 42.0 to be satisfied
with 41.0 (which is the version we have in SLE) given that the
code using the cryptography module doesn't seem to really require
42.0 .
* Wed Feb 21 2024 Antonio Larrosa <alarrosa@suse.com>
- ExcludeArch: s390x
* Mon Feb 19 2024 Antonio Larrosa <alarrosa@suse.com>
- Update to 8.3:
* Supported Database Servers
- PostgreSQL: 12, 13, 14, 15, and 16
- EDB Advanced Server: 12, 13, 14, 15, and 16
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.0
* New features
- Allow drag-n-drop columns collection tree node as comma
separated columns.
- Added support to rename columns in Views.
- Added BYPASSRLS|NOBYPASSRLS option while creating a Role.
- Added support for column storage syntax while creating table.
- Use COOKIE_DEFAULT_PATH or SCRIPT_NAME in session cookie
path.
- Added configurable parameter to enable support for
PasswordExecCommand in server mode.
* Bug fixes
- Fixed an issue where format sql was messing up operator.
Included many other feature changes, more details here
- Fixed an issue where formatting inserts empty lines in
specific case.
- Add support for selecting a schema in the backup database
dialog with no tables, mviews, views or foreign tables.
- Fixed a UI border issue on the dependencies tab for columns
with icon.
- Fixed an issue where multiple errors were showing if user
does not have connect privileges.
- Fixed an issue where group membership information was
displayed incorrectly.
- Ensure that the correct SQL is generated when changing the
column data type to "char".
- Fixed an issue pgAdmin fails to launch due to inconsistent
PATH variable name on windows.
- Fix a backend server error when creating a named restore
point.
- Fix wrong default for FORCE_LOWER in the FLASK_GRAVATAR
module.
* Fri Feb 09 2024 Antonio Larrosa <alarrosa@suse.com>
- Add node_modules.spec.inc as Source to satisfy factory-auto.
* Thu Feb 08 2024 Antonio Larrosa <alarrosa@suse.com>
- Fix shebang of pgadmin4-desktop to use python3.11
* Tue Feb 06 2024 Antonio Larrosa <alarrosa@suse.com>
- New pgadmin4-cloud subpackage that includes now the cloud
dependencies and make the pgadmin4-cloud package optional so
it's now optional to depend on the azure/aws/google python
packages.
- Add patch to let pgadmin4 work without cloud support:
* make-cloud-packages-optional.patch
* Fri Feb 02 2024 Antonio Larrosa <alarrosa@suse.com>
- Add a optipng script that actually uses pngcrush to compress png
images so we don't depend on optipng which is not available in
SLE.
- Fix pgadmin4-desktop to use a timer instead of threads. It seems
there's an issue the way python threads were used with Qt5 that
made the script fail to update the systray menu when pgadmin was
started.
- Add missing python-typer dependency
- Add pgadmin4-user.conf file to create the pgadmin user/group
using systemd with the new system-user-pgadmin package.
* Mon Jan 29 2024 Adam Majer <adam.majer@suse.de>
- Replace yarn (which is not available in SLE) with
local-npm-registry.
- Add node_modules service and node_modules.obscpio /
node_modules.spec.inc source files which replace vendor.tar.xz
that is now removed.
- package_deps.patch - dependency fixes
- package_git_local.patch - dependency fixes that are needed *after*
generating package-lock.json since only registry-supplied packages
are available locally.
- Update update-vendor.sh script.
* Mon Jan 15 2024 Antonio Larrosa <alarrosa@suse.com>
- Update to 8.2
* Supported Database Servers
- PostgreSQL: 12, 13, 14, 15, and 16
- EDB Advanced Server: 12, 13, 14, 15, and 16
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.0
* New features
- Administer pgAdmin Users and Preferences Using the Command
Line Interface (CLI).
- Allow users to convert View/Edit table into a Query tool to
enable editing the SQL generated.
- Added copy server support, allowing the duplication of
existing servers with the option to make certain
modifications.
- Added keep-alive support for SSH sessions when connecting to
a PostgreSQL server via an SSH tunnel.
* Housekeeping
- Ensure that eventlet's subprocess should be used following
the resolution of an issue with Python 3.12 by eventlet.
* Bug fixes
- Fixed an issue where query tool title did not change after
"Save As" until any new change is made.
- Fixed an issue where export servers was not adding extension
if not specified.
- Fixed an issue where pgAdmin imports servers to the wrong
accounts for the external authentication.
- Fixed an issue where an error occurred in the SQL tab when
using an extended index(pgroonga).
- Fixed an issue where changes done to a node using edit
dialog are not reflecting on the properties tab if the
properties tab is active.
- Fixed an issue where DB Restrictions were not visible on
the server dialog.
- Ensure that the 'Dbo' schema is displayed as a regular
schema rather than a system catalog schema.
- Introduce LDAP configuration parameter
LDAP_IGNORE_MALFORMED_SCHEMA to ignore fetching schema from
the LDAP server.
- Fixed an error-'amname' when generating ERD for database
containing partition tables.
- Fixed an issue where object explorer last tree state was not
saving.
- Fixed an issue where pgAgent job schedule dialog is not
opening for edit.
- Fixed an issue where user is not able to cancel or terminate
active queries from dashboard.
- Fixed browser autocomplete related issues on pgAdmin
authentication related pages.
- Fixed an issue where auto commit/rollback setting not
persisting across query tool connection change.
- Fixed an issue where Schema Diff not generating difference
for missing columns.
- Update to 8.1
* Supported Database Servers
- PostgreSQL: 12, 13, 14, 15, and 16
- EDB Advanced Server: 12, 13, 14, 15, and 16
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.0
* New features
- Add support for generating ERD for a schema.
- Add support for creating a function with custom return type.
* Housekeeping
- Fixed several accessibility-related issues for enhanced
usability.
* Bug fixes
- Ensure focus is not changed to ssh tunnel password input when
user explicitly focus on server password input.
- Provide a way to bypass the SSL cert verification for OAuth2
provider.
- Fixed an issue where database name was missing in an error
message if name contains any special characters.
- Ensure that indexes created by constraints are visible in the
object explorer when "Show system objects" is enabled.
- Fixed an issue where reading process logs throws an error
when DATA_DIR is moved to a networked drive.
- Remove the 'Close Window' submenu specifically for OSX to
prevent unintended closure of the entire application.
- Rename all references of 'Execute query' to 'Execute script'
to be more relevant.
- Fixed an issue where syntax error was not highlighting in
query tool.
- Fixed an issue where on entering full screen, the option
label is not changed to 'Exit Full Screen' in desktop mode.
- Ensure that the Authentication Source in the drop-down of the
UserManagement dialog aligns with the entries specified for
AUTHENTICATION_SOURCES in the configuration file.
- Reverse engineer serial columns when generating ERD for
database/table.
- Fixed an issue where the Schema was not visible in the
dropdown for table properties or when creating a new table.
- Fixed an issue where option key was not registering in PSQL
tool.
- Fixed an issue where the Vacuum option INDEX_CLEANUP have an
incorrect value ('AUTO') for database versions < 14.
- Fixed an issue where the pgAdmin page went blank when
clicking the delete button in the User Management dialog.
- Ensure that correct timezone is set for Docker deployments.
- Fixed an issue where all rows and filter rows buttons of
object explorer toolbar were disabled for views and other
supported nodes.
- Fixed an issue where schema diff tool is not loading
preferences on start.
* Thu Nov 30 2023 Antonio Larrosa <alarrosa@suse.com>
- Changes in the spec file so it can be used in Factory as well as
in SLE
- Modify the pgadmin4-desktop helper to use PyQt5 instead of PyQt6
since the latter is not available in SLE
* Fri Nov 24 2023 Antonio Larrosa <alarrosa@suse.com>
- Update to 8.0
* Supported Database Servers
- PostgreSQL: 12, 13, 14, 15, and 16
- EDB Advanced Server: 12, 13, 14, 15, and 16
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.0
* New features
- Have close buttons on individual panel tabs instead of
common.
- Allow closing all the tabs, including SQL and Properties.
- Changes in the context menu on panel tabs - Add close,
close all and close others menu items.
* Housekeeping
- Update app bundle built to use notarytool instead of altool.
- Replace the current layout library wcDocker with ReactJS
based rc-dock.
- Upgrade Flask, Werkzeug and other modules depends on the
latest version of Flask.
* Bug fixes
- Fix an issue where the scroll position of panels was not
remembered on Firefox.
- Add DROP SQL for foreign keys in SQL generated by ERD when
using WITH DROP option.
- Fixed an issue where psql was not taking the role used to
connect in server properties.
- Fixed an issue where Geometry Viewer renders geometry
incorrectly after trying to view 3D or non-4326 SRID
geometry.
- Fix the sorting of size on the statistics panel.
- Fixed restoration of query tool database connection after
dropping and re-creating the database with the same name.
- Fix an issue where the default server-group is being deleted
if the load-server json file contains no servers.
- Fix an issue of the incorrect format (no indent) of SQL
stored functions/procedures.
- Server config information in the about dialog should be only
visible to admin users.
- Fixed an issue where Schema Diff does not work when the user
language is set to any language other than English in
Preferences.
- Fixed the query generated when creating subscription where
copy_data parameter was missing.
- Ensure backup/restore/maintenance works with invalid pgpass
file parameter.
- Fix an issue where OAUTH_ADDITIONAL_CLAIMS does not recognise
AzureAD with > 150 groups.
- Fixed circular import error occurring while deploying cloud
PostgreSQL instance from pgAdmin.
- Fix an issue where the browser window stuck on spinning with
an Oauth user without email.
- Fix an issue where import/export data is not working for
shared servers.
- Remove the max length of 255 from password exec command in
server configuration dialog.
- Remove gettext from empty strings in the title of the storage
graph.
- Fixed an issue where the change server password is not
working in desktop mode.
- Fix a crash issue occurring when debugging a function with
arguments when using pgAdmin with external config database.
- Fix an issue in ERD tool where SQL generated is missing
columns for the table.
- Clear the password field in the config database on clear
saved server password.
- Fixed an issue where the data type of the array type was not
visible for the column in the Foreign Table dialog.
- Drop patches that are not needed anymore:
* support-new-werkzeug.patch
* support-new-flask.patch
* Mon Oct 30 2023 Antonio Larrosa <alarrosa@suse.com>
- Add obsoletes: pgadmin4-web
* Wed Oct 25 2023 Antonio Larrosa <alarrosa@suse.com>
- Add a vendor.tar.xz source package with node modules that have to
be downloaded in the developer workstation since otherwise they
won't be able to get downloaded in the build service.
- Add an update-vendor.sh script that updates (actually, recreates)
the vendor.tar.xz package. This should be run manually with each
package update.
- Remove obsoleted file pgadmin4.qt.conf.in which hasn't been used
at all for some time.
- Add patch to set the environment variable EVENTLET_NO_GREENDNS
which fixes pgadmin4 to build successfully with eventlet 0.33.3,
httpcore 0.17.1 and httpx 0.24.0:
* fix-eventlet-select_epoll.patch
- Merged pgadmin4-web subpackage into the main pgadmin4 package
which now installs the pgAdmin4 server.
- Create new pgadmin4-desktop subpackage that includes a very small
python script I wrote that starts the pgadmin4 server in runtime
mode (as a regular user) and provides a system tray icon so users
can open new windows and quit the server with a UI since the
alternative (using the official pgAdmin4 runtime application
would require providing a full node.js modules tree and using
NW.js for the ui).
- Fix .desktop file which was now moved to the pgadmin4-desktop
subpackage. The "Encoding" key is deprecated so it has been
removed, only one main category is now used in the Categories
key and the path to the icon was fixed.
- Remove pgadmin4.qt.conf.in which is not used anymore
* Wed Oct 25 2023 Antonio Larrosa <alarrosa@suse.com>
- Update to 7.8
* Supported Database Servers
- PostgreSQL: 12, 13, 14, 15, and 16
- EDB Advanced Server: 12, 13, 14 and 15
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 16.0
* New features
- Add support for foreign table's new functionality for PG 11
and above.
- Allow setting custom username for shared servers, with
default as username of server being shared.
- Add 'GENERATED ALWAYS AS..' option while creating column
constraints for Foreign Table.
- GUI representation of the system's activity using the
'system_stats' extension.
- Added 'load_balance_hosts' connection string parameter
for PG 16 and above.
* Housekeeping
- Use PG16 as the default PostgreSQL version.
* Bug fixes
- Fixed an issue in ERD tool where the downloaded images
have a few links cut.
- Fixed an issue where user was not able to assign new/old
columns as primary key once column with primary key is
deleted.
- Add support for setting prepare threshold in server
connection.
- Fixed an issue where the wrong message "Current database
has been moved or renamed" is displayed when debugging any
function.
- Fixed an issue where Processes tab displays wrong server
name in some scenario.
- Fix an issue where global/native keyboard shortcuts are
not working when any cell of data output grid has focus.
- Fixed query history slowness issue by storing query only for
those having certain threshold max length.
- Fix an issue where foreign table column name becomes "none"
if the user changes any column data type.
- Pin the cryptography version to fix PyO3 modules
initialisation error.
- Ensure that the backup works properly for PG 16 on the latest
docker image.
- Fixed an issue where the user is unable to select objects on
the backup dialog due to tree flickering.
- Fixed an issue where non-super PostgreSQL users are not able
to terminate their own connections from dashboard.
- Fix an issue where scale in columns is not allowed to have
value as 0 or below.
- Fix an issue in graphical explain plan where query tool
crashes when the plan has parallel workers details and sort
node is clicked for details.
- Fix an issue where user login is not working if
username/email contains single quote in server mode.
- Update to 7.7
* Supported Database Servers
- PostgreSQL: 11, 12, 13, 14 and 15
- EDB Advanced Server: 11, 12, 13, 14 and 15
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 15.4
* New features
- Added support to select/deselect objects in the Backup
dialog.
- Added all the new options of the 'WITH' clause in the
subscription dialog.
- Added USING method while creating the table.
- Added compression method option while creating a column.
- Added Strategy, Locale Provider, ICU Locale, ICU Rules,
and OID options while creating a database.
- Added USING method while creating the materialized view.
- Add support for additional ID token claim checks for
OAuth 2 authentication.
* Housekeeping
- Added the ‘data type’ column in the properties tab of
the Columns collection node.
* Bug fixes
- Fix an issue where user is not able to change the
password when SMTP is not configured.
- Ensure user is redirected to login page after failed login.
- Ensure that Materialized view size fields in "Statistics"
should be human-readable.
- Fix an issue where changing the password shows success but
the new password is not working.
- Fix an issue where login form doesn't appear if internal
auth source is removed.
- Fix a security related issue where an authenticated user can
run remote command using validate binary path API
(CVE-2023-5002, boo#1215603).
* Fri Aug 25 2023 Simon Lees <simonf.lees@suse.com>
- Update to 7.6
- Features:
- Added Expression to CREATE INDEX.
- Added cascade option while creating an extension.
- Added ‘Ignore Grants’ option in the schema diff tool.
- Added ‘Ignore Tablespace’ option in the schema diff tool.
- Added support for ALTER INDEX column statistics.
- Added unlogged option while creating a sequence.
- Added all like options while creating a table.
- Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX.
- Added WAL option to EXPLAIN ANALYZE command.
- Added new/missing options to the VACUUM command.
- Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command.
- Add support for TRUNCATE trigger in foreign table.
- Ensure that Schema Diff comparison results should be displayed in the sorted order.
- Added support to detach partitions using concurrently and finalize.
- Added all supported index storage parameters while creating an index.
- Added new/missing parameters to pg_dumpall (Backup Server).
- Added new/missing parameters to pg_dump (Backup Objects).
- Added new/missing parameters to pg_restore.
- Housekeeping:
- Generate software bill of materials as part of the package builds.
- Added support for PostgreSQL and EPAS 16 to ensure it works without any errors.
- Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS.
- Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers.
- Clarify the LICENSE file to indicate that it is the PostgreSQL Licence.
- Remove unsupported PostgreSQL versions from the container.
- Bug fixes:
- Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file.
- Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool.
- Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external.
- Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live.
- Fix the issue where query tool window turns blank if the user tries to generate a graph on the result.
- Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation.
- Fix an issue where pgAdmin 7.5 fails to render table SQL with extension loaded index method.
- Fix an issue where cycle syntax was not added in SQL when creating new sequence from UI.
- Fix an issue where the SET directive is excluded from the function header in the schema diff tool.
- Fix a query tool error ‘pgAdminThread’ object has no attribute ‘native_id’.
- Ensure keyboard shortcut for query execution is disabled when query execution is in progress.
- Fix an issue where queries can’t complete execution.
- Fixed an issue where Import Export not working when using pgpassfile.
- Fix an issue where queries longer than 1 minute get stuck - Container 7.1
- Fix an issue where queries get stuck with auto-completion enabled.
- Fixed Query Tool/ PSQL tool tab title not getting updated on database rename.
- Ensure user gets proper error if incorrect credentials are entered while authenticating AWS.
- Fix an issue where the edit server fails in desktop mode if the server password is not stored.
- Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used.
- Fix the query tool auto-complete issue on the server reconnection.
- Fix the query tool restore connection issue.
- Fix the reconnecton issue if the PostgreSQL server is restarted from the backend.
- Fix the connection and stability issues since v7, possibly related to background schema changes.
- Fixed an issue where the query tool is unable to execute a query on Postgres 10 and below versions.
- Fix the lost connection error in v7.4.
- Fixed an issue where pgAdmin failed to setup role with hyphens in name.
- Fixed an issue where filters are not working and query history shows empty queries.
- Fix an issue where adding a sub-folder inside a folder is not working as expected in File Manager.
- Fix an error ‘list’ object has no attribute ‘strip’ while attempting to populate auto-complete manually the first time.
- Fixed an issue where ERD Tool can’t load the saved pgerd file from Shared Storage.
- Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table.
- Add support-new-flask.patch to fix build with flask 2.3
* Mon Jul 31 2023 Steve Kowalik <steven.kowalik@suse.com>
- Update to 7.4, extremely large list of changes, partially chosen:
* Make Statistics, Dependencies, Dependants tabs closable and the user
can add them back using the 'Add panel' option.
* Added support for Logical Replication.
* Implemented runtime using NWjs to open pgAdmin4 in a standalone window
instead of the system tray and web browser.
* Added Quick Search functionality for menu items and help articles.
* Added publication and subscription support in Schema Diff.
* Use cheroot as the default production server for pgAdmin4.
* Show the login roles that are members of a group role be shown when
examining a group role.
* Added '--replace' option in Import server to replace the list of
servers with the newly imported one.
* Added zoom scaling options with keyboard shortcuts in runtime.
* Use schema qualification while accessing the catalog objects.
* Make the 'Save Data Changes' icon to be more intuitive.
* Improve code coverage and API test cases for Server module.
* Added support to set auto width of columns by content size in the data
output window.
* Added support to connect PostgreSQL servers via Kerberos authentication.
* Added "IF NOT EXISTS" clause while creating tables and partition tables
which is convenient while using the ERD tool.
* Added browse button to select the binary path in the Preferences.
* Added Grant Wizard option under Package node.
* Added support to launch PSQL for the connected database server.
* Added window maximize/restore functionality for properties dialog.
* Added support to set the binary path for the different database server
versions.
* Added OS, Browser, Configuration details in the About dialog.
* Added support for rotating the pgAdmin log file on the basis of size
and age.
* Added RESQL/MSQL test cases for Table and its child nodes.
* Updated Flask-Security-Too to the latest v4.
* Added a mechanism to detect a corrupt/broken config database file.
* Highlighted long running queries on the dashboards.
* Added support for Reassign/Drop Owned for login roles.
* Do not block the query editor window when running a query.
* Added support for OAuth 2 authentication.
* Added option to provide maximum width of the column when 'Resize by
data?’ option in the preferences is set to True.
* Added support to copy SQL from main window to query tool.
* Added support for formatted JSON viewer/editor when interacting with
data in a JSON column.
* Rename the "Resize by data?" to "Columns sized by" and disabled the
'Maximum column width' button if 'Columns sized by' is set to
'Column data'.
* Added support for the truncate table with restart identity.
* Make code folding case insensitive in the code mirror.
* Added database and server information on the Maintenance process watcher
dialog.
* Allow the referenced table to be the same as the local table in one to
many relationship for ERD Tool.
* Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the
server mode.
* Added support for OWNED BY Clause for sequences.
* Revisit all the CREATE and DROP DDL's to add appropriate 'IF EXISTS',
'CASCADE' and 'CREATE OR REPLACE'.
* Added support for indent guides in the browser tree.
* Added support for advanced table fields like the foreign key, primary key in the ERD tool.
* Added support to allow tables to be dragged to ERD Tool.
* Added index creation when generating SQL in the ERD tool.
* Added support for authentication via the webserver (REMOTE_USER).
* Added support to enable/disable rules.
* Added support of Aggregate and Operator node in view-only mode.
* Ensure that users should be able to modify the REMOTE_USER environment
variable as per their environment by introducing the new config
parameter WEBSERVER_REMOTE_USER.
* Added support for Two-factor authentication for improving security.
* Added support to disable the auto-discovery of the database servers.
* Replace Flask-BabelEx with Flask-Babel.
* Upgrade Flask to version 2.
* Added support to import/export server groups and servers from GUI.
* Added support to open SQL help, Dialog help, and online help in an
external web browser.
* Rename the menu 'Disconnect Server' to 'Disconnect from server'.
* Added capability to deploy PostgreSQL servers on Amazon RDS.
* Rename the menu 'Disconnect Database' to 'Disconnect from database'.
* Added transaction start time to Server activity sessions view.
* Added support for unique keys in ERD.
* Added status bar to the Query Tool.
* Ensure that row numbers should be visible in view when scrolling
horizontally.
* Relocate GIS Viewer Button to the Left Side of the Results Table.
* Added capability to deploy PostgreSQL servers on EDB BigAnimal.
* Added options 'Ignore owner' and 'Ignore whitespace' to the schema diff
panel.
* Added support for Azure AD OAUTH2 authentication.
* Ensure the database and schema restriction controls are not shown as a
drop-down.
* Added the ability to resize columns on dashboard tables.
* PG 15 compatibility issues fixed.
* Added capability to deploy PostgreSQL servers on Microsoft Azure.
* Added support for visualise the graph using a Line chart in the query tool.
* Added option to trigger autocomplete on key press in the query tool.
* Allow users to delete files/folders from the storage manager.
* Allow users to search within the file/storage manager.
* Added support for visualizing the graphs using Stacked Line, Bar, and
Stacked Bar charts in the query tool.
* Added support for visualise the graph using a Pie chart in the query tool.
* Removing dynamic module loading and replacing it with static loading.
* Added support to show all background processes in separate panel.
* Added support to create triggers from existing trigger functions in EPAS.
* Remove the SQL files for the unsupported versions of the database server.
* Fixed improper parsing of HTTP requests in Pallets Werkzeug v2.1.0
and below (CVE-2022-29361).
- Included in 6.19: Fix a vulnerability that allows a user of the
product to change another user's settings or alter the database
(bsc#1207464, CVE-2023-0241).
- Included in 6.14: Fix a vulnerability that allows a remote
unauthenticated user to redirect a user to an arbitrary web site
by crafting a malicious URL (boo#1207238, CVE-2023-22298).
- Included in 6.7: Fix for unrestricted file upload (boo#1197143,
CVE-2022-0959).
- Included in 6.5: Fixed an issue when uploading a CSV throwing an
error in the Desktop mode
- Drop patches remove_simplejson_dep.patch, fix-python-lib.patch and
0001-Fix-bug-ValueError-unsupported-format-character-D.patch
- Add patch support-new-werkzeug.patch and support-new-azure-mgmt-rdbms.patch:
* Support changes among our dependencies.
* Sat Feb 11 2023 Matej Cepl <mcepl@suse.com>
- Remove dependency on python-simplejson
(gh#pgadmin-org/pgadmin4#5853).
/usr/bin/pgadmin4-desktop /usr/share/applications/pgadmin4.desktop /usr/share/icons/hicolor/256x256/apps/pgadmin4.png
Generated by rpm2html 1.8.1
Fabrice Bellet, Thu Oct 23 22:37:43 2025