Changelog for system-user-pgadmin-8.5-1.1.noarch.rpm :

* Mon Apr 08 2024 Antonio Larrosa - 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 - ExcludeArch: s390x
* Mon Feb 19 2024 Antonio Larrosa - 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 - Add node_modules.spec.inc as Source to satisfy factory-auto.
* Thu Feb 08 2024 Antonio Larrosa - Fix shebang of pgadmin4-desktop to use python3.11
* Tue Feb 06 2024 Antonio Larrosa - 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 - 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 - 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 - 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 - 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 - 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 - Add obsoletes: pgadmin4-web
* Wed Oct 25 2023 Antonio Larrosa - 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 - 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 - 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 - 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 - Remove dependency on python-simplejson (gh#pgadmin-org/pgadmin4#5853).
* Wed Jun 09 2021 Ralf Habacker - 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 - 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 - the system wide service does not need to run as root. switch to user/group pgadmin
* Sat Jan 30 2021 Marcus Rueckert - 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 - 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 - Add BuildRequires for python-cryptography and replace dependency for python-Flask-Babel with python-Flask-BabelEx