commit postgresql11 for openSUSE:Factory

2024-03-04 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2024-03-04 21:25:51

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1770 (New)


Package is "postgresql11"

Mon Mar  4 21:25:51 2024 rev:33 rq:1154710 version:11.22

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2023-11-09 21:36:35.219519318 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1770/postgresql11.changes  
2024-03-04 21:25:54.364072061 +0100
@@ -1,0 +2,5 @@
+Thu Feb 29 14:37:59 UTC 2024 - Dominique Leuenberger 
+
+- Use %patch -P N instead of deprecated %patchN.
+
+---



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.1KvKSq/_old  2024-03-04 21:25:57.036169019 +0100
+++ /var/tmp/diff_new_pack.1KvKSq/_new  2024-03-04 21:25:57.048169454 +0100
@@ -507,13 +507,13 @@
 # Keep the timestamp of configure, because patching it would otherwise
 # confuse PostgreSQL's build system
 touch -r configure tmp
-%patch1
-%patch4
-%patch8
-%patch9
+%patch -P 1
+%patch -P 4
+%patch -P 8
+%patch -P 9
 %if %{with llvm}
-%patch10
-%patch11
+%patch -P 10
+%patch -P 11
 %endif
 touch -r tmp configure
 rm tmp


commit postgresql11 for openSUSE:Factory

2023-11-09 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2023-11-09 21:36:16

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.17445 (New)


Package is "postgresql11"

Thu Nov  9 21:36:16 2023 rev:32 rq:1124720 version:11.22

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2023-10-31 20:26:51.244483929 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.17445/postgresql11.changes 
2023-11-09 21:36:35.219519318 +0100
@@ -1,0 +2,32 @@
+Thu Nov  9 12:03:30 UTC 2023 - Reinhard Max 
+
+- Update to 11.22:
+  * bsc#1216962, CVE-2023-5868: Fix handling of unknown-type
+arguments in DISTINCT "any" aggregate functions. This error led
+to a text-type value being interpreted as an unknown-type value
+(that is, a zero-terminated string) at runtime. This could
+result in disclosure of server memory following the text value.
+  * bsc#1216961, CVE-2023-5869: Detect integer overflow while
+computing new array dimensions. When assigning new elements to
+array subscripts that are outside the current array bounds, an
+undetected integer overflow could occur in edge cases. Memory
+stomps that are potentially exploitable for arbitrary code
+execution are possible, and so is disclosure of server memory.
+  * bsc#1216960, CVE-2023-5870: Prevent the pg_signal_backend role
+from signalling background workers and autovacuum processes.
+The documentation says that pg_signal_backend cannot issue
+signals to superuser-owned processes. It was able to signal
+these background  processes, though, because they advertise a
+role OID of zero. Treat that as indicating superuser ownership.
+The security implications of cancelling one of these process
+types are fairly small so far as the core code goes (we'll just
+start another one), but extensions might add background workers
+that are more vulnerable.
+Also ensure that the is_superuser parameter is set correctly in
+such processes. No specific security consequences are known for
+that oversight, but it might be significant for some extensions.
+  * Add support for LLVM 16 and 17
+  * https://www.postgresql.org/about/news/2749
+  * https://www.postgresql.org/docs/11/release-11-22.html 
+
+---

Old:

  postgresql-11.21.tar.bz2
  postgresql-11.21.tar.bz2.sha256

New:

  postgresql-11.22.tar.bz2
  postgresql-11.22.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.b9BwtE/_old  2023-11-09 21:36:35.911544868 +0100
+++ /var/tmp/diff_new_pack.b9BwtE/_new  2023-11-09 21:36:35.915545016 +0100
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.21
+%define pgversion 11.22
 %define pgmajor 11
 %define buildlibs 0
 %define tarversion %{pgversion}

++ postgresql-11.21.tar.bz2 -> postgresql-11.22.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.21.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.17445/postgresql-11.22.tar.bz2 
differ: char 11, line 1

++ postgresql-11.21.tar.bz2.sha256 -> postgresql-11.22.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.21.tar.bz2.sha256 
2023-08-11 15:55:50.655873895 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.17445/postgresql-11.22.tar.bz2.sha256
  2023-11-09 21:36:35.203518728 +0100
@@ -1 +1 @@
-07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850  
postgresql-11.21.tar.bz2
+2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0  
postgresql-11.22.tar.bz2


commit postgresql11 for openSUSE:Factory

2023-10-31 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2023-10-31 20:26:34

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.17445 (New)


Package is "postgresql11"

Tue Oct 31 20:26:34 2023 rev:31 rq:1121438 version:11.21

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2023-08-11 15:55:50.679874038 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.17445/postgresql11.changes 
2023-10-31 20:26:51.244483929 +0100
@@ -1,0 +2,22 @@
+Tue Oct 31 10:57:13 UTC 2023 - Reinhard Max 
+
+- boo#1216734: Revert the last change and make the devel package
+  independend of all other subpackages except for the libs.
+
+---
+Tue Oct 10 12:49:02 UTC 2023 - Reinhard Max 
+
+- boo#1216022: Call install-alternatives from the devel subpackage
+  as well, otherwise the symlink for ecpg might be missing.
+
+---
+Mon Sep 18 15:24:14 UTC 2023 - Dominique Leuenberger 
+
+- Also buildignore the postgresql*-implementation symbols: this is
+  needed in order to bootstrap when no postgresql version currently
+  has valid symbols provided. Once the packages are built, OBS
+  could translate this to the pgname-* packages and accept the
+  ignores; during bootstrap though, there is nothing providing the
+  symbol and the existing buildignores do not suffice.
+
+---



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.EhVQwX/_old  2023-10-31 20:26:51.828505381 +0100
+++ /var/tmp/diff_new_pack.EhVQwX/_new  2023-10-31 20:26:51.828505381 +0100
@@ -159,6 +159,10 @@
 #!BuildIgnore:  %pgname-pltcl
 #!BuildIgnore:  %pgname-plperl
 #!BuildIgnore:  %pgname-plpython
+#!BuildIgnore:  postgresql-implementation
+#!BuildIgnore:  postgresql-server-implementation
+#!BuildIgnore:  postgresql-server-devel-implementation
+#!BuildIgnore:  postgresql-llvmjit-devel-implementation
 Summary:Basic Clients and Utilities for PostgreSQL
 License:PostgreSQL
 Group:  Productivity/Databases/Tools
@@ -505,7 +509,7 @@
 touch -r configure tmp
 %patch1
 %patch4
-%patch8 -p1
+%patch8
 %patch9
 %if %{with llvm}
 %patch10
@@ -756,7 +760,9 @@
 mkdir -p %buildroot%pgmandir/man1
 cp -a doc/src/sgml/man1/ecpg.1 %buildroot%pgmandir/man1/ecpg.1pg%pgmajor
 %find_lang ecpg-$VLANG devel.files
-ln -s %pgbindir/ecpg %buildroot%_bindir/ecpg
+# The devel subpackage is exclusive across versions
+# and not handled by update-alternatives.
+mv %buildroot%pgbindir/ecpg %buildroot%_bindir/ecpg
 
 %if !%mini
 %find_lang pg_config-$VLANG server-devel.files
@@ -791,17 +797,19 @@
 
 %post -n %pgname-%devel
 /sbin/ldconfig
-%if %{with server_devel}
-%post server-devel
-%endif
 /usr/share/postgresql/install-alternatives %pgmajor
 
 %postun -n %pgname-%devel
 /sbin/ldconfig
+/usr/share/postgresql/install-alternatives %pgmajor
+
 %if %{with server_devel}
+%post server-devel
+/usr/share/postgresql/install-alternatives %pgmajor
+
 %postun server-devel
-%endif
 /usr/share/postgresql/install-alternatives %pgmajor
+%endif
 
 %if !%mini
 
@@ -954,10 +962,9 @@
 
 %dir %pgbasedir
 %dir %pgbindir
-%ghost %_bindir/ecpg
+%_bindir/ecpg
 %_libdir/pkgconfig/*
 %_libdir/lib*.so
-%pgbindir/ecpg
 %pgincludedir
 %if %{with server_devel}
 %exclude %pgincludedir/server

++ postgresql-testsuite-keep-results-file.patch ++
--- /var/tmp/diff_new_pack.EhVQwX/_old  2023-10-31 20:26:51.896507878 +0100
+++ /var/tmp/diff_new_pack.EhVQwX/_new  2023-10-31 20:26:51.900508025 +0100
@@ -4,10 +4,10 @@
 
 don't unlink the result file
 
-Index: postgresql-11beta1/src/test/regress/pg_regress.c
+Index: src/test/regress/pg_regress.c
 ===
 postgresql-11beta1.orig/src/test/regress/pg_regress.c
-+++ postgresql-11beta1/src/test/regress/pg_regress.c
+--- src/test/regress/pg_regress.c
 src/test/regress/pg_regress.c
 @@ -2574,7 +2574,6 @@ regression_main(int argc, char *argv[],
else
{


commit postgresql11 for openSUSE:Factory

2023-08-11 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2023-08-11 15:55:41

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.11712 (New)


Package is "postgresql11"

Fri Aug 11 15:55:41 2023 rev:30 rq:1103348 version:11.21

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2023-05-12 20:40:08.630809297 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.11712/postgresql11.changes 
2023-08-11 15:55:50.679874038 +0200
@@ -1,0 +2,23 @@
+Thu Aug 10 14:16:25 UTC 2023 - Reinhard Max 
+
+- Update to 11.21:
+  * bsc#1214059, CVE-2023-39417: Disallow substituting a schema or
+owner name into an extension script if the name contains a
+quote, backslash, or dollar sign.
+  * https://www.postgresql.org/docs/11/release-11-21.html
+
+---
+Fri May 26 11:48:38 UTC 2023 - Reinhard Max 
+
+- Restore the independence of mini builds from the main build after
+  the -mini name change from April 4, 2023.
+- Adjust icu handling to prepare for PostgreSQL 16.
+
+---
+Mon May 15 14:23:32 UTC 2023 - Reinhard Max 
+
+- Overhaul postgresql-README.SUSE and move it from the binary
+  package to the noarch wrapper package.
+- Change the unix domain socket location from /var/run to /run.
+
+---
@@ -11 +33,0 @@
-

Old:

  postgresql-11.20.tar.bz2
  postgresql-11.20.tar.bz2.sha256
  postgresql-README.SUSE

New:

  postgresql-11.21.tar.bz2
  postgresql-11.21.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.KNrPax/_old  2023-08-11 15:55:51.835880926 +0200
+++ /var/tmp/diff_new_pack.KNrPax/_new  2023-08-11 15:55:51.839880950 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.20
+%define pgversion 11.21
 %define pgmajor 11
 %define buildlibs 0
 %define tarversion %{pgversion}
@@ -69,7 +69,11 @@
 
 %if %mini
 %bcond_with  selinux
+%if %pgmajor >= 16
+%bcond_without icu
+%else
 %bcond_with  icu
+%endif
 %else
 BuildRequires:  %{python}-devel
 BuildRequires:  docbook_4
@@ -143,11 +147,18 @@
 BuildRequires:  pkgconfig(krb5)
 BuildRequires:  pkgconfig(libsystemd)
 BuildRequires:  pkgconfig(systemd)
-#!BuildIgnore:  postgresql-implementation
-#!BuildIgnore:  postgresql-server-implementation
-#!BuildIgnore:  postgresql-devel-noarch
-#!BuildIgnore:  postgresql-llvmjit-devel-noarch
-#!BuildIgnore:  postgresql-server-devel-noarch
+#!BuildIgnore:  %pgname
+#!BuildIgnore:  %pgname-server
+#!BuildIgnore:  %pgname-devel
+#!BuildIgnore:  %pgname-server-devel
+#!BuildIgnore:  %pgname-llvmjit
+#!BuildIgnore:  %pgname-llvmjit-devel
+#!BuildIgnore:  %pgname-contrib
+#!BuildIgnore:  %pgname-docs
+#!BuildIgnore:  %pgname-test
+#!BuildIgnore:  %pgname-pltcl
+#!BuildIgnore:  %pgname-plperl
+#!BuildIgnore:  %pgname-plpython
 Summary:Basic Clients and Utilities for PostgreSQL
 License:PostgreSQL
 Group:  Productivity/Databases/Tools
@@ -156,7 +167,6 @@
 Source0:
https://ftp.postgresql.org/pub/source/v%{tarversion}/postgresql-%{tarversion}.tar.bz2
 Source1:
https://ftp.postgresql.org/pub/source/v%{tarversion}/postgresql-%{tarversion}.tar.bz2.sha256
 Source2:baselibs.conf
-Source3:postgresql-README.SUSE
 Source17:   postgresql-rpmlintrc
 Patch1: postgresql-conf.patch
 # PL/Perl needs to be linked with rpath (bsc#578053)
@@ -630,7 +640,6 @@
 install -d -m755 %buildroot%pgdocdir
 cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \
README HISTORY  %buildroot%pgdocdir
-cp -a %SOURCE3 %buildroot%pgdocdir/README.SUSE
 # Use versioned names for the man pages:
 for f in %buildroot%pgmandir/man*/*; do
 mv $f ${f}pg%pgmajor

++ postgresql-11.20.tar.bz2 -> postgresql-11.21.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.20.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.11712/postgresql-11.21.tar.bz2 
differ: char 11, line 1

++ postgresql-11.20.tar.bz2.sha256 -> postgresql-11.21.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.20.tar.bz2.sha256 
2023-05-12 20:40:08.614809209 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.11712/postgresql-11.21.tar.bz2.sha256
  2023-08-11 15:55:50.655873895 +0200
@@ -1 +1 @@
-3d7c8882f64a7e98534a044257dfee7abad77a5b7da12508d85d722b98b5acce  
postgresql-11.20.tar.bz2
+07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850  
postgresql-11.21.tar.bz2

++ postgresql-var-run-socket.patch ++
--- /var

commit postgresql11 for openSUSE:Factory

2023-05-12 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2023-05-12 20:37:18

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1533 (New)


Package is "postgresql11"

Fri May 12 20:37:18 2023 rev:29 rq:1086558 version:11.20

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2023-04-21 14:18:00.366915268 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1533/postgresql11.changes  
2023-05-12 20:40:08.630809297 +0200
@@ -1,0 +2,12 @@
+Thu May 11 13:20:32 UTC 2023 - Reinhard Max 
+
+- Update to 11.20:
+  * bsc#1211228, CVE-2023-2454:
+Prevent CREATE SCHEMA from defeating changes in search_path
+  * bsc#1211229, CVE-2023-2455: Enforce row-level security
+policies correctly after inlining a set-returning function
+  * https://www.postgresql.org/about/news/2637/
+  * https://www.postgresql.org/docs/11/release-11-20.html
+
+
+---

Old:

  postgresql-11.19.tar.bz2
  postgresql-11.19.tar.bz2.sha256

New:

  postgresql-11.20.tar.bz2
  postgresql-11.20.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.K7bsTT/_old  2023-05-12 20:40:09.214812507 +0200
+++ /var/tmp/diff_new_pack.K7bsTT/_new  2023-05-12 20:40:09.218812528 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.19
+%define pgversion 11.20
 %define pgmajor 11
 %define buildlibs 0
 %define tarversion %{pgversion}

++ postgresql-11.19.tar.bz2 -> postgresql-11.20.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.19.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.1533/postgresql-11.20.tar.bz2 
differ: char 11, line 1

++ postgresql-11.19.tar.bz2.sha256 -> postgresql-11.20.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.19.tar.bz2.sha256 
2023-02-10 14:34:02.477461955 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.1533/postgresql-11.20.tar.bz2.sha256
   2023-05-12 20:40:08.614809209 +0200
@@ -1 +1 @@
-13109e2b71f1139405c27201da3733a61ace72ee1c228d9c9f0320e06aee14c2  
postgresql-11.19.tar.bz2
+3d7c8882f64a7e98534a044257dfee7abad77a5b7da12508d85d722b98b5acce  
postgresql-11.20.tar.bz2


commit postgresql11 for openSUSE:Factory

2023-04-21 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2023-04-21 14:17:49

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1533 (New)


Package is "postgresql11"

Fri Apr 21 14:17:49 2023 rev:28 rq:1081149 version:11.19

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2023-02-10 14:34:02.489462026 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1533/postgresql11.changes  
2023-04-21 14:18:00.366915268 +0200
@@ -1,0 +2,6 @@
+Tue Apr 18 09:05:09 UTC 2023 - Reinhard Max 
+
+- bsc#1210303: Stop using the obsolete internal %_restart_on_update
+  macro and drop support for sysv init to simplify the scriptlets.
+
+---



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.i7X1l7/_old  2023-04-21 14:18:01.010918879 +0200
+++ /var/tmp/diff_new_pack.i7X1l7/_new  2023-04-21 14:18:01.010918879 +0200
@@ -18,7 +18,6 @@
 
 %define pgversion 11.19
 %define pgmajor 11
-%define pgsuffix %pgmajor
 %define buildlibs 0
 %define tarversion %{pgversion}
 %define latest_supported_llvm_ver 15
@@ -42,13 +41,14 @@
 
 %define requires_file() %( readlink -f '%*' | LC_ALL=C xargs -r rpm -q --qf 
'Requires: %%{name} >= %%{epoch}:%%{version}\\n' -f | sed -e 's/ (none):/ /' -e 
's/ 0:/ /' | grep -v "is not")
 
-Name:   %pgname
 %if "@BUILD_FLAVOR@" == "mini"
 %define devel devel-mini
 %define mini 1
+Name:   %pgname-mini
 %else
 %define devel devel
 %define mini 0
+Name:   %pgname
 %endif
 
 # Use Python 2 for for PostgreSQL 10 on SLE12.
@@ -95,13 +95,6 @@
 BuildRequires:  %libecpg
 BuildRequires:  %libpq
 %endif
-%if 0%{?suse_version} >= 1300
-%bcond_without  systemd
-%bcond_without  systemd_notify
-%else
-%bcond_with systemd
-%bcond_with systemd_notify
-%endif
 
 %if 0%{?suse_version} >= 1500 && %pgmajor >= 11
 %ifarch riscv64
@@ -148,10 +141,8 @@
 BuildRequires:  openssl-devel
 BuildRequires:  pkg-config
 BuildRequires:  pkgconfig(krb5)
-%if %{with systemd_notify}
 BuildRequires:  pkgconfig(libsystemd)
 BuildRequires:  pkgconfig(systemd)
-%endif
 #!BuildIgnore:  postgresql-implementation
 #!BuildIgnore:  postgresql-server-implementation
 #!BuildIgnore:  postgresql-devel-noarch
@@ -240,7 +231,7 @@
 This package provides the runtime library of the embedded SQL C
 preprocessor for PostgreSQL.
 
-%package %devel
+%package -n %pgname-%devel
 Summary:PostgreSQL client development header files and libraries
 Group:  Development/Libraries/C and C++
 Provides:   postgresql-devel = %version-%release
@@ -303,7 +294,7 @@
 applications, see the postgresql%pgmajor-devel package.
 %endif
 
-%description %devel
+%description -n %pgname-%devel
 PostgreSQL is an advanced object-relational database management system
 that supports an extended subset of the SQL standard, including
 transactions, foreign keys, subqueries, triggers, and user-defined
@@ -547,9 +538,7 @@
 %if %{with libzstd}
 --with-zstd \
 %endif
-%if %{with systemd_notify}
 --with-systemd \
-%endif
 %if %{with selinux}
 --with-selinux \
 %endif
@@ -791,14 +780,14 @@
 
 %fdupes %buildroot
 
-%post %devel
+%post -n %pgname-%devel
 /sbin/ldconfig
 %if %{with server_devel}
 %post server-devel
 %endif
 /usr/share/postgresql/install-alternatives %pgmajor
 
-%postun %devel
+%postun -n %pgname-%devel
 /sbin/ldconfig
 %if %{with server_devel}
 %postun server-devel
@@ -818,45 +807,26 @@
 
 %preun server
 # Stop only when we are uninstalling the currently running version
-test -n "$FIRST_ARG" || FIRST_ARG="$1"
-if [ "$FIRST_ARG" -eq 0 ]; then
-  %if %{with systemd}
-%define stop systemctl stop postgresql.service
-eval $(systemctl show postgresql.service --property=MainPID)
-  %else
-%define stop /sbin/init.d postgresql stop
-MainPID=$(pidof -s postgres) || :
-  %endif
-  if test -n "$MainPID" && test "$MainPID" -ne 0; then
-BIN=$(readlink -n /proc/$MainPID/exe)
+test -x /usr/bin/systemctl &&
+  MAINPID=$(/usr/bin/systemctl show postgresql.service --property=MainPID 
--value) ||:
+if test -n "$MAINPID" && test "$MAINPID" -ne 0; then
+  BIN=$(readlink -n /proc/$MAINPID/exe)
 DIR=$(dirname ${BIN% *})
 if test "$DIR" = "%pgbindir" -o "$DIR" = "%_bindir"; then
-%stop
-fi
+  %service_del_preun postgresql.service
   fi
 fi
 
 %postun server
 /usr/share/postgresql/install-alternatives %pgmajor
 # Restart only when we are updating the currently running version
-# or from the old packaging scheme
-test -n "$FIRST_ARG" || FIRST_ARG="$1"
-if [ "$FIRST_ARG" -ge 1 ]; then

commit postgresql11 for openSUSE:Factory

2023-02-10 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2023-02-10 14:33:56

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1848 (New)


Package is "postgresql11"

Fri Feb 10 14:33:56 2023 rev:27 rq:1064058 version:11.19

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2022-11-12 17:40:46.974030025 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1848/postgresql11.changes  
2023-02-10 14:34:02.489462026 +0100
@@ -1,0 +2,8 @@
+Thu Feb  9 12:03:40 UTC 2023 - Reinhard Max 
+
+- Update to 11.19:
+  * https://www.postgresql.org/about/news/2592/
+  * https://www.postgresql.org/docs/15/release-15-2.html
+- Bump latest_supported_llvm_ver to 15.
+
+---

Old:

  postgresql-11.18.tar.bz2
  postgresql-11.18.tar.bz2.sha256

New:

  postgresql-11.19.tar.bz2
  postgresql-11.19.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.0ECMeJ/_old  2023-02-10 14:34:02.937464703 +0100
+++ /var/tmp/diff_new_pack.0ECMeJ/_new  2023-02-10 14:34:02.945464752 +0100
@@ -1,7 +1,7 @@
 #
 # spec file
 #
-# Copyright (c) 2022 SUSE LLC
+# Copyright (c) 2023 SUSE LLC
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -16,12 +16,12 @@
 #
 
 
-%define pgversion 11.18
+%define pgversion 11.19
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
 %define tarversion %{pgversion}
-%define latest_supported_llvm_ver 14
+%define latest_supported_llvm_ver 15
 
 ### CUT HERE ###
 %define pgname postgresql%pgmajor

++ postgresql-11.18.tar.bz2 -> postgresql-11.19.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.18.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.1848/postgresql-11.19.tar.bz2 
differ: char 11, line 1

++ postgresql-11.18.tar.bz2.sha256 -> postgresql-11.19.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.18.tar.bz2.sha256 
2022-11-12 17:40:46.950029882 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.1848/postgresql-11.19.tar.bz2.sha256
   2023-02-10 14:34:02.477461955 +0100
@@ -1 +1 @@
-d24f20efc52e918acfbcca21e9cea28e0e263b846a0c408fcfac3b3c4a0f7504  
postgresql-11.18.tar.bz2
+13109e2b71f1139405c27201da3733a61ace72ee1c228d9c9f0320e06aee14c2  
postgresql-11.19.tar.bz2


commit postgresql11 for openSUSE:Factory

2022-11-12 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2022-11-12 17:40:37

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1597 (New)


Package is "postgresql11"

Sat Nov 12 17:40:37 2022 rev:26 rq:1035215 version:11.18

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2022-10-04 20:37:33.708902313 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1597/postgresql11.changes  
2022-11-12 17:40:46.974030025 +0100
@@ -1,0 +2,8 @@
+Thu Nov 10 16:30:04 UTC 2022 - Reinhard Max 
+
+- bsc#1205300: Update to 11.18:
+  * https://www.postgresql.org/about/news/2543/
+  * https://www.postgresql.org/docs/11/release-11-18.html
+- Sync spec file with postgresql15.
+
+---

Old:

  postgresql-11.17.tar.bz2
  postgresql-11.17.tar.bz2.sha256

New:

  postgresql-11.18.tar.bz2
  postgresql-11.18.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.SUBG84/_old  2022-11-12 17:40:47.602033763 +0100
+++ /var/tmp/diff_new_pack.SUBG84/_new  2022-11-12 17:40:47.606033787 +0100
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.17
+%define pgversion 11.18
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
@@ -24,8 +24,7 @@
 %define latest_supported_llvm_ver 14
 
 ### CUT HERE ###
-%define pgname postgresql%pgsuffix
-%define priority %pgsuffix
+%define pgname postgresql%pgmajor
 %define libpq libpq5
 %define libecpg libecpg6
 %define libpq_so libpq.so.5
@@ -52,9 +51,9 @@
 %define mini 0
 %endif
 
-# Use Python 2 for PostgreSQL 9.x on all platforms and for PostgreSQL 10 on 
SLE12.
+# Use Python 2 for for PostgreSQL 10 on SLE12.
 # Use Python 3 for everything else.
-%if %pgsuffix < 90 && ( 0%{?is_opensuse} || 0%{?sle_version} >= 15 || 
%pgsuffix > 10 )
+%if 0%{?is_opensuse} || 0%{?sle_version} >= 15 || %pgmajor > 10
 %define python python3
 %else
 %define python python
@@ -104,7 +103,7 @@
 %bcond_with systemd_notify
 %endif
 
-%if 0%{?suse_version} >= 1500 && %pgsuffix >= 11 && %pgsuffix < 90
+%if 0%{?suse_version} >= 1500 && %pgmajor >= 11
 %ifarch riscv64
 %bcond_with llvm
 %else
@@ -121,7 +120,7 @@
 %bcond_with check
 %endif
 
-%if ( %pgsuffix >= 11 && %pgsuffix < 90 ) || %mini
+%if %pgmajor >= 11 || %mini
 %bcond_without server_devel
 %else
 %bcond_with server_devel
@@ -163,8 +162,8 @@
 Group:  Productivity/Databases/Tools
 Version:%pgversion
 Release:0
-Source0:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{tarversion}.tar.bz2
-Source1:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{tarversion}.tar.bz2.sha256
+Source0:
https://ftp.postgresql.org/pub/source/v%{tarversion}/postgresql-%{tarversion}.tar.bz2
+Source1:
https://ftp.postgresql.org/pub/source/v%{tarversion}/postgresql-%{tarversion}.tar.bz2.sha256
 Source2:baselibs.conf
 Source3:postgresql-README.SUSE
 Source17:   postgresql-rpmlintrc
@@ -301,7 +300,7 @@
 
 This package contains the header files and libraries needed to compile
 C extensions that link into the PostgreSQL server. For building client
-applications, see the postgresql%pgsuffix-devel package.
+applications, see the postgresql%pgmajor-devel package.
 %endif
 
 %description %devel
@@ -317,7 +316,7 @@
 which will interact with a PostgreSQL server.
 
 For building PostgreSQL server extensions, see the
-postgresql%pgsuffix-server-devel package.
+postgresql%pgmajor-server-devel package.
 
 %package server
 Summary:The Programs Needed to Create and Run a PostgreSQL Server
@@ -645,7 +644,7 @@
 cp -a %SOURCE3 %buildroot%pgdocdir/README.SUSE
 # Use versioned names for the man pages:
 for f in %buildroot%pgmandir/man*/*; do
-mv $f ${f}pg%pgsuffix
+mv $f ${f}pg%pgmajor
 done
 %endif
 
@@ -712,6 +711,9 @@
pg_resetwal \
pg_waldump \
pg_resetxlog \
+%if %pgmajor >= 15
+   pg_upgrade \
+%endif
postgres \
postmaster
 
@@ -722,7 +724,9 @@
pg_amcheck \
pg_standby \
pg_test_fsync \
+%if %pgmajor < 15
pg_upgrade \
+%endif
 pgbench \
vacuumlo \
pg_test_timing
@@ -752,7 +756,7 @@
 popd
 
 mkdir -p %buildroot%pgmandir/man1
-cp -a doc/src/sgml/man1/ecpg.1 %buildroot%pgmandir/man1/ecpg.1pg%pgsuffix
+cp -a doc/src/sgml/man1/ecpg.1 %buildroot%pgmandir/man1/ecpg.1pg%pgmajor
 %find_lang ecpg-$VLANG devel.files
 ln -s %pgbindir/ecpg %buildroot%_bindir/ecpg
 
@@ -792,25 +796,25 @@
 %if %{with server_devel}
 %post server-devel
 %endif
-/usr

commit postgresql11 for openSUSE:Factory

2022-10-04 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2022-10-04 20:37:30

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.2275 (New)


Package is "postgresql11"

Tue Oct  4 20:37:30 2022 rev:25 rq:1006686 version:11.17

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2022-08-16 17:06:44.387697974 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.2275/postgresql11.changes  
2022-10-04 20:37:33.708902313 +0200
@@ -1,0 +2,17 @@
+Thu Sep 22 21:26:36 UTC 2022 - Aaron Puchert 
+
+- Create mechanism to specify the latest supported LLVM version.
+  Automatically pin to that version if the distribution has a newer
+  unsupported default version.
+
+---
+Tue Sep 13 12:39:03 UTC 2022 - Reinhard Max 
+
+- Sync spec file with postgresql15.
+
+---
+Mon Sep 12 07:52:42 UTC 2022 - Andreas Schwab 
+
+- Disable LLVM JIT on riscv64
+
+---



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.WAxA7N/_old  2022-10-04 20:37:34.492903428 +0200
+++ /var/tmp/diff_new_pack.WAxA7N/_new  2022-10-04 20:37:34.496903433 +0200
@@ -21,6 +21,7 @@
 %define pgsuffix %pgmajor
 %define buildlibs 0
 %define tarversion %{pgversion}
+%define latest_supported_llvm_ver 14
 
 ### CUT HERE ###
 %define pgname postgresql%pgsuffix
@@ -59,6 +60,14 @@
 %define python python
 %endif
 
+%if 0%{?suse_version} >= 1500
+%bcond_without liblz4
+%endif
+
+%if 0%{?sle_version} >= 150100 || 0%{?suse_version} >= 1550
+%bcond_without libzstd
+%endif
+
 %if %mini
 %bcond_with  selinux
 %bcond_with  icu
@@ -73,6 +82,14 @@
 BuildRequires:  tcl-devel
 BuildRequires:  timezone
 BuildRequires:  zlib-devel
+%if %{with liblz4}
+BuildRequires:  pkgconfig(liblz4)
+%endif
+
+%if %{with libzstd}
+BuildRequires:  pkgconfig(libzstd)
+%endif
+
 %bcond_without  selinux
 %bcond_without  icu
 %if  !%buildlibs
@@ -88,7 +105,11 @@
 %endif
 
 %if 0%{?suse_version} >= 1500 && %pgsuffix >= 11 && %pgsuffix < 90
+%ifarch riscv64
+%bcond_with llvm
+%else
 %bcond_without  llvm
+%endif
 %else
 %bcond_with llvm
 %endif
@@ -114,10 +135,15 @@
 BuildRequires:  libselinux-devel
 %endif
 %if %{with llvm}
-BuildRequires:  clang
 BuildRequires:  gcc-c++
+%if 0%{?product_libs_llvm_ver} > %{latest_supported_llvm_ver}
+BuildRequires:  clang%{latest_supported_llvm_ver}
+BuildRequires:  llvm%{latest_supported_llvm_ver}-devel
+%else
+BuildRequires:  clang
 BuildRequires:  llvm-devel
 %endif
+%endif
 BuildRequires:  libxslt-devel
 BuildRequires:  openldap2-devel
 BuildRequires:  openssl-devel
@@ -398,8 +424,8 @@
 Group:  Productivity/Databases/Tools
 Provides:   postgresql-contrib-implementation = %version-%release
 Requires:   postgresql-contrib-noarch >= %pgmajor
-Requires(post): %pgname >= %pgmajor
-Requires:   %pgname >= %pgmajor
+Requires(post): %pgname >= %{version}
+Requires:   %pgname >= %{version}
 PreReq: %pgname-server = %version-%release
 
 %description contrib
@@ -516,6 +542,12 @@
 --with-uuid=e2fs \
 --with-libxml \
 --with-libxslt \
+%if %{with liblz4}
+--with-lz4 \
+%endif
+%if %{with libzstd}
+--with-zstd \
+%endif
 %if %{with systemd_notify}
 --with-systemd \
 %endif
@@ -578,7 +610,7 @@
 install -sm 0755 contrib/spi/{refint.so,autoinc.so} 
%buildroot%pgtestdir/regress
 install -sm 0755 src/test/regress/{pg_regress,regress.so} 
%buildroot%pgtestdir/regress
 for i in  src/test/regress/{data,expected,input,output,sql}; do
-   cp -r $i %buildroot%pgtestdir/regress/
+   test -d $i && cp -r $i %buildroot%pgtestdir/regress/
 done
 install -m 0644 src/test/regress/*_schedule %buildroot%pgtestdir/regress
 # }}}


commit postgresql11 for openSUSE:Factory

2022-08-16 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2022-08-16 17:06:40

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1521 (New)


Package is "postgresql11"

Tue Aug 16 17:06:40 2022 rev:24 rq:995182 version:11.17

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2022-05-14 22:54:48.867189796 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1521/postgresql11.changes  
2022-08-16 17:06:44.387697974 +0200
@@ -1,0 +2,8 @@
+Fri Aug 12 10:59:32 UTC 2022 - Reinhard Max 
+
+- Update to 11.17:
+  * bsc#1202368, CVE-2022-2625: Extension scripts replace objects
+not belonging to the extension.
+  * https://www.postgresql.org/docs/release/11.17/
+
+---

Old:

  postgresql-11.16.tar.bz2
  postgresql-11.16.tar.bz2.sha256

New:

  postgresql-11.17.tar.bz2
  postgresql-11.17.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.76D6d0/_old  2022-08-16 17:06:44.999699803 +0200
+++ /var/tmp/diff_new_pack.76D6d0/_new  2022-08-16 17:06:45.007699828 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.16
+%define pgversion 11.17
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0

++ postgresql-11.16.tar.bz2 -> postgresql-11.17.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.16.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.1521/postgresql-11.17.tar.bz2 
differ: char 11, line 1

++ postgresql-11.16.tar.bz2.sha256 -> postgresql-11.17.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.16.tar.bz2.sha256 
2022-05-14 22:54:48.851189776 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.1521/postgresql-11.17.tar.bz2.sha256
   2022-08-16 17:06:44.303697723 +0200
@@ -1 +1 @@
-2dd9e111f0a5949ee7cacc065cea0fb21092929bae310ce05bf01b4ffc5103a5  
postgresql-11.16.tar.bz2
+6e984963ae0765e61577995103a7e6594db0f0bd01528ac123e0de4a6a4cb4c4  
postgresql-11.17.tar.bz2


commit postgresql11 for openSUSE:Factory

2022-05-14 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2022-05-14 22:54:43

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1538 (New)


Package is "postgresql11"

Sat May 14 22:54:43 2022 rev:23 rq:977046 version:11.16

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2022-04-14 17:23:16.599109892 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1538/postgresql11.changes  
2022-05-14 22:54:48.867189796 +0200
@@ -1,0 +2,8 @@
+Thu May 12 14:36:20 UTC 2022 - Reinhard Max 
+
+- Upgrade to 11.16:
+  * bsc#1199475, CVE-2022-1552: Confine additional operations
+within "security restricted operation" sandboxes.
+  * https://www.postgresql.org/docs/11/release-11-16.html
+
+---

Old:

  postgresql-11.15.tar.bz2
  postgresql-11.15.tar.bz2.sha256

New:

  postgresql-11.16.tar.bz2
  postgresql-11.16.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.luW13Y/_old  2022-05-14 22:54:49.931191126 +0200
+++ /var/tmp/diff_new_pack.luW13Y/_new  2022-05-14 22:54:49.935191130 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.15
+%define pgversion 11.16
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
@@ -114,9 +114,9 @@
 BuildRequires:  libselinux-devel
 %endif
 %if %{with llvm}
-BuildRequires:  clang13
+BuildRequires:  clang
 BuildRequires:  gcc-c++
-BuildRequires:  llvm13-devel
+BuildRequires:  llvm-devel
 %endif
 BuildRequires:  libxslt-devel
 BuildRequires:  openldap2-devel

++ postgresql-11.15.tar.bz2 -> postgresql-11.16.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.15.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.1538/postgresql-11.16.tar.bz2 
differ: char 11, line 1

++ postgresql-11.15.tar.bz2.sha256 -> postgresql-11.16.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.15.tar.bz2.sha256 
2022-04-14 17:23:16.571109860 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.1538/postgresql-11.16.tar.bz2.sha256
   2022-05-14 22:54:48.851189776 +0200
@@ -1 +1 @@
-c8f58e8ebd4f4567f4f9ba1032eb3e99e0251d87cbe3e564b485590e37a879e3  
postgresql-11.15.tar.bz2
+2dd9e111f0a5949ee7cacc065cea0fb21092929bae310ce05bf01b4ffc5103a5  
postgresql-11.16.tar.bz2


commit postgresql11 for openSUSE:Factory

2022-04-14 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2022-04-14 17:23:02

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1941 (New)


Package is "postgresql11"

Thu Apr 14 17:23:02 2022 rev:22 rq:969864 version:11.15

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2021-12-07 00:00:37.112302059 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1941/postgresql11.changes  
2022-04-14 17:23:16.599109892 +0200
@@ -1,0 +2,15 @@
+Wed Apr 13 12:17:48 UTC 2022 - Reinhard Max 
+
+- bsc#1198166: Pin to llvm13 until the next patchlevel update.
+
+---
+Tue Feb  8 15:29:51 UTC 2022 - Reinhard Max 
+
+- bsc#1195680: Upgrade to 11.15:
+  * https://www.postgresql.org/docs/11/release-11-15.html
+  * Reindexing might be needed after applying this upgrade, so
+please read the release notes carefully.
+- boo#1190740: Add constraints file with 12GB of memory for s390x
+  as a workaround
+
+---

Old:

  postgresql-11.14.tar.bz2
  postgresql-11.14.tar.bz2.sha256

New:

  _constraints
  postgresql-11.15.tar.bz2
  postgresql-11.15.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.cvS0bQ/_old  2022-04-14 17:23:17.535110986 +0200
+++ /var/tmp/diff_new_pack.cvS0bQ/_new  2022-04-14 17:23:17.543110995 +0200
@@ -1,7 +1,7 @@
 #
 # spec file
 #
-# Copyright (c) 2021 SUSE LLC
+# Copyright (c) 2022 SUSE LLC
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.14
+%define pgversion 11.15
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
@@ -114,9 +114,9 @@
 BuildRequires:  libselinux-devel
 %endif
 %if %{with llvm}
-BuildRequires:  clang
+BuildRequires:  clang13
 BuildRequires:  gcc-c++
-BuildRequires:  llvm-devel
+BuildRequires:  llvm13-devel
 %endif
 BuildRequires:  libxslt-devel
 BuildRequires:  openldap2-devel

++ _constraints ++


  
   
 s390x
   

 
   12
 
   
  


++ postgresql-11.14.tar.bz2 -> postgresql-11.15.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.14.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.1941/postgresql-11.15.tar.bz2 
differ: char 11, line 1

++ postgresql-11.14.tar.bz2.sha256 -> postgresql-11.15.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.14.tar.bz2.sha256 
2021-11-13 22:48:21.881242538 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.1941/postgresql-11.15.tar.bz2.sha256
   2022-04-14 17:23:16.571109860 +0200
@@ -1 +1 @@
-965c7f4be96fb64f9581852c58c4f05c3812d4ad823c0f3e2bdfe777c162f999  
postgresql-11.14.tar.bz2
+c8f58e8ebd4f4567f4f9ba1032eb3e99e0251d87cbe3e564b485590e37a879e3  
postgresql-11.15.tar.bz2


commit postgresql11 for openSUSE:Factory

2021-12-06 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2021-12-06 23:59:26

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.31177 (New)


Package is "postgresql11"

Mon Dec  6 23:59:26 2021 rev:21 rq:935207 version:11.14

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2021-11-13 22:48:21.901242553 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.31177/postgresql11.changes 
2021-12-07 00:00:37.112302059 +0100
@@ -1,0 +2,9 @@
+Thu Nov 25 11:02:15 UTC 2021 - Reinhard Max 
+
+- Add a llvmjit-devel subpackage to pull in the right versions
+  of clang and llvm for building extensions. 
+- Fix some mistakes in the interdependencies between the
+  implementation packages and their noarch counterpart.
+- Update the BuildIgnore section.
+
+---



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.HUzwGH/_old  2021-12-07 00:00:38.016298863 +0100
+++ /var/tmp/diff_new_pack.HUzwGH/_new  2021-12-07 00:00:38.020298848 +0100
@@ -40,6 +40,8 @@
 %define pgcontribdir %pgdatadir/contrib
 %define pgmandir %_mandir
 
+%define requires_file() %( readlink -f '%*' | LC_ALL=C xargs -r rpm -q --qf 
'Requires: %%{name} >= %%{epoch}:%%{version}\\n' -f | sed -e 's/ (none):/ /' -e 
's/ 0:/ /' | grep -v "is not")
+
 Name:   %pgname
 %if "@BUILD_FLAVOR@" == "mini"
 %define devel devel-mini
@@ -125,10 +127,11 @@
 BuildRequires:  pkgconfig(libsystemd)
 BuildRequires:  pkgconfig(systemd)
 %endif
-#!BuildIgnore:  %pgname
-#!BuildIgnore:  %pgname-server
 #!BuildIgnore:  postgresql-implementation
 #!BuildIgnore:  postgresql-server-implementation
+#!BuildIgnore:  postgresql-devel-noarch
+#!BuildIgnore:  postgresql-llvmjit-devel-noarch
+#!BuildIgnore:  postgresql-server-devel-noarch
 Summary:Basic Clients and Utilities for PostgreSQL
 License:PostgreSQL
 Group:  Productivity/Databases/Tools
@@ -228,6 +231,7 @@
 %else
 Requires:   %libecpg >= %version
 Requires:   %libpq >= %version
+Requires:   postgresql-devel-noarch >= %pgmajor
 %endif
 # Installation of postgresql??-devel is exclusive
 Provides:   postgresql-devel-exclusive = %pgmajor
@@ -242,17 +246,13 @@
 %endif
 Provides:   postgresql-server-devel = %version-%release
 Provides:   postgresql-server-devel-implementation = %version-%release
-Requires(post): postgresql-server-noarch >= %pgmajor
-Requires(postun):postgresql-server-noarch >= %pgmajor
+Requires(post): postgresql-server-devel-noarch >= %pgmajor
+Requires(postun):postgresql-server-devel-noarch >= %pgmajor
 Requires:   %pgname-devel = %version
 Requires:   %pgname-server = %version-%release
 # Installation of postgresql??-devel is exclusive
 Provides:   postgresql-server-devel-exclusive = %pgmajor
 Conflicts:  postgresql-server-devel-exclusive < %pgmajor
-%if %{with llvm}
-Recommends: clang
-Recommends: llvm
-%endif
 Requires:   libxslt-devel
 Requires:   openssl-devel
 Requires:   pam-devel
@@ -262,6 +262,9 @@
 %if %{with selinux}
 Requires:   libselinux-devel
 %endif
+%if %{with llvm}
+Recommends: %pgname-llvmjit-devel = %version-%release
+%endif
 
 %if %{with server_devel}
 %description server-devel
@@ -335,6 +338,31 @@
 deforming into native code, with the goal of accelerating analytics
 queries.
 
+%package llvmjit-devel
+Summary:PostgreSQL development files for extensions with LLVM support
+Group:  Development/Libraries/C and C++
+Provides:   postgresql-llvmjit-devel = %version-%release
+Provides:   postgresql-llvmjit-devel-implementation = %version-%release
+Requires:   %pgname-server-devel = %version
+%if %{with llvm}
+Requires:   %pgname-llvmjit = %version
+Requires(post): postgresql-llvmjit-devel-noarch >= %pgmajor
+Requires(postun):postgresql-llvmjit-devel-noarch >= %pgmajor
+%requires_file %_bindir/llc
+%requires_file %_bindir/clang
+%endif
+
+%description llvmjit-devel
+PostgreSQL is an advanced object-relational database management system
+that supports an extended subset of the SQL standard, including
+transactions, foreign keys, sub-queries, triggers, and user-defined
+types and functions.
+
+This package pulls in the right versions of llvm and clang to compile
+PostgreSQL extensions that support just-in-time compilation with LLVM,
+if llvm is supported. Otherwise it will just pull the
+%{pgname}-server-devel package.
+
 %package test
 Summary:The test suite for PostgreSQL
 Group:  Productivity/Databases/Servers
@@ -866,19 +894,21 @@
 %pglibdir/*_

commit postgresql11 for openSUSE:Factory

2021-11-13 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2021-11-13 22:48:12

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1890 (New)


Package is "postgresql11"

Sat Nov 13 22:48:12 2021 rev:20 rq:930952 version:11.14

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2021-10-12 21:48:11.135771419 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1890/postgresql11.changes  
2021-11-13 22:48:21.901242553 +0100
@@ -1,0 +2,10 @@
+Thu Nov 11 14:41:40 UTC 2021 - Reinhard Max 
+
+- bsc#1192516: Upgrade to version 11.14:
+  * Make the server reject extraneous data after an SSL or GSS
+encryption handshake (CVE-2021-23214).
+  * Make libpq reject extraneous data after an SSL or GSS
+encryption handshake (CVE-2021-23222).
+  * https://www.postgresql.org/docs/11/release-11-14.html
+
+---

Old:

  postgresql-11.13.tar.bz2
  postgresql-11.13.tar.bz2.sha256

New:

  postgresql-11.14.tar.bz2
  postgresql-11.14.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.VtLgvZ/_old  2021-11-13 22:48:22.461242983 +0100
+++ /var/tmp/diff_new_pack.VtLgvZ/_new  2021-11-13 22:48:22.461242983 +0100
@@ -1,5 +1,5 @@
 #
-# spec file for package postgresql11
+# spec file
 #
 # Copyright (c) 2021 SUSE LLC
 #
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.13
+%define pgversion 11.14
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
@@ -154,7 +154,7 @@
 Provides:   postgresql-implementation = %version-%release
 Requires:   %libpq >= %version
 Requires(post): postgresql-noarch >= %pgmajor
-Requires(postun): postgresql-noarch >= %pgmajor
+Requires(postun):postgresql-noarch >= %pgmajor
 # At this point we changed the package layout on SLE and conflict with
 # older releases to get a clean cut.
 Conflicts:  postgresql-noarch < 12.0.1
@@ -243,7 +243,7 @@
 Provides:   postgresql-server-devel = %version-%release
 Provides:   postgresql-server-devel-implementation = %version-%release
 Requires(post): postgresql-server-noarch >= %pgmajor
-Requires(postun): postgresql-server-noarch >= %pgmajor
+Requires(postun):postgresql-server-noarch >= %pgmajor
 Requires:   %pgname-devel = %version
 Requires:   %pgname-server = %version-%release
 # Installation of postgresql??-devel is exclusive
@@ -302,10 +302,10 @@
 Provides:   postgresql-server-implementation = %version-%release
 Requires:   %libpq >= %version
 Requires(pre):  postgresql-server-noarch >= %pgmajor
-Requires(preun): postgresql-server-noarch >= %pgmajor
-Requires(postun): postgresql-server-noarch >= %pgmajor
+Requires(preun):postgresql-server-noarch >= %pgmajor
+Requires(postun):postgresql-server-noarch >= %pgmajor
 Requires(post): postgresql-noarch >= %pgmajor
-Requires(postun): postgresql-noarch >= %pgmajor
+Requires(postun):postgresql-noarch >= %pgmajor
 
 %description server
 PostgreSQL is an advanced object-relational database management system

++ postgresql-11.13.tar.bz2 -> postgresql-11.14.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.13.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.1890/postgresql-11.14.tar.bz2 
differ: char 11, line 1

++ postgresql-11.13.tar.bz2.sha256 -> postgresql-11.14.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.13.tar.bz2.sha256 
2021-09-13 16:24:40.874755123 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.1890/postgresql-11.14.tar.bz2.sha256
   2021-11-13 22:48:21.881242538 +0100
@@ -1 +1 @@
-a0c3689ff7f565288002cbc138779d5121d74831a5e8341aea7aa86e99b6bc48  
postgresql-11.13.tar.bz2
+965c7f4be96fb64f9581852c58c4f05c3812d4ad823c0f3e2bdfe777c162f999  
postgresql-11.14.tar.bz2


commit postgresql11 for openSUSE:Factory

2021-10-12 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2021-10-12 21:48:03

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.2443 (New)


Package is "postgresql11"

Tue Oct 12 21:48:03 2021 rev:19 rq:923705 version:11.13

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2021-09-13 16:24:40.906755160 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.2443/postgresql11.changes  
2021-10-12 21:48:11.135771419 +0200
@@ -1,0 +2,8 @@
+Tue Oct  5 11:28:57 UTC 2021 - Reinhard Max 
+
+- Let genlists skip non-existing binaries to avoid lots of version
+  conditionals in the file lists.
+- Remove postgresql-testsuite-int8.sql.patch, because its purpose
+  is unclear. This affects only the test subpackage.
+
+---

Old:

  postgresql-testsuite-int8.sql.patch



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.t2Pbs9/_old  2021-10-12 21:48:11.839772427 +0200
+++ /var/tmp/diff_new_pack.t2Pbs9/_new  2021-10-12 21:48:11.843772433 +0200
@@ -142,7 +142,6 @@
 Patch1: postgresql-conf.patch
 # PL/Perl needs to be linked with rpath (bsc#578053)
 Patch4: postgresql-plperl-keep-rpath.patch
-Patch6: postgresql-testsuite-int8.sql.patch
 Patch8: postgresql-testsuite-keep-results-file.patch
 Patch9: postgresql-var-run-socket.patch
 %if %{with llvm}
@@ -452,7 +451,6 @@
 touch -r configure tmp
 %patch1
 %patch4
-%patch6
 %patch8 -p1
 %patch9
 %if %{with llvm}
@@ -554,7 +552,7 @@
 for i in  src/test/regress/{data,expected,input,output,sql}; do
cp -r $i %buildroot%pgtestdir/regress/
 done
-install -m 0644 src/test/regress/{serial,parallel}_schedule 
%buildroot%pgtestdir/regress
+install -m 0644 src/test/regress/*_schedule %buildroot%pgtestdir/regress
 # }}}
 %endif
 
@@ -605,6 +603,9 @@
 PGBIN=%pgbindir/$f
 MAN=%pgmandir/man1/$f.1*
 
+   # Package only binaries that exist in this version
+test -e %buildroot$PGBIN || continue
+
 touch %buildroot$ALTBIN
 ln -s $ALTBIN %buildroot$BIN
 
@@ -633,22 +634,13 @@
pg_basebackup \
pg_isready \
pg_recvlogical \
-%if %pgsuffix >= 90
createlang \
droplang \
pg_receivexlog \
-%else
pg_receivewal \
-%if %pgsuffix == 11
pg_verify_checksums \
-%endif
-%if %pgsuffix >= 12
pg_checksums \
-%endif
-%if %pgsuffix >= 13
pg_verifybackup
-%endif
-%endif
 
 %find_lang plpgsql-$VLANG main.files
 %find_lang pgscripts-$VLANG main.files
@@ -657,21 +649,17 @@
initdb \
pg_ctl \
pg_controldata \
-%if %pgsuffix < 90
pg_resetwal \
pg_waldump \
-%else
pg_resetxlog \
-%endif
postgres \
postmaster
 
 genlists contrib \
-%if %pgsuffix > 90
pg_xlogdump \
-%endif
oid2name \
pg_archivecleanup \
+   pg_amcheck \
pg_standby \
pg_test_fsync \
pg_upgrade \


commit postgresql11 for openSUSE:Factory

2021-09-13 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2021-09-13 16:24:15

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.1899 (New)


Package is "postgresql11"

Mon Sep 13 16:24:15 2021 rev:18 rq:917540 version:11.13

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2021-05-18 18:26:52.494849947 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.1899/postgresql11.changes  
2021-09-13 16:24:40.906755160 +0200
@@ -1,0 +2,26 @@
+Tue Aug 31 11:14:53 UTC 2021 - Reinhard Max 
+
+- bsc#1185952: fix build with llvm12 on s390x.
+  0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch 
+- bsc#1179945: Re-enable icu for PostgreSQL 10.
+
+---
+Tue Aug 24 13:09:36 UTC 2021 - Marcus Rueckert 
+
+- Upgrade to version 11.13:
+  * https://www.postgresql.org/docs/11/release-11-13.html
+  * CVE-2021-3677 (boo#1189748)
+The planner could create an incorrect plan in cases where two
+ProjectionPaths were stacked on top of each other. The only
+known way to trigger that situation involves parallel sort
+operations, but there may be other instances. The result would
+be crashes or incorrect query results. Disclosure of server
+memory contents is also possible.
+
+---
+Fri Jul  2 07:50:45 UTC 2021 - Reinhard Max 
+
+- bsc#1187751: Make the dependency of postgresqlXX-server-devel on
+  llvm and clang optional (postgresql-llvm-optional.patch).
+
+---

Old:

  postgresql-11.12.tar.bz2
  postgresql-11.12.tar.bz2.sha256

New:

  0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
  postgresql-11.13.tar.bz2
  postgresql-11.13.tar.bz2.sha256
  postgresql-llvm-optional.patch



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.8qyzjd/_old  2021-09-13 16:24:41.506755854 +0200
+++ /var/tmp/diff_new_pack.8qyzjd/_new  2021-09-13 16:24:41.510755858 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.12
+%define pgversion 11.13
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
@@ -72,11 +72,7 @@
 BuildRequires:  timezone
 BuildRequires:  zlib-devel
 %bcond_without  selinux
-%if %pgmajor > 10 || 0%{?suse_version} <= 1500
 %bcond_without  icu
-%else
-%bcond_with icu
-%endif
 %if  !%buildlibs
 BuildRequires:  %libecpg
 BuildRequires:  %libpq
@@ -88,10 +84,10 @@
 %bcond_with systemd
 %bcond_with systemd_notify
 %endif
+
 %if 0%{?suse_version} >= 1500 && %pgsuffix >= 11 && %pgsuffix < 90
 %bcond_without  llvm
 %else
-# LLVM is currently unsupported on SLE, so don't use it
 %bcond_with llvm
 %endif
 %endif
@@ -149,6 +145,10 @@
 Patch6: postgresql-testsuite-int8.sql.patch
 Patch8: postgresql-testsuite-keep-results-file.patch
 Patch9: postgresql-var-run-socket.patch
+%if %{with llvm}
+Patch10:postgresql-llvm-optional.patch
+Patch11:0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
+%endif
 URL:https://www.postgresql.org/
 BuildRoot:  %{_tmppath}/%{name}-%{version}-build
 Provides:   postgresql = %version-%release
@@ -223,9 +223,9 @@
 Provides:   %libecpg = %version-%release
 Provides:   %libpq = %version-%release
 Provides:   %pgname-devel = %version-%release
-Conflicts:  %pgname-devel
 Conflicts:  %libecpg
 Conflicts:  %libpq
+Conflicts:  %pgname-devel
 %else
 Requires:   %libecpg >= %version
 Requires:   %libpq >= %version
@@ -251,8 +251,8 @@
 Provides:   postgresql-server-devel-exclusive = %pgmajor
 Conflicts:  postgresql-server-devel-exclusive < %pgmajor
 %if %{with llvm}
-Requires:   clang
-Requires:   llvm
+Recommends: clang
+Recommends: llvm
 %endif
 Requires:   libxslt-devel
 Requires:   openssl-devel
@@ -455,6 +455,10 @@
 %patch6
 %patch8 -p1
 %patch9
+%if %{with llvm}
+%patch10
+%patch11
+%endif
 touch -r tmp configure
 rm tmp
 find src/test/ -name '*.orig' -delete
@@ -529,8 +533,7 @@
 %endif
 
 %install
-VLANG=${RPM_PACKAGE_VERSION%%.*}
-VSO=${RPM_PACKAGE_VERSION.*}
+VLANG=%pgmajor
 %if %mini
 make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname -C src/include install
 make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname -C src/interfaces install
@@ -918,6 +921,7 @@
 %if %buildlibs && %mini
 %files %devel -f devel.files -f libpq.files -f libecpg.files
 %else
+
 %files %devel -f devel.files
 %endif
 

++ 0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch +++

commit postgresql11 for openSUSE:Factory

2021-05-18 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2021-05-18 18:26:38

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.2988 (New)


Package is "postgresql11"

Tue May 18 18:26:38 2021 rev:17 rq:893133 version:11.12

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2021-04-22 18:03:23.414453310 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.2988/postgresql11.changes  
2021-05-18 18:26:52.494849947 +0200
@@ -1,0 +2,17 @@
+Tue May 11 16:20:41 UTC 2021 - Reinhard Max 
+
+- Upgrade to version 11.12:
+  * https://www.postgresql.org/docs/11/release-11-12.html
+  * CVE-2021-32027, bsc#1185924:
+Prevent integer overflows in array subscripting calculations.
+  * CVE-2021-32028, bsc#1185925: Fix mishandling of ???junk???
+columns in INSERT ... ON CONFLICT ... UPDATE target lists.
+  * CVE-2021-32029, bsc#1185926: Fix possibly-incorrect
+computation of UPDATE ... RETURNING
+"pg_psql_temporary_savepoint" does not exist???.
+
+- Don't use %_stop_on_removal, because it was meant to be private
+  and got removed from openSUSE. %_restart_on_update is also
+  private, but still supported and needed for now (bsc#1183168).
+
+---
@@ -5 +22 @@
-  only be delivered on PackageHub for now.
+  only be delivered on PackageHub for now (boo#1183118).

Old:

  postgresql-11.11.tar.bz2
  postgresql-11.11.tar.bz2.sha256

New:

  postgresql-11.12.tar.bz2
  postgresql-11.12.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.a0jtj8/_old  2021-05-18 18:26:53.026847641 +0200
+++ /var/tmp/diff_new_pack.a0jtj8/_new  2021-05-18 18:26:53.030847624 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.11
+%define pgversion 11.12
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
@@ -764,10 +764,10 @@
 %preun server
 # Stop only when we are uninstalling the currently running version
 test -n "$FIRST_ARG" || FIRST_ARG="$1"
-if [ "$FIRST_ARG" -eq 0 -a -x /usr/bin/systemctl ]; then
+if [ "$FIRST_ARG" -eq 0 ]; then
   %if %{with systemd}
-%define stop %_stop_on_removal postgresql.service
-eval $(systemctl show postgresql --property=MainPID)
+%define stop systemctl stop postgresql.service
+eval $(systemctl show postgresql.service --property=MainPID)
   %else
 %define stop /sbin/init.d postgresql stop
 MainPID=$(pidof -s postgres) || :

++ postgresql-11.11.tar.bz2 -> postgresql-11.12.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.11.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.2988/postgresql-11.12.tar.bz2 
differ: char 11, line 1

++ postgresql-11.11.tar.bz2.sha256 -> postgresql-11.12.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.11.tar.bz2.sha256 
2021-02-23 20:18:02.763530574 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.2988/postgresql-11.12.tar.bz2.sha256
   2021-05-18 18:26:52.48284 +0200
@@ -1 +1 @@
-40607b7fa15b7d63f5075a7277daf7b3412486aa5db3aedffdb7768b9298186c  
postgresql-11.11.tar.bz2
+87f9d8b16b2b8ef71586f2ec76beac844819f64734b07fa33986755c2f53cb04  
postgresql-11.12.tar.bz2


commit postgresql11 for openSUSE:Factory

2021-04-22 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2021-04-22 18:03:16

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.12324 (New)


Package is "postgresql11"

Thu Apr 22 18:03:16 2021 rev:16 rq:885323 version:11.11

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2021-03-11 20:08:33.728300434 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.12324/postgresql11.changes 
2021-04-22 18:03:23.414453310 +0200
@@ -1,0 +2,6 @@
+Mon Mar 15 19:29:39 UTC 2021 - Reinhard Max 
+
+- Re-enable build of the llvmjit subpackage on SLE, but it will
+  only be delivered on PackageHub for now.
+
+---



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.8Ht7wj/_old  2021-04-22 18:03:24.002454220 +0200
+++ /var/tmp/diff_new_pack.8Ht7wj/_new  2021-04-22 18:03:24.006454226 +0200
@@ -88,7 +88,7 @@
 %bcond_with systemd
 %bcond_with systemd_notify
 %endif
-%if 0%{?is_opensuse} && 0%{?suse_version} >= 1500 && %pgsuffix >= 11 && 
%pgsuffix < 90
+%if 0%{?suse_version} >= 1500 && %pgsuffix >= 11 && %pgsuffix < 90
 %bcond_without  llvm
 %else
 # LLVM is currently unsupported on SLE, so don't use it


commit postgresql11 for openSUSE:Factory

2021-03-11 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2021-03-11 20:08:05

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.2401 (New)


Package is "postgresql11"

Thu Mar 11 20:08:05 2021 rev:15 rq:878018 version:11.11

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2021-02-23 20:18:02.795530602 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.2401/postgresql11.changes  
2021-03-11 20:08:33.728300434 +0100
@@ -1,0 +2,6 @@
+Tue Mar  9 13:52:19 UTC 2021 - Reinhard Max 
+
+- Remove leftover PreReq on chkconfig, we stopped using it long
+  time ago.
+
+---



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.A08FRE/_old  2021-03-11 20:08:34.720302043 +0100
+++ /var/tmp/diff_new_pack.A08FRE/_new  2021-03-11 20:08:34.720302043 +0100
@@ -294,7 +294,6 @@
 %package server
 Summary:The Programs Needed to Create and Run a PostgreSQL Server
 Group:  Productivity/Databases/Servers
-PreReq: /sbin/chkconfig
 PreReq: postgresql = %version
 Requires:   glibc-locale
 Requires:   timezone


commit postgresql11 for openSUSE:Factory

2021-02-23 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2021-02-23 20:17:50

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.2378 (New)


Package is "postgresql11"

Tue Feb 23 20:17:50 2021 rev:14 rq:873820 version:11.11

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2021-01-08 17:34:02.093103062 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.2378/postgresql11.changes  
2021-02-23 20:18:02.795530602 +0100
@@ -1,0 +2,15 @@
+Fri Feb 19 15:30:08 UTC 2021 - Reinhard Max 
+
+- boo#1179945: Disable icu for PostgreSQL 10 (and older) on TW.
+
+---
+Wed Feb 10 15:33:08 UTC 2021 - Reinhard Max 
+
+Upgrade to version 11.11:
+  * https://www.postgresql.org/docs/11/release-11-11.html  
+  * Reindexing might be needed after applying this update.
+  * CVE-2021-3393, bsc#1182040: Fix information leakage in
+constraint-violation error messages.
+  * Obsoletes postgresql-icu68.patch.
+
+---

Old:

  postgresql-11.10.tar.bz2
  postgresql-11.10.tar.bz2.sha256
  postgresql-icu68.patch

New:

  postgresql-11.11.tar.bz2
  postgresql-11.11.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.VCGXB8/_old  2021-02-23 20:18:03.511531236 +0100
+++ /var/tmp/diff_new_pack.VCGXB8/_new  2021-02-23 20:18:03.519531243 +0100
@@ -1,7 +1,7 @@
 #
 # spec file for package postgresql11
 #
-# Copyright (c) 2020 SUSE LLC
+# Copyright (c) 2021 SUSE LLC
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.10
+%define pgversion 11.11
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
@@ -72,7 +72,11 @@
 BuildRequires:  timezone
 BuildRequires:  zlib-devel
 %bcond_without  selinux
+%if %pgmajor > 10 || 0%{?suse_version} <= 1500
 %bcond_without  icu
+%else
+%bcond_with icu
+%endif
 %if  !%buildlibs
 BuildRequires:  %libecpg
 BuildRequires:  %libpq
@@ -145,7 +149,6 @@
 Patch6: postgresql-testsuite-int8.sql.patch
 Patch8: postgresql-testsuite-keep-results-file.patch
 Patch9: postgresql-var-run-socket.patch
-Patch10:postgresql-icu68.patch
 URL:https://www.postgresql.org/
 BuildRoot:  %{_tmppath}/%{name}-%{version}-build
 Provides:   postgresql = %version-%release
@@ -453,7 +456,6 @@
 %patch6
 %patch8 -p1
 %patch9
-%patch10 -p1
 touch -r tmp configure
 rm tmp
 find src/test/ -name '*.orig' -delete

++ postgresql-11.10.tar.bz2 -> postgresql-11.11.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.10.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.2378/postgresql-11.11.tar.bz2 
differ: char 11, line 1

++ postgresql-11.10.tar.bz2.sha256 -> postgresql-11.11.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.10.tar.bz2.sha256 
2020-11-15 15:26:16.715444201 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.2378/postgresql-11.11.tar.bz2.sha256
   2021-02-23 20:18:02.763530574 +0100
@@ -1 +1 @@
-13e6d2f80662fe463bc7718cdf0de6a9ec67fc78afcc7a3ae66b9ea19bb97899  
postgresql-11.10.tar.bz2
+40607b7fa15b7d63f5075a7277daf7b3412486aa5db3aedffdb7768b9298186c  
postgresql-11.11.tar.bz2


commit postgresql11 for openSUSE:Factory

2020-12-10 Thread User for buildservice source handling
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2020-12-10 15:56:46

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.2328 (New)


Package is "postgresql11"

Thu Dec 10 15:56:46 2020 rev:12 rq:854084 version:11.10

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2020-11-15 15:26:17.911445481 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.2328/postgresql11.changes  
2020-12-10 15:56:47.922778893 +0100
@@ -1,0 +2,7 @@
+Fri Nov 20 11:51:37 UTC 2020 - Reinhard Max 
+
+- bsc#1178961: %ghost the symlinks to pg_config and ecpg.
+- boo#1179765: BuildRequire libpq5 and libecpg6 when not building
+  them to avoid dangling symlinks in the devel package.
+
+---



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.IlSNdc/_old  2020-12-10 15:56:48.906779819 +0100
+++ /var/tmp/diff_new_pack.IlSNdc/_new  2020-12-10 15:56:48.910779824 +0100
@@ -73,6 +73,10 @@
 BuildRequires:  zlib-devel
 %bcond_without  selinux
 %bcond_without  icu
+%if  !%buildlibs
+BuildRequires:  %libecpg
+BuildRequires:  %libpq
+%endif
 %if 0%{?suse_version} >= 1300
 %bcond_without  systemd
 %bcond_without  systemd_notify
@@ -917,7 +921,7 @@
 %defattr(-,root,root)
 %dir %pgbasedir
 %dir %pgbindir
-%_bindir/ecpg
+%ghost %_bindir/ecpg
 %_libdir/pkgconfig/*
 %_libdir/lib*.so
 %pgbindir/ecpg
@@ -932,7 +936,7 @@
 %files server-devel -f server-devel.files
 %endif
 %defattr(-,root,root)
-%_bindir/pg_config
+%ghost %_bindir/pg_config
 %pgbindir/pg_config
 %pgincludedir/server
 %pglibdir/pgxs
___
openSUSE Commits mailing list -- commit@lists.opensuse.org
To unsubscribe, email commit-le...@lists.opensuse.org
List Netiquette: https://en.opensuse.org/openSUSE:Mailing_list_netiquette
List Archives: 
https://lists.opensuse.org/archives/list/commit@lists.opensuse.org


[opensuse-commit] commit postgresql11 for openSUSE:Factory

2020-11-15 Thread User for buildservice source handling
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2020-11-15 15:25:03

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.24930 (New)


Package is "postgresql11"

Sun Nov 15 15:25:03 2020 rev:11 rq:848145 version:11.10

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2020-11-03 15:59:38.658390214 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.24930/postgresql11.changes 
2020-11-15 15:26:17.911445481 +0100
@@ -1,0 +2,21 @@
+Wed Nov 11 12:08:53 UTC 2020 - Reinhard Max 
+
+- Upgrade to version 11.10:
+  * CVE-2020-25695, bsc#1178666: Block DECLARE CURSOR ... WITH HOLD
+and firing of deferred triggers within index expressions and
+materialized view queries.
+  * CVE-2020-25694, bsc#1178667:
+a) Fix usage of complex connection-string parameters in pg_dump,
+pg_restore, clusterdb, reindexdb, and vacuumdb.
+b) When psql's \connect command re-uses connection parameters,
+ensure that all non-overridden parameters from a previous
+connection string are re-used.
+  * CVE-2020-25696, bsc#1178668: Prevent psql's \gset command from
+modifying specially-treated variables.
+  * Fix recently-added timetz test case so it works when the USA
+is not observing daylight savings time.
+(obsoletes postgresql-timetz.patch)
+  * https://www.postgresql.org/about/news/2111/
+  * https://www.postgresql.org/docs/11/release-11-10.html
+
+---

Old:

  postgresql-11.9.tar.bz2
  postgresql-11.9.tar.bz2.sha256
  postgresql-timetz.patch

New:

  postgresql-11.10.tar.bz2
  postgresql-11.10.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.zrklXd/_old  2020-11-15 15:26:19.963447677 +0100
+++ /var/tmp/diff_new_pack.zrklXd/_new  2020-11-15 15:26:19.967447681 +0100
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.9
+%define pgversion 11.10
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
@@ -141,7 +141,6 @@
 Patch6: postgresql-testsuite-int8.sql.patch
 Patch8: postgresql-testsuite-keep-results-file.patch
 Patch9: postgresql-var-run-socket.patch
-Patch10:postgresql-timetz.patch
 URL:https://www.postgresql.org/
 BuildRoot:  %{_tmppath}/%{name}-%{version}-build
 Provides:   postgresql = %version-%release
@@ -449,7 +448,6 @@
 %patch6
 %patch8 -p1
 %patch9
-%patch10
 touch -r tmp configure
 rm tmp
 find src/test/ -name '*.orig' -delete
@@ -623,20 +621,23 @@
vacuumdb \
reindexdb \
pg_basebackup \
-%if %pgsuffix < 90
-   pg_receivewal \
-%else
+   pg_isready \
+   pg_recvlogical \
+%if %pgsuffix >= 90
createlang \
droplang \
pg_receivexlog \
-%endif
-   pg_isready \
-   pg_recvlogical \
+%else
+   pg_receivewal \
 %if %pgsuffix == 11
pg_verify_checksums \
 %endif
-%if %pgsuffix == 12
-   pg_checksums
+%if %pgsuffix >= 12
+   pg_checksums \
+%endif
+%if %pgsuffix >= 13
+   pg_verifybackup
+%endif
 %endif
 
 %find_lang plpgsql-$VLANG main.files
@@ -875,6 +876,7 @@
 
 %if %{with llvm}
 %files llvmjit
+%defattr(-,root,root)
 %pglibdir/llvm*
 %pglibdir/bitcode/*
 %endif

++ postgresql-11.9.tar.bz2 -> postgresql-11.10.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.9.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.24930/postgresql-11.10.tar.bz2 
differ: char 11, line 1

++ postgresql-11.9.tar.bz2.sha256 -> postgresql-11.10.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.9.tar.bz2.sha256  
2020-08-15 21:14:07.427410403 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.24930/postgresql-11.10.tar.bz2.sha256
  2020-11-15 15:26:16.715444201 +0100
@@ -1 +1 @@
-35618aa72e0372091f923c42389c6febd07513157b4fbb9408371706afbb6635  
postgresql-11.9.tar.bz2
+13e6d2f80662fe463bc7718cdf0de6a9ec67fc78afcc7a3ae66b9ea19bb97899  
postgresql-11.10.tar.bz2
___
openSUSE Commits mailing list -- commit@lists.opensuse.org
To unsubscribe, email commit-le...@lists.opensuse.org
List Netiquette: https://en.opensuse.org/openSUSE:Mailing_list_netiquette
List Archives: 
https://lists.opensuse.org/archives/list/commit@lists.opensuse.org