| 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: 8.5 | Vendor: openSUSE |
| Release: 1.1 | Build date: Mon Apr 8 11:08:22 2024 |
| Group: Productivity/Networking/Web/Utilities | Build host: reproducible |
| Size: 31604 | Source RPM: pgadmin4-8.5-1.1.src.rpm |
| Packager: https://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
* 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).
* Wed Jun 09 2021 Ralf Habacker <ralf.habacker@freenet.de>
- Add 0001-Fix-bug-ValueError-unsupported-format-character-D.patch
to fix bug reported at https://redmine.postgresql.org/issues/6522
* Tue Feb 02 2021 Antonio Larrosa <alarrosa@suse.com>
- 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)
* Mon Feb 01 2021 Marcus Rueckert <mrueckert@suse.de>
- the system wide service does not need to run as root. switch to
user/group pgadmin
* Sat Jan 30 2021 Marcus Rueckert <mrueckert@suse.de>
- 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
of a tooltip when clicking on plan nodes.
- Ensure that verbose logs are visible for Utility (Backup,
Maintenance etc.) jobs.
- Added support for expressions in exclusion constraints.
- Ensure that the 'template1' database is not visible after
pg_upgrade.
- Added appropriate help message and a placeholder for letting
users know about the account password expiry for Login/Group
Role.
- Updated Flask-BabelEx to the latest version.
- Fixed extra parentheses issue around joins for Views.
- Ensure that the current value of sequences is ignored while
comparing using Schema Diff.
- Fixed an issue when the user tries to delete multiple records
in the data grid.
- Fixed TypeError exception in schema diff when selecting two
identical objects.
- Include PostgreSQL 13 utilities in the container
distribution.
https://www.pgadmin.org/docs/pgadmin4/4.30/release_notes_4_30.html
* Wed Jan 27 2021 Antonio Larrosa <alarrosa@suse.com>
- 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
* Wed Jan 27 2021 Antonio Larrosa <alarrosa@suse.com>
- Add BuildRequires for python-cryptography and replace dependency for
python-Flask-Babel with python-Flask-BabelEx
/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, Mon Apr 29 23:22:28 2024