baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

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

• Files Changed
• Browse Source

- Add node_modules.spec.inc as Source to satisfy factory-auto.

• Files Changed
• Browse Source

- 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.

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Add obsoletes: pgadmin4-web

• Files Changed
• Browse Source

• Files Changed
• Browse Source

- Remove pgadmin4.qt.conf.in which is not used anymore

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source