- 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
- Added SQL Formatter support in Query Tool.
- Added a new button to the query tool toolbar to open a new
query tool window.
- Added shared server support for admin users.
- Warn the user when connecting to a server that is older than
pgAdmin supports.
- Ensure that schema names starting with 'pg' should be visible
in browser tree when standard_conforming_strings is set to off.
- Fixed an issue where --load-server does not allow loading
connections that use pg_services.
- Fixed string indices must be integers issue for PostgreSQL <
9.3.
- Fixed an issue where the application ignores the fixed port
configuration value.
- Remove illegal argument from trigger function in trigger DDL
statement.
- Ensure that 'setup-web.sh' should work in Debian 10.
- Fixed excessive CPU usage by stopping the indefinite growth of
the graph dataset.
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=34
- Create a pgadmin user and group
- Add uwsgi configuration (fast, user privileges and apparmor support)
- Only activate the pgadmin4 apache config if the PGADMIN4 flag is set.
For mod_wsgi you should use `a2enmod wsgi`
- Create /etc/pgadmin/config_system.py with server mode for web
Run /usr/lib/python3.6/site-packages/pgadmin4-web/setup.py to create
the admin user
- Remove config_local.py with outdated options
OBS-URL: https://build.opensuse.org/request/show/833841
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=33
- Update to 4.25:
- Modified schema diff tool to compare two databases instead of
two schemas
- Resolve schema diff dependencies by selecting the appropriate
node automatically and maintain the order in the
generated script.
- Replace charting library Flotr2 with ChartJS using React.
- Upgrade font-awesome from v4 to v5.
- Fixed an issue where debugger doesn't work if the search path
is set other than 'public'.
- Fixed ssh tunnel hang issue when the user tries to disconnect
the server.
- Fixed an issue where conversion of bytea to the binary string
results in an error.
- Fixed an issue where the entire logs are in red text when the
user runs backup and restore.
- Ensure that the user will be able to modify the start value
of the Identity column.
- Fixed an issue where 'ALTER VIEW' statement is missing when
the user sets the default value of a column for View.
OBS-URL: https://build.opensuse.org/request/show/832795
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=32
- Update to 4.22
- New features
* Added connected pgAdmin user and connection name in the log file.
* Show the startup log as well as the server log in the runtime's log
viewer.
- Bugfixes
* Gracefully informed the user that the database is already connected when
they click on "Connect Database...".
....
- Packaging:
* refresh fix-python-lib.patch
* add keyring e8697e2eef76c02d3a6332778881b2a8210976f2 enabling
GPG source tarballs verification
old: server:database:postgresql/pgadmin4
new: home:mvyskocil:branches:server:database:postgresql/pgadmin4 rev None
Index: fix-python-lib.patch
===================================================================
--- fix-python-lib.patch (revision 28)
+++ fix-python-lib.patch (revision 2)
@@ -5,32 +5,29 @@
we have to add it ourselves. Use an environment variable (just as in the Windows case)
to find out the library version to link to.
-Index: pgadmin4-4.19/runtime/pgAdmin4.pro
+Index: pgadmin4-4.22/runtime/pgAdmin4.pro
===================================================================
---- pgadmin4-4.19.orig/runtime/pgAdmin4.pro
-+++ pgadmin4-4.19/runtime/pgAdmin4.pro
-@@ -55,6 +55,7 @@ else {
- # Find and configure Python
- # Environment setting
- PYTHON_CONFIG = $$(PYTHON_CONFIG)
-+ PYTHON_VERSION = $$(PYTHON_VERSION)
-
- # Python 2?
- isEmpty(PYTHON_CONFIG) {
-@@ -71,11 +72,15 @@ else {
- error(The python-config executable could not be found. Ensure Python is installed and in the system path.)
+--- pgadmin4-4.22/runtime/pgAdmin4.pro.orig 2020-06-15 09:57:31.503298807 +0200
++++ pgadmin4-4.22/runtime/pgAdmin4.pro 2020-06-15 10:02:06.335072806 +0200
+@@ -78,6 +78,12 @@
+ } else {
+ error(No suitable python-config could be found in $${PYTHON_DIR}/bin.)
}
-
++
++ PYTHON_VERSION = $$(PYTHON_VERSION)
+ isEmpty(PYTHON_VERSION) {
+ error(Please set the PYTHON_VERSION environment variable to the version of python to link to.)
+ }
+
- message(Using $$PYTHON_CONFIG)
+ message(Python config: $$PYTHON_CONFIG)
- QMAKE_CXXFLAGS += $$system($$PYTHON_CONFIG --includes)
+ PYTHON_EMBED = $$system($$PYTHON_CONFIG --help 2>&1 | grep -o \'\\-\\-embed\')
+@@ -88,7 +94,7 @@
QMAKE_LFLAGS += $$system($$PYTHON_CONFIG --ldflags)
-- LIBS += $$system($$PYTHON_CONFIG --libs)
-+ LIBS += $$system($$PYTHON_CONFIG --libs) -lpython$$PYTHON_VERSION
+ message(LDFLAGS: $$QMAKE_LFLAGS)
+
+- LIBS += $$system($$PYTHON_CONFIG --libs $$PYTHON_EMBED)
++ LIBS += $$system($$PYTHON_CONFIG --libs $$PYTHON_EMBED) -lpython$$PYTHON_VERSION
+ message(LIBS: $$LIBS)
+ }
- contains( LIBS, -lpython2.* ) {
- DEFINES += PYTHON2
Index: pgadmin4.changes
===================================================================
--- pgadmin4.changes (revision 28)
+++ pgadmin4.changes (revision 2)
@@ -1,4 +1,57 @@
-------------------------------------------------------------------
+Mon Jun 15 08:10:53 UTC 2020 - Michal Vyskocil <mvyskocil@opensuse.org>
+
+- Update to 4.22
+ - New features
+ * Added connected pgAdmin user and connection name in the log file.
+ * Show the startup log as well as the server log in the runtime's log
+ viewer.
+ - Bugfixes
+ * Gracefully informed the user that the database is already connected when
+ they click on "Connect Database...".
+ * Fixed an issue where clicking on the cross button of the alert box on
+ the login page is not working.
+ * Fixed the SQL help issue for EDB Postgres Advanced Server.
+ * Ensure that maintenance job should be worked properly for indexes under
+ a materialized view.
+ * Ensure that file browse "home" button should point to $HOME rather than /.
+ * Ensure that 'With OID' option should be disabled while taking backup of
+ database server version 12 and above.
+ * Fixed invalid literal issue when removing the connection limit for the
+ existing role.
+ * Fixed internal server error when clicking on Triggers -> 'Enable All'
+ for partitions.
+ * Fixed generated SQL issue for auto vacuum options.
+ * Ensure that the dependencies tab shows correct information for Synonyms.
+ * Fixed an issue where the newly added table is not alphabetically added
+ to the tree.
+ * Fixed list sorting issue in the schema diff tool.
+ * Fixed an issue while comparing the two identical schemas using the
+ schema diff tool.
+ * Fixed an issue when renaming the column not added in the proper order.
+ * Correct ipv4 "all interfaces" address in the container docs, per Frank
+ Limpert.
+ * Fixed an issue where select2 hover is inconsistent for the SSL field in
+ create server dialog.
+ * Fixed post-login redirect location when running in server mode under a
+ non-default root.
+ * Fixed an issue where the background job creation fails if there is only
+ a version-specific python binary available in PATH.
+ * Fixed data truncation issue when updating the data of type character
+ with length.
+ * Fixed an issue where if LDAP_SEARCH_BASE_DN is not set then, the value
+ for LDAP_BASE_DN will be considered.
+ * Fixed an issue where clicking on Select All button, not selecting all
+ the options in pgAgent job scheduler.
+ * Clarify and correct the docs on enabling the pl/debugger plugin on the
+ server.
+ * Fixed Unicode decode error 'utf-8' codec can't decode byte.
+- Packaging:
+ * refresh fix-python-lib.patch
+ * add keyring e8697e2eef76c02d3a6332778881b2a8210976f2 enabling
+ GPG source tarballs verification
+
+-------------------------------------------------------------------
Thu May 14 16:25:22 UTC 2020 - Antonio Larrosa <alarrosa@suse.com>
- Decrease requirements to build in SLE/Leap:
Index: pgadmin4.spec
===================================================================
--- pgadmin4.spec (revision 28)
+++ pgadmin4.spec (revision 2)
@@ -18,13 +18,16 @@
%global pgadmin4instdir %{_libdir}/pgadmin4-%{version}
Name: pgadmin4
-Version: 4.21
+Version: 4.22
Release: 0
Summary: Management tool for PostgreSQL
License: PostgreSQL
Group: Productivity/Databases/Tools
URL: http://www.pgadmin.org
Source0: https://download.postgresql.org/pub/pgadmin/%{name}/v%{version}/source/%{name}-%{version}.tar.gz
+Source10: https://download.postgresql.org/pub/pgadmin/%{name}/v%{version}/source/%{name}-%{version}.tar.gz.asc
+# https://www.pgadmin.org/download/pgadmin-4-source-code/
+Source11: %{name}.keyring
Source1: %{name}.conf
Source2: %{name}.service.in
Source3: %{name}.tmpfiles.d
@@ -142,6 +145,7 @@
cd runtime
export PYTHON_CONFIG=%{_bindir}/python3-config
export PYTHON_VERSION=%{python3_version}
+export PGADMIN_PYTHON_DIR=%{_prefix}
export CFLAGS=%{RPM_OPT_FLAGS}
qmake-qt5 -o Makefile pgAdmin4.pro
make %{?_smp_mflags} VERBOSE=1
Index: pgadmin4-4.22.tar.gz
===================================================================
Binary file pgadmin4-4.22.tar.gz (revision 2) added
Index: pgadmin4-4.22.tar.gz.asc
===================================================================
--- pgadmin4-4.22.tar.gz.asc (added)
+++ pgadmin4-4.22.tar.gz.asc (revision 2)
@@ -0,0 +1,16 @@
+-----BEGIN PGP SIGNATURE-----
+
+iQIcBAABAgAGBQJey8TRAAoJEIiBsqghCXbyv58P/2cfBzUq4py2IvV2X4Q9+NSN
+3iVZpBXap+xZoeKftG8H3b8GIZdhudLBW1TEGgCuH/CCKn3a7mVWPhPob/qSm+FM
+szngB+x92IA4JRG6N5KYnt+krDcSNgVF762TMPyZ9mSd1Wwoxiu+2zB6QB4p5H7y
+ufevNzCHUANs+NfpPP4e/EnJJHGZdhuqgcMclprFahwCw4V3ZZ9bCC1My/p9FvpH
+yOiUcxh6vUxNRaHmiV/3vQ8/FEvYJxzqzRdpFjEqhHBhIKw0CB3prLysW5J0e6yu
+EZmo0HeaGMLUgbxcbwBy+Ye+uh3wlYTLNiYu9ddJScInZuFbPAt659aHBZTgi5PH
+XAEEhF5aUpm8aoy7zPluKiRhg19DI7k1GN2hqGDQKvIrl6dGLMjELdHyggr/5Ow7
+gv2ZT9A5DebczG14+fDf6XgDswvLn+U7Hsp4BLql6k2eK7qLoC9ORCETOR0LMVWa
+ftIGCDdtCpmH8wLEdjt7yl/i6rHxwBl5rHky1Syrmdef/q1qT9qTc8XfPcfql9Qn
+n2pwFl1LeqKx4C2shZiuZ0QDpWg0KbQlgxpou6QUGXyi9Ks+SEjaJUiAnZkQ1udB
+MkNX3VahVwm+SSWVvhSKwPgjofLPdq/95wOSAdSYUuls4cXog9Uj8eksW9qxf6y/
+Zjss+fY0SCjpqhnlH+eM
+=88O2
+-----END PGP SIGNATURE-----
Index: pgadmin4.keyring
===================================================================
--- pgadmin4.keyring (added)
+++ pgadmin4.keyring (revision 2)
@@ -0,0 +1,52 @@
+-----BEGIN PGP PUBLIC KEY BLOCK-----
+
+mQINBFtyz58BEACgKbtY59R0mxs8rWJNAn1BWNXwhuTvELNCV6gZkMRGFP14tMop
+d9VcUx5UWiulT5wysji63xhkNljmE90jJdlxZwZ+XtnmLzIqp6i29EkAIUt1AoxM
+w2ipMhfuwE6WA6VYxQihu5z2IDOR1PdDUHF5cX/GZgBon/2A33rG5IKTcaNZzL0O
+c3rS5VzOzwnp1FHPlR7PY7BRDNe8q1MrQq14tlgMTaYziNg2t2YwjuhNV6G33qGE
+h390aUnO/eMWIPJzKoi4mE5mhEbh4L/7sFlcRUC6Vs1xa5Ab+L5y2xoDe2grraKD
+u+XpGJaDPLunlhDSTUsp0HsoLVU4ne/HNbCAm2b25tKFcFTUwDH4Ekge1/bQLCvx
+kB63MMLa/FgsJ0XAr8zKEQFrc89qJU4JuvadL4hAIqZ1ywFlwTOBaNfZHbW2Pt5f
+prktIL5d5jIHAdQrFPvLqhhjhM03de6O6dS5lDeP8dTdqzMcqBkwFMmjZMeRAcoJ
+vs0jJNc0fYwL3h2JSWQnIhsvcSe6gk8GFVRbCCy9UplK1K/5TWw+y3mtfWwUCUSW
+nBIuUTV+5iG21o3rdZgfEjXJtBAWW/hKoVwBTe5Ir9yIqaomG5ul0Sn2EgOravns
+AWe2nk4l9cno5CPhGunEtiOD8YQJHskk7/NMtnPegB5j4tprXGS/cK/5hQARAQAB
+tDxQYWNrYWdlIE1hbmFnZXIgKFBhY2thZ2UgU2lnbmluZyBLZXkpIDxwYWNrYWdl
+c0BwZ2FkbWluLm9yZz6JAk4EEwEKADgWIQToaX4u73bALTpjMneIgbKoIQl28gUC
+W3LPnwIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRCIgbKoIQl28ukfD/4y
+3gGysVSJU1964mpi/4NtSTruQ+fx8rN1vY/cctdQVr1ltuJsDRyPgGpXIh9zeK0/
+bkCreCcuGezm2WOUFR6Kf54zMWWbIrAPpbib7rYi8n50jz7SkCfSyJZgqO2bAPBU
+MP6Y09mdLaB4jib9Y6nDhFgm2V0rO64yX/bznVjBzNXFjCTgbPoABU0Guy4yHGUF
+HkQ7Hdg1QLhupMWlphlMJbeSxZJx0T6ApNvr2Qg+uFykSXbXjP2e/tXGb9NeHveT
+tw/hD2yMPzXJZ4uQbk8mJWDfD87fHY4ZUVqLJtKiS3omePJ5FWMPnLl0PLICkvmh
+mhoxyKFGjB+62/PpYwclZLR8iB7wn9tIA/q6BqP/BBhgmzpuh7ZOAU/zUZ5D+tHu
+Q9X0e29iFs4nxewmSM1uCq++l+gGMFRMn0FPH8nyQS/EcB/qXXRc0J3Ja7VVfH5B
+djmVvqTeJmwY+xGdLZAh/WZ9raWd/qbRGNIcYOyhHnvp719EQxYSiiJbIQcRLDbc
+IBiUG322ubSiR4+saYfx4ixrHvx8QYbtagien0kkXtoouhhIuLxq/EADRb979ZvQ
+1hnlUkSGHRN6mDNyLztRqy/iibZrSgX+iKR9lQYI5MnhchihgoN7jyFUiGTV/VSG
+6oH2KHiTgUQawli9OirnBB1oekf2+QZfZUvnM+b+SrkCDQRbcs+fARAArdB3G/Ld
+uGV7BnDpVZxJaHDDKNeyHcg77NY9oycazU0+o5MZYMBvqI0rbEb5ZUaxvOVqvxTS
+Oi7gWN1MfmJnWjZvqfAiYhAxPxqpeBj0jWe3wooqKUcshV4OtVTO9pVqJAE/aPRm
+klNP7DOVg3l7zAOUCJQIOvo0O/kdDDCx3h9BkzJxefCgBZhO0+9vh9cz7bx96nkJ
+TrfjwTCVTYY4jtjMFOzZVCClc+FZ9SZsQNZAlhCMWchUvNl1ynPQV4D6sJ5Nu5ag
+cXWcw1hZIvEgZw3b8E0/7NHIbcHpFjeLdkaHytMN90xe/jEkC8aVi6/IoK0ELwau
+iwXzKpvLUFhy9lQzkQ4OZCiKWb+KTccSBZrtVV/ltNTo9hlegDiYF+o2nTIkZR6b
+ZM+w/3Zp6rAsnw0Qpi3MAd8tv23oW1dfoltm1YlGhaECLf115tiaNWLbJMWeyw54
+A4p/PKVOoyHdTXcYz9qylI5v3ch+YzJ9Xp4L+9cNekx/hla+NoaPsjsDk2KPKigw
+L0ICPCPHvjJZDC0S6YJhYhAplgqLyTkNiR4s6hTpq/nkm3oO6OVaVgPnG9LAnWxl
+F/Cr+ovMz/2soVZ1oNaFOUNB04B/YENK85EfkXtjucUirjWJ6lTib+Hkc7dTTxYG
+WTsPjxTCZbxM+LoxsAPzrHSTS0CvxxCu+RsAEQEAAYkCNgQYAQoAIBYhBOhpfi7v
+dsAtOmMyd4iBsqghCXbyBQJbcs+fAhsMAAoJEIiBsqghCXbyj1IP/39mCRh1/RWj
+ZAqaBJOdUFubL6aiEztuCIOuZhFVcsdRjzkfQUJwiaF2a54RL9nfwaYoxRP3Ef3x
+7/W5qnON+MGnmT8g8n5Vk5+vjEGDCSX7MynSRWmmOKj3mgnKIexgtqsOCOTCDXzV
+U3IpzlOdl2c7ehfhDZuIfLur20vuebCl40UcTTB2wZTTK9MspbpHRq7Nz0xhGLVx
+DwYZrOD5c+bh48JL3/q7YvOM9qqnV+stGFsbUQctHBnqNeTWAPJBySyEHlGG5Fdt
+Dwu1KKI9vQ6SLEcQ7+xdqmdyiLHvKIiUyLm3TPju8zYczKPl0lGNhzOmlgywo1eU
+riVSVLD8QN2hCoo5/z45hpK+AyoYmp7dJyAf6c8inpTUCRzuX4Ahble9kfRiEe8g
+URtgFOTsIB0HcuRdP+P+i7TVVmTCstpRGLslvH5tK2wuxuUG89CoWGVsadxdtKzu
+uu/VYjLjUE8EHxyPWpHbRahRBT7qB8k91QDMc3lAHDF8AWj3B8NRDpV9ZIm2jOXW
+w1TnyhK+iTY+FTdNAnrjPvqxyUk3jP4HMTvgVqc2jRRfTDKwgS++MImPlie66IEX
++Q7ux9ntPsP1zqbiMd6xkjvVYVa1XKEx4piT7lh+4+esMmy0v0woehyPLKDI2C88
+Vm6r0sldG+MX23M2/+32OBWofNHhOffz
+=c4aa
+-----END PGP PUBLIC KEY BLOCK-----
Index: pgadmin4-4.21.tar.gz
===================================================================
Binary file pgadmin4-4.21.tar.gz (revision 28) deleted
OBS-URL: https://build.opensuse.org/request/show/814655
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=29
- Decrease requirements to build in SLE/Leap:
* Werkzeug from 0.15.0 to 0.14.1
* passlib from 1.7.2 to 1.7.1
* psycopg from 2.8 to 2.7.4
* python-dateutil from 2.8.0 to 2.7.3
* simplejson from 3.16.0 to 3.13.2
* pytz from 2018.9 to 2018.3
pgadmin has this tendency to just follow the latest versions
instead of properly specify required versions.
- Update to 4.21
- New features
* Added search object functionality.
* Added LDAP authentication support.
* Added support for parameter toast_tuple_target and parallel_workers
of the table.
* Added support of Packages, Sequences and Synonyms to the
Schema Diff.
* Added an option to prevent a browser tab being opened at startup.
- Bug fixes
* Ensure that the start and end date should be deleted when clear
the selection for pgAgent Job.
* Fixed calendar opening issue on the exception tab inside the
schedules tab of pgAgent.
* Fixed an issue where the autovacuum_enabled parameter is added
automatically in the RE-SQL when the table has been created
using the WITH clause.
* Fixed generated SQL when any token in FTS Configuration or any
option in FTS Dictionary is changed.
* Fixed tab key navigation issue for parameters in table dialog.
OBS-URL: https://build.opensuse.org/request/show/805885
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/pgadmin4?expand=0&rev=27
