commit postgresql14 for openSUSE:Factory

2024-05-10 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql14 for openSUSE:Factory 
checked in at 2024-05-10 12:05:15

Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql14.new.1880 (New)


Package is "postgresql14"

Fri May 10 12:05:15 2024 rev:18 rq:1172962 version:14.12

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2024-03-04 21:25:58.076206758 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1880/postgresql14.changes  
2024-05-10 12:06:26.828341923 +0200
@@ -1,0 +2,23 @@
+Wed May  8 12:07:46 UTC 2024 - Reinhard Max 
+
+- Upgrade to 14.12 (bsc#1224051):
+  * bsc#1224038, CVE-2024-4317: Restrict visibility of pg_stats_ext
+and pg_stats_ext_exprs entries to the table owner. See the
+release notes for the steps that have to be taken to fix
+existing PostgreSQL instances.
+  * Fix incompatibility with LLVM 18.
+  * https://www.postgresql.org/docs/release/14.12/
+- Prepare for PostgreSQL 17.
+- Make sure all compilation and doc generation happens in %build.
+
+---
+Wed May  1 15:24:39 UTC 2024 - Aaron Puchert 
+
+- Require LLVM <= 17 for now, because LLVM 18 doesn't seem to work.
+
+---
+Thu Mar  7 15:04:40 UTC 2024 - Sarah Kriesch 
+
+- Remove constraints file because improved memory usage for s390x
+
+---

Old:

  _constraints
  postgresql-14.11.tar.bz2
  postgresql-14.11.tar.bz2.sha256

New:

  postgresql-14.12.tar.bz2
  postgresql-14.12.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.xUAagl/_old  2024-05-10 12:06:27.852379237 +0200
+++ /var/tmp/diff_new_pack.xUAagl/_new  2024-05-10 12:06:27.856379382 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 14.11
+%define pgversion 14.12
 %define pgmajor 14
 %define buildlibs 0
 %define tarversion %{pgversion}
@@ -59,6 +59,12 @@
 %define python python
 %endif
 
+%if %pgmajor >= 17
+%bcond_with dreived
+%else
+%bcond_without derived
+%endif
+
 %if 0%{?suse_version} >= 1500
 %bcond_without liblz4
 %endif
@@ -88,6 +94,12 @@
 %if %{with liblz4}
 BuildRequires:  pkgconfig(liblz4)
 %endif
+%if %{without derived}
+BuildRequires:  bison
+BuildRequires:  docbook-xsl-stylesheets
+BuildRequires:  flex
+BuildRequires:  perl
+%endif
 
 %if %{with libzstd}
 BuildRequires:  pkgconfig(libzstd)
@@ -573,7 +585,7 @@
 %if %mini
 make -C src/interfaces %{?_smp_mflags} PACKAGE_TARNAME=%pgname
 %else
-make %{?_smp_mflags} PACKAGE_TARNAME=%pgname
+make %{?_smp_mflags} PACKAGE_TARNAME=%pgname world
 
 %if %{with check}
 
@@ -641,9 +653,9 @@
  > contrib.files
 rm flag
 install -d -m 750 %buildroot/var/lib/pgsql
-install -d -m755 %buildroot%pgdocdir
+install -d -m 755 %buildroot%pgdocdir
 cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \
-   README HISTORY  %buildroot%pgdocdir
+   README* HISTORY  %buildroot%pgdocdir
 # Use versioned names for the man pages:
 for f in %buildroot%pgmandir/man*/*; do
 mv $f ${f}pg%pgmajor
@@ -701,6 +713,7 @@
pg_receivewal \
pg_verify_checksums \
pg_checksums \
+   pg_combinebackup \
pg_verifybackup
 
 %find_lang plpgsql-$VLANG main.files
@@ -711,6 +724,8 @@
pg_ctl \
pg_controldata \
pg_resetwal \
+   pg_createsubscriber \
+   pg_walsummary \
pg_waldump \
pg_resetxlog \
 %if %pgmajor >= 15
@@ -924,7 +939,6 @@
 
 %files llvmjit-devel
 %defattr(-,root,root)
-%doc README
 
 %files pltcl -f pltcl.lang
 %defattr(-,root,root)

++ postgresql-14.11.tar.bz2 -> postgresql-14.12.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.11.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.1880/postgresql-14.12.tar.bz2 
differ: char 11, line 1

++ postgresql-14.11.tar.bz2.sha256 -> postgresql-14.12.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.11.tar.bz2.sha256 
2024-02-09 23:53:17.401061341 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql14.new.1880/postgresql-14.12.tar.bz2.sha256
   2024-05-10 12:06:26.716337842 +0200
@@ -1 +1 @@
-a670bd7dce22dcad4297b261136b3b1d4a09a6f541719562aa14ca63bf2968a8  
postgresql-14.11.tar.bz2
+6118d08f9ddcc1bd83cf2b7cc74d3b583bdcec2f37e6245a8ac003b8faa80923  
postgresql-14.12.tar.bz2


commit postgresql14 for openSUSE:Factory

2024-02-09 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql14 for openSUSE:Factory 
checked in at 2024-02-09 23:52:55

Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql14.new.1815 (New)


Package is "postgresql14"

Fri Feb  9 23:52:55 2024 rev:16 rq:1145270 version:14.11

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-11-09 21:36:33.815467479 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1815/postgresql14.changes  
2024-02-09 23:53:17.409061630 +0100
@@ -1,0 +2,18 @@
+Thu Feb  8 14:10:04 UTC 2024 - Reinhard Max 
+
+- Upgrade to 14.11:
+  * bsc#1219679, CVE-2024-0985: Tighten security restrictions
+within REFRESH MATERIALIZED VIEW CONCURRENTLY.
+One step of a concurrent refresh command was run under weak
+security restrictions. If a materialized view's owner could
+persuade a superuser or other high-privileged user to perform a
+concurrent refresh on that view, the view's owner could control
+code executed with the privileges of the user running REFRESH.
+Fix things so that all user-determined code is run as the
+view's owner, as expected
+  * If you use GIN indexes, you may need to reindex after updating
+to this release.
+  * LLVM 18 is now supported.
+  * https://www.postgresql.org/docs/release/14.11/
+
+---
@@ -30 +47,0 @@
-  * https://www.postgresql.org/about/news/2749

Old:

  postgresql-14.10.tar.bz2
  postgresql-14.10.tar.bz2.sha256

New:

  postgresql-14.11.tar.bz2
  postgresql-14.11.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.v2svXH/_old  2024-02-09 23:53:18.109086855 +0100
+++ /var/tmp/diff_new_pack.v2svXH/_new  2024-02-09 23:53:18.109086855 +0100
@@ -1,7 +1,7 @@
 #
-# spec file
+# spec file for package postgresql14
 #
-# Copyright (c) 2023 SUSE LLC
+# Copyright (c) 2024 SUSE LLC
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -16,11 +16,11 @@
 #
 
 
-%define pgversion 14.10
+%define pgversion 14.11
 %define pgmajor 14
 %define buildlibs 0
 %define tarversion %{pgversion}
-%define latest_supported_llvm_ver 17
+%define latest_supported_llvm_ver 18
 
 ### CUT HERE ###
 %define pgname postgresql%pgmajor
@@ -187,7 +187,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
@@ -277,7 +277,7 @@
 Provides:   postgresql-server-devel = %version-%release
 Provides:   postgresql-server-devel-implementation = %version-%release
 Requires(post): postgresql-server-devel-noarch >= %pgmajor
-Requires(postun):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
@@ -335,10 +335,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
@@ -377,7 +377,7 @@
 %if %{with llvm}
 Requires:   %pgname-llvmjit = %version
 Requires(post): postgresql-llvmjit-devel-noarch >= %pgmajor
-Requires(postun):postgresql-llvmjit-devel-noarch >= %pgmajor
+Requires(postun): postgresql-llvmjit-devel-noarch >= %pgmajor
 %requires_file %_bindir/llc
 %requires_file %_bindir/clang
 %endif

++ postgresql-14.10.tar.bz2 -> postgresql-14.11.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.10.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.1815/postgresql-14.11.tar.bz2 
differ: char 11, line 1

++ postgresql-14.10.tar.bz2.sha256 -> postgresql-14.11.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.10.tar.bz2.sha256 
2023-11

commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2023-11-09 21:36:15

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


Package is "postgresql14"

Thu Nov  9 21:36:15 2023 rev:15 rq:1124707 version:14.10

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-10-31 20:26:50.344450871 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.17445/postgresql14.changes 
2023-11-09 21:36:33.815467479 +0100
@@ -1,0 +2,32 @@
+Wed Nov  8 14:32:26 UTC 2023 - Reinhard Max 
+
+- Update to 14.10:
+  * 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/14/release-14-10.html
+
+---

Old:

  postgresql-14.9.tar.bz2
  postgresql-14.9.tar.bz2.sha256

New:

  postgresql-14.10.tar.bz2
  postgresql-14.10.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.r88YSr/_old  2023-11-09 21:36:34.559494950 +0100
+++ /var/tmp/diff_new_pack.r88YSr/_new  2023-11-09 21:36:34.559494950 +0100
@@ -16,11 +16,11 @@
 #
 
 
-%define pgversion 14.9
+%define pgversion 14.10
 %define pgmajor 14
 %define buildlibs 0
 %define tarversion %{pgversion}
-%define latest_supported_llvm_ver 15
+%define latest_supported_llvm_ver 17
 
 ### CUT HERE ###
 %define pgname postgresql%pgmajor
@@ -797,11 +797,9 @@
 
 %post -n %pgname-%devel
 /sbin/ldconfig
-/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

++ postgresql-14.9.tar.bz2 -> postgresql-14.10.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.9.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.17445/postgresql-14.10.tar.bz2 
differ: char 11, line 1

++ postgresql-14.9.tar.bz2.sha256 -> postgresql-14.10.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.9.tar.bz2.sha256  
2023-10-25 18:05:36.536065373 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql14.new.17445/postgresql-14.10.tar.bz2.sha256
  2023-11-09 21:36:33.807467184 +0100
@@ -1 +1 @@
-b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef  
postgresql-14.9.tar.bz2
+c99431c48e9d470b0d0ab946eb2141a3cd19130c2fb4dc4b3284a7774ecc8399  
postgresql-14.10.tar.bz2


commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2023-10-31 20:26:33

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


Package is "postgresql14"

Tue Oct 31 20:26:33 2023 rev:14 rq:1121434 version:14.9

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-10-25 18:05:36.720071561 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.17445/postgresql14.changes 
2023-10-31 20:26:50.344450871 +0100
@@ -1,0 +2,6 @@
+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.
+
+---



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.IxVPON/_old  2023-10-31 20:26:51.064477318 +0100
+++ /var/tmp/diff_new_pack.IxVPON/_new  2023-10-31 20:26:51.064477318 +0100
@@ -760,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
@@ -960,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


commit postgresql14 for openSUSE:Factory

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

here is the log from the commit of package postgresql14 for openSUSE:Factory 
checked in at 2023-10-25 18:04:45

Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql14.new.24901 (New)


Package is "postgresql14"

Wed Oct 25 18:04:45 2023 rev:13 rq:1120251 version:14.9

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-05-12 20:40:03.562781445 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.24901/postgresql14.changes 
2023-10-25 18:05:36.720071561 +0200
@@ -1,0 +2,39 @@
+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.
+
+---
+Wed Aug  9 09:42:33 UTC 2023 - Reinhard Max 
+
+- Update to 14.9:
+  * 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/14/release-14-9.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:21:03 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.
+
+---

Old:

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

New:

  postgresql-14.9.tar.bz2
  postgresql-14.9.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.sx6ZIP/_old  2023-10-25 18:05:37.532098871 +0200
+++ /var/tmp/diff_new_pack.sx6ZIP/_new  2023-10-25 18:05:37.536099006 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 14.8
+%define pgversion 14.9
 %define pgmajor 14
 %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,22 @@
 BuildRequires:  pkgconfig(krb5)
 BuildRequires:  pkgconfig(libsystemd)
 BuildRequires:  pkgconfig(systemd)
+#!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
 #!BuildIgnore:  postgresql-implementation
 #!BuildIgnore:  postgresql-server-implementation
-#!BuildIgnore:  postgresql-devel-noarch
-#!BuildIgnore:  postgresql-llvmjit-devel-noarch
-#!BuildIgnore:  postgresql-server-devel-noarch
+#!BuildIgnore:  postgresql-server-devel-implementation
+#!BuildIgnore:  postgresql-llvmjit-devel-implementation
 Summary:Basic Clients and Utilities for PostgreSQL
 License:PostgreSQL
 Group:  Productivity/Databases/Tools
@@ -156,7 +171,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)
@@ -495,7 +509,7 @@
 touch -r configure tmp
 %patch1
 %patch4
-%patch8 -p1
+%patch8
 %patch9
 %if %{with llvm}
 %patch10
@@ -630,7 +644,6 @@
 install -d -m755 %buildroot%pgdocdir
 cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \
README HISTORY  %buildroot%pgdocdir
-c

commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2023-05-12 20:37:13

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


Package is "postgresql14"

Fri May 12 20:37:13 2023 rev:12 rq:1086555 version:14.8

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-04-21 14:17:56.086891271 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1533/postgresql14.changes  
2023-05-12 20:40:03.562781445 +0200
@@ -1,0 +2,11 @@
+Wed May 10 12:58:22 UTC 2023 - Reinhard Max 
+
+- Update to 14.8:
+  * 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/14/release-14-8.html
+
+---

Old:

  postgresql-14.7.tar.bz2
  postgresql-14.7.tar.bz2.sha256

New:

  postgresql-14.8.tar.bz2
  postgresql-14.8.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.LWdUhQ/_old  2023-05-12 20:40:04.350785776 +0200
+++ /var/tmp/diff_new_pack.LWdUhQ/_new  2023-05-12 20:40:04.382785952 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 14.7
+%define pgversion 14.8
 %define pgmajor 14
 %define buildlibs 0
 %define tarversion %{pgversion}

++ postgresql-14.7.tar.bz2 -> postgresql-14.8.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.7.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.1533/postgresql-14.8.tar.bz2 
differ: char 11, line 1

++ postgresql-14.7.tar.bz2.sha256 -> postgresql-14.8.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.7.tar.bz2.sha256  
2023-02-10 14:33:57.861434372 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql14.new.1533/postgresql-14.8.tar.bz2.sha256
2023-05-12 20:40:03.546781358 +0200
@@ -1 +1 @@
-cef60f0098fa8101c1546f4254e45b722af5431337945b37af207007630db331  
postgresql-14.7.tar.bz2
+39d38f0030737ed03835debeefee3b37d335462ce4995e2497bc38d621ebe45a  
postgresql-14.8.tar.bz2


commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2023-04-21 14:17:45

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


Package is "postgresql14"

Fri Apr 21 14:17:45 2023 rev:11 rq:1081146 version:14.7

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-02-10 14:33:57.865434396 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1533/postgresql14.changes  
2023-04-21 14:17:56.086891271 +0200
@@ -1,0 +2,12 @@
+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.
+
+---
+Tue Apr  4 10:57:41 UTC 2023 - Fabian Vogt 
+
+- Include -mini in Name: to avoid conflicts in the source package
+  name and OBS internal dependency tracking.
+
+---



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.kMyRxg/_old  2023-04-21 14:17:57.442898873 +0200
+++ /var/tmp/diff_new_pack.kMyRxg/_new  2023-04-21 14:17:57.446898896 +0200
@@ -18,7 +18,6 @@
 
 %define pgversion 14.7
 %define pgmajor 14
-%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 serve

commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2023-02-10 14:33:52

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


Package is "postgresql14"

Fri Feb 10 14:33:52 2023 rev:10 rq:1064055 version:14.7

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2022-11-12 17:40:51.958059696 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1848/postgresql14.changes  
2023-02-10 14:33:57.865434396 +0100
@@ -1,0 +2,9 @@
+Thu Feb  9 12:00:06 UTC 2023 - Reinhard Max 
+
+- Update to 14.7:
+  * CVE-2022-41862, bsc#1208102: memory leak in libpq
+  * https://www.postgresql.org/about/news/2592/
+  * https://www.postgresql.org/docs/14/release-14-7.html
+- Bump latest_supported_llvm_ver to 15.
+
+---

Old:

  postgresql-14.6.tar.bz2
  postgresql-14.6.tar.bz2.sha256

New:

  postgresql-14.7.tar.bz2
  postgresql-14.7.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.CEPbpI/_old  2023-02-10 14:33:58.469438005 +0100
+++ /var/tmp/diff_new_pack.CEPbpI/_new  2023-02-10 14:33:58.473438029 +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 14.6
+%define pgversion 14.7
 %define pgmajor 14
 %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-14.6.tar.bz2 -> postgresql-14.7.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.6.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.1848/postgresql-14.7.tar.bz2 
differ: char 11, line 1

++ postgresql-14.6.tar.bz2.sha256 -> postgresql-14.7.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.6.tar.bz2.sha256  
2022-11-12 17:40:51.930059529 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql14.new.1848/postgresql-14.7.tar.bz2.sha256
2023-02-10 14:33:57.861434372 +0100
@@ -1 +1 @@
-508840fc1809d39ab72274d5f137dabb9fd7fb4f933da4168aeebb20069edf22  
postgresql-14.6.tar.bz2
+cef60f0098fa8101c1546f4254e45b722af5431337945b37af207007630db331  
postgresql-14.7.tar.bz2


commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2022-11-12 17:40:42

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


Package is "postgresql14"

Sat Nov 12 17:40:42 2022 rev:9 rq:1035222 version:14.6

Changes:

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

Old:

  postgresql-14.5.tar.bz2
  postgresql-14.5.tar.bz2.sha256

New:

  postgresql-14.6.tar.bz2
  postgresql-14.6.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.LzO61D/_old  2022-11-12 17:40:52.834064911 +0100
+++ /var/tmp/diff_new_pack.LzO61D/_new  2022-11-12 17:40:52.834064911 +0100
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 14.5
+%define pgversion 14.6
 %define pgmajor 14
 %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/share/pos

commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2022-10-04 20:37:31

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


Package is "postgresql14"

Tue Oct  4 20:37:31 2022 rev:8 rq:1006977 version:14.5

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2022-08-16 17:06:48.623710641 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.2275/postgresql14.changes  
2022-10-04 20:37:34.740903780 +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:32:36 UTC 2022 - Reinhard Max 
+
+- Sync spec file with postgresql15.
+
+---
+Mon Sep 12 07:52:42 UTC 2022 - Andreas Schwab 
+
+- Disable LLVM JIT on riscv64
+
+---

Old:

  _multibuild



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.JQa9Nt/_old  2022-10-04 20:37:36.252905930 +0200
+++ /var/tmp/diff_new_pack.JQa9Nt/_new  2022-10-04 20:37:36.260905941 +0200
@@ -19,8 +19,9 @@
 %define pgversion 14.5
 %define pgmajor 14
 %define pgsuffix %pgmajor
-%define buildlibs 1
+%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 postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2022-08-16 17:06:44

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


Package is "postgresql14"

Tue Aug 16 17:06:44 2022 rev:7 rq:995185 version:14.5

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2022-06-21 17:15:06.690327282 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1521/postgresql14.changes  
2022-08-16 17:06:48.623710641 +0200
@@ -1,0 +2,8 @@
+Fri Aug 12 11:24:35 UTC 2022 - Reinhard Max 
+
+-  Update to 14.5:
+  * bsc#1202368, CVE-2022-2625: Extension scripts replace objects
+not belonging to the extension.
+  * https://www.postgresql.org/docs/release/14.5/
+
+---

Old:

  postgresql-14.4.tar.bz2
  postgresql-14.4.tar.bz2.sha256

New:

  postgresql-14.5.tar.bz2
  postgresql-14.5.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.8N1PHi/_old  2022-08-16 17:06:49.455713129 +0200
+++ /var/tmp/diff_new_pack.8N1PHi/_new  2022-08-16 17:06:49.459713141 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 14.4
+%define pgversion 14.5
 %define pgmajor 14
 %define pgsuffix %pgmajor
 %define buildlibs 1

++ postgresql-14.4.tar.bz2 -> postgresql-14.5.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.4.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.1521/postgresql-14.5.tar.bz2 
differ: char 11, line 1

++ postgresql-14.4.tar.bz2.sha256 -> postgresql-14.5.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.4.tar.bz2.sha256  
2022-06-21 17:15:06.678327271 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql14.new.1521/postgresql-14.5.tar.bz2.sha256
2022-08-16 17:06:48.535710378 +0200
@@ -1 +1 @@
-c23b6237c5231c791511bdc79098617d6852e9e3bdf360efd8b5d15a1a3d8f6a  
postgresql-14.4.tar.bz2
+d4f72cb5fb857c9a9f75ec8cf091a1771272802f2178f0b2e65b7b6ff64f4a30  
postgresql-14.5.tar.bz2


commit postgresql14 for openSUSE:Factory

2022-06-21 Thread Source-Sync
Script 'mail_helper' called by obssrc
Hello community,

here is the log from the commit of package postgresql14 for openSUSE:Factory 
checked in at 2022-06-21 17:15:05

Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql14.new.1548 (New)


Package is "postgresql14"

Tue Jun 21 17:15:05 2022 rev:6 rq:983858 version:14.4

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2022-05-14 22:54:54.891197325 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1548/postgresql14.changes  
2022-06-21 17:15:06.690327282 +0200
@@ -1,0 +2,9 @@
+Fri Jun 17 06:32:15 UTC 2022 - Reinhard Max 
+
+- bsc#1200437: Upgrade to 14.4:
+  * Prevent possible corruption of indexes created or rebuilt with 
+the CONCURRENTLY option.
+  * https://www.postgresql.org/docs/release/14.4/
+  * https://www.postgresql.org/about/news/p-2470/
+
+---

Old:

  postgresql-14.3.tar.bz2
  postgresql-14.3.tar.bz2.sha256

New:

  postgresql-14.4.tar.bz2
  postgresql-14.4.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.1NEZLv/_old  2022-06-21 17:15:07.710328321 +0200
+++ /var/tmp/diff_new_pack.1NEZLv/_new  2022-06-21 17:15:07.714328326 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 14.3
+%define pgversion 14.4
 %define pgmajor 14
 %define pgsuffix %pgmajor
 %define buildlibs 1

++ postgresql-14.3.tar.bz2 -> postgresql-14.4.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.3.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.1548/postgresql-14.4.tar.bz2 
differ: char 11, line 1

++ postgresql-14.3.tar.bz2.sha256 -> postgresql-14.4.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.3.tar.bz2.sha256  
2022-05-14 22:54:54.843197265 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql14.new.1548/postgresql-14.4.tar.bz2.sha256
2022-06-21 17:15:06.678327271 +0200
@@ -1 +1 @@
-279057368bf59a919c05ada8f95c5e04abb43e74b9a2a69c3d46a20e07a9af38  
postgresql-14.3.tar.bz2
+c23b6237c5231c791511bdc79098617d6852e9e3bdf360efd8b5d15a1a3d8f6a  
postgresql-14.4.tar.bz2


commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2022-05-14 22:54:47

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


Package is "postgresql14"

Sat May 14 22:54:47 2022 rev:5 rq:977049 version:14.3

Changes:

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

Old:

  postgresql-14.2.tar.bz2
  postgresql-14.2.tar.bz2.sha256

New:

  postgresql-14.3.tar.bz2
  postgresql-14.3.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.5ZzGoj/_old  2022-05-14 22:54:55.715198354 +0200
+++ /var/tmp/diff_new_pack.5ZzGoj/_new  2022-05-14 22:54:55.719198360 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 14.2
+%define pgversion 14.3
 %define pgmajor 14
 %define pgsuffix %pgmajor
 %define buildlibs 1
@@ -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-14.2.tar.bz2 -> postgresql-14.3.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.2.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.1538/postgresql-14.3.tar.bz2 
differ: char 11, line 1

++ postgresql-14.2.tar.bz2.sha256 -> postgresql-14.3.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.2.tar.bz2.sha256  
2022-04-14 17:23:10.343102580 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql14.new.1538/postgresql-14.3.tar.bz2.sha256
2022-05-14 22:54:54.843197265 +0200
@@ -1 +1 @@
-2cf78b2e468912f8101d695db5340cf313c2e9f68a612fb71427524e8c9a977a  
postgresql-14.2.tar.bz2
+279057368bf59a919c05ada8f95c5e04abb43e74b9a2a69c3d46a20e07a9af38  
postgresql-14.3.tar.bz2


commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2022-04-14 17:22:57

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


Package is "postgresql14"

Thu Apr 14 17:22:57 2022 rev:4 rq:969861 version:14.2

Changes:

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

Old:

  postgresql-14.1.tar.bz2
  postgresql-14.1.tar.bz2.sha256

New:

  _constraints
  postgresql-14.2.tar.bz2
  postgresql-14.2.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.gOFIyt/_old  2022-04-14 17:23:11.679104142 +0200
+++ /var/tmp/diff_new_pack.gOFIyt/_new  2022-04-14 17:23:11.683104146 +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 14.1
+%define pgversion 14.2
 %define pgmajor 14
 %define pgsuffix %pgmajor
 %define buildlibs 1
@@ -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-14.1.tar.bz2 -> postgresql-14.2.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.1.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.1941/postgresql-14.2.tar.bz2 
differ: char 11, line 1

++ postgresql-14.1.tar.bz2.sha256 -> postgresql-14.2.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.1.tar.bz2.sha256  
2021-11-13 22:48:15.925237970 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql14.new.1941/postgresql-14.2.tar.bz2.sha256
2022-04-14 17:23:10.343102580 +0200
@@ -1 +1 @@
-4d3c101ea7ae38982f06bdc73758b53727fb6402ecd9382006fa5ecc7c2ca41f  
postgresql-14.1.tar.bz2
+2cf78b2e468912f8101d695db5340cf313c2e9f68a612fb71427524e8c9a977a  
postgresql-14.2.tar.bz2


commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2021-12-06 23:59:24

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


Package is "postgresql14"

Mon Dec  6 23:59:24 2021 rev:3 rq:935204 version:14.1

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2021-11-13 22:48:15.953237991 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.31177/postgresql14.changes 
2021-12-07 00:00:30.720324665 +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:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.iuusKr/_old  2021-12-07 00:00:31.392322289 +0100
+++ /var/tmp/diff_new_pack.iuusKr/_new  2021-12-07 00:00:31.392322289 +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/*_and

commit postgresql14 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 postgresql14 for openSUSE:Factory 
checked in at 2021-11-13 22:48:08

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


Package is "postgresql14"

Sat Nov 13 22:48:08 2021 rev:2 rq:930949 version:14.1

Changes:

--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2021-10-12 21:48:16.863779619 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1890/postgresql14.changes  
2021-11-13 22:48:15.953237991 +0100
@@ -1,0 +2,15 @@
+Wed Nov 10 16:56:57 UTC 2021 - Reinhard Max 
+
+- bsc#1192516: Upgrade to 14.1
+  * 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/14/release-14-1.html
+
+---
+Wed Oct 20 15:21:53 UTC 2021 - Reinhard Max 
+
+- boo#1191782: Let rpmlint ignore shlib-policy-name-error.
+
+---
@@ -4,2 +18,0 @@
-- Let genlists skip non-existing binaries to avoid lots of version
-  conditionals in the file lists.

Old:

  postgresql-14.0.tar.bz2
  postgresql-14.0.tar.bz2.sha256

New:

  postgresql-14.1.tar.bz2
  postgresql-14.1.tar.bz2.sha256



Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.58wKE7/_old  2021-11-13 22:48:16.517238424 +0100
+++ /var/tmp/diff_new_pack.58wKE7/_new  2021-11-13 22:48:16.521238426 +0100
@@ -1,5 +1,5 @@
 #
-# spec file for package postgresql14
+# spec file
 #
 # Copyright (c) 2021 SUSE LLC
 #
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 14.0
+%define pgversion 14.1
 %define pgmajor 14
 %define pgsuffix %pgmajor
 %define buildlibs 1
@@ -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-14.0.tar.bz2 -> postgresql-14.1.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.0.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql14.new.1890/postgresql-14.1.tar.bz2 
differ: char 11, line 1

++ postgresql-14.0.tar.bz2.sha256 -> postgresql-14.1.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.0.tar.bz2.sha256  
2021-10-12 21:48:16.475779064 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql14.new.1890/postgresql-14.1.tar.bz2.sha256
2021-11-13 22:48:15.925237970 +0100
@@ -1 +1 @@
-ee2ad79126a7375e9102c4db77c4acae6ae6ffe3e082403b88826d96d927a122  
postgresql-14.0.tar.bz2
+4d3c101ea7ae38982f06bdc73758b53727fb6402ecd9382006fa5ecc7c2ca41f  
postgresql-14.1.tar.bz2

++ postgresql-rpmlintrc ++
--- /var/tmp/diff_new_pack.58wKE7/_old  2021-11-13 22:48:16.629238509 +0100
+++ /var/tmp/diff_new_pack.58wKE7/_new  2021-11-13 22:48:16.629238509 +0100
@@ -6,3 +6,4 @@
 addFilter("no-dependency-on")
 addFilter("no-soname")
 addFilter("devel-file-in-non-devel-package")
+addFilter("shlib-policy-name-error")