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

- 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