* Supported Database Servers
- PostgreSQL: 13, 14, 15, 16, 17 and 18
- EDB Advanced Server: 13, 14, 15, 16, 17 and 18
* Bundled PostgreSQL Utilities
- psql, pg_dump, pg_dumpall, pg_restore: 18.0
* New features
- Add support of DEPENDS/NO DEPENDS ON EXTENSION for INDEX.
- Add support of DEPENDS/NO DEPENDS ON EXTENSION for
MATERIALIZED VIEW.
- Add support for showing the column data type beside column
name in the object explorer.
- Added Ubuntu 25.10 and Fedora 43
- Add conditional TLS support for the Ingress in the Helm
chart.
* Bug fixes
- Fixed an issue on type casting of default string
function/procedure arguments in debugger tool.
- Fix pkg_resources deprecation warning by migrating Docker
base image to python:3-alpine from alpine:latest.
- Fixed an issue where EXPLAIN should run on query under
cursor if no text is selected.
- Fixed an issue where opening file in Query Tool does not
retain file name in tab.
- Fixed an issue where connection is failing via Query
Tool/PSQL Tool workspaces.
- Plain SQL restore runs with ‘restrict’ option to prevent
harmful psql meta-commands (CVE-2025-13780).
- Fixed an issue where copying highlighted text in the query
tool data output cell editor would copy the complete string.
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=83
* 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
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=80
* 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
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=77
- 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
OBS-URL: https://build.opensuse.org/request/show/1181284
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=73
- 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
OBS-URL: https://build.opensuse.org/request/show/1166131
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=71
- ExcludeArch: s390x
- 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
OBS-URL: https://build.opensuse.org/request/show/1148813
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=69
Add bug/CVE references
- 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
OBS-URL: https://build.opensuse.org/request/show/1145378
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=67
- Fix shebang of pgadmin4-desktop to use python3.11
- 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
- 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.
- 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.
OBS-URL: https://build.opensuse.org/request/show/1145351
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=65
- 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
OBS-URL: https://build.opensuse.org/request/show/1138820
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=64
- 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
OBS-URL: https://build.opensuse.org/request/show/1129089
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=62
- 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.
- Update to 7.8
* Supported Database Servers
- PostgreSQL: 12, 13, 14, 15, and 16
- EDB Advanced Server: 12, 13, 14 and 15
OBS-URL: https://build.opensuse.org/request/show/1120781
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=57
- 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
OBS-URL: https://build.opensuse.org/request/show/1105897
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=55
- 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
OBS-URL: https://build.opensuse.org/request/show/1101479
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=53
- Fix typos (chmod being used instead of chown in %postun web and
pgadmin4 used in the service file for User/Group keys instead of
pgadmin)
- the system wide service does not need to run as root. switch to
user/group pgadmin
- Update to 4.30
- Features:
- ERD Tool (Beta): The Entity-Relationship Diagram (ERD) tool
is a database design tool that provides a graphical
representation of database tables, columns, and
inter-relationships. You can use the ERD tool to design a new
schema and generate the SQL required to create it, or to
reverse engineer and diagram an existing database schema.
- Kerberos support is added in pgAdmin 4 using SPNEGO for
logging into pgAdmin, similar to the existing LDAP and
"internal" options. Note that support for logging into
database servers using Kerberos is not included in this
release, but will be added in a future version.
- Add a container option (PGADMIN_DISABLE_POSTFIX) to disable
the Postfix server: Postfix (like other MTAs) must start as
user 'root', and the pgAdmin container achieves this using
'sudo'. Whilst that works well in most environments, it can
cause problems in some. This option allows you to completely
disable Postfix to avoid these issues, though you will need
to configure an external mail server to be used to send
password reset emails.
- Bugs/Housekeeping:
- Improve the explain plan details by showing a popup instead
OBS-URL: https://build.opensuse.org/request/show/870250
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/pgadmin4?expand=0&rev=19
- Fix the desktop application by removing the overriding of
SERVER_MODE in config_system.py and config_distro.py which were
forcing SERVER_MODE to always have a specific value instead
of letting the runtime choose so there's no need to force it.
- Rename pgadmin4.conf to pgadmin4.conf.in,
pgadmin4.uwsgi to pgadmin4.uwsgi.in and
README.SUSE.uwsgi to README.SUSE.uwsgi.in and make them also
replace PYTHONSITELIB with the python version used at build time
- Replace all variables from config files in %prep instead of
%install
- Include README.SUSE.uwsgi in the web-uwsgi subpackage
- Add BuildRequires for python-cryptography and replace dependency for
python-Flask-Babel with python-Flask-BabelEx
- Ensure that folder rename should work properly in Storage
OBS-URL: https://build.opensuse.org/request/show/867484
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=45
- Update to 4.29:
- Ensure that folder rename should work properly in Storage
Manager
- Fixed an issue where the debugger's custom tab title not
applied when opened in the new browser tab
- Fixed an issue where dynamic tab title has not applied the
first time for debugger panel
- Fixed an issue where schema diff doesn't show the result of
compare if source schema has tables with RLS
- Fixed an issue where the process watcher dialog throws an error
for the database server which is already removed
- Ensure that code coverage should cover class and function
declarations
- Ensure that dirty indicator (*) should not be visible when
renaming the tabs
- Fixed an issue where shared servers import is failing
- Improve code coverage and API test cases for Foreign Tables,
Debugger, Views and Materialized Views
- Fix some requirement versions.
OBS-URL: https://build.opensuse.org/request/show/854776
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=41
- Added support to download utility files at the client-side.
- Added support to rename query tool and debugger tabs title.
- Added support for dynamic tab size.
- Added tab title placeholder for Query Tool, View/Edit Data, and
Debugger.
- Added support to compare schemas and databases in schema diff.
- Ensure that non-superuser should be able to debug the function.
- Ensure that query history should be listed by date/time in
descending order.
- Ensure that Grant Wizard should include foreign tables.
- Ensure that search object functionality works with case
insensitive string.
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=40
- Update to 4.27:
- Added Macro support.
- Added support to view trigger function under the respective
trigger node.
- Allow user to change the database connection from an open query
tool tab.
- Added support to ignore the owner while comparing objects in
the Schema Diff tool.
- Merged the latest code of 'pgcli' used for the autocomplete
feature.
- Fixed invalid literal issue when fetching dependencies for
Materialized View.
- Fixed an issue where schema diff is showing identical table as
different due to default vacuum settings.
- Ensure that the user should be able to change the start value
of the existing sequence.
- Fixed an issue where the query tool is not fetching more than
1000 rows for the table does not have any primary key.
- Fixed an issue where 'Rows X' column values were not visible
properly for Explain Analyze in Dark theme.
- Fixed an issue where file extension is stripped on renaming a
file.
OBS-URL: https://build.opensuse.org/request/show/842283
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=38
