Accepting request 1172961 from server:database:postgresql

- Upgrade to 15.7 (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/15.7/
- Prepare for PostgreSQL 17.
- Make sure all compilation and doc generation happens in %build.

- Require LLVM <= 17 for now, because LLVM 18 doesn't seem to work.

- Remove constraints file because improved memory usage for s390x

OBS-URL: https://build.opensuse.org/request/show/1172961
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/postgresql15?expand=0&rev=16

_constraints

@@ -1,13 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<constraints>
-  <overwrite>
-   <conditions>
-     <arch>s390x</arch>
-   </conditions>
-    <hardware>
-     <memory>
-       <size unit="G">12</size>
-     </memory>
-   </hardware>
-  </overwrite>
-</constraints>

postgresql-15.6.tar.bz2

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:8455146ed9c69c93a57de954aead0302cafad035c2b242175d6aa1e17ebcb2fb
-size 23093967

postgresql-15.6.tar.bz2.sha256

@@ -1 +0,0 @@
-8455146ed9c69c93a57de954aead0302cafad035c2b242175d6aa1e17ebcb2fb  postgresql-15.6.tar.bz2

postgresql-15.7.tar.bz2

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:a46fe49485ab6385e39dabbbb654f5d3049206f76cd695e224268729520998f7
+size 23112318

postgresql-15.7.tar.bz2.sha256

@@ -0,0 +1 @@
+a46fe49485ab6385e39dabbbb654f5d3049206f76cd695e224268729520998f7  postgresql-15.7.tar.bz2

postgresql15.changes

@@ -1,3 +1,26 @@
+-------------------------------------------------------------------
+Wed May  8 12:05:25 UTC 2024 - Reinhard Max <max@suse.com>
+
+- Upgrade to 15.7 (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/15.7/
+- Prepare for PostgreSQL 17.
+- Make sure all compilation and doc generation happens in %build.
+
+-------------------------------------------------------------------
+Tue Mar 12 22:48:41 UTC 2024 - Aaron Puchert <aaronpuchert@alice-dsl.net>
+
+- Require LLVM <= 17 for now, because LLVM 18 doesn't seem to work.
+
+-------------------------------------------------------------------
+Thu Mar  7 15:04:40 UTC 2024 - Sarah Kriesch <sarah.kriesch@opensuse.org>
+
+- Remove constraints file because improved memory usage for s390x
+
 -------------------------------------------------------------------
 Thu Feb 29 14:36:57 UTC 2024 - Dominique Leuenberger <dimstar@opensuse.org>
 

postgresql15.spec

@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 15.6
+%define pgversion 15.7
 %define pgmajor 15
 %define buildlibs 0
 %define tarversion %{pgversion}
@@ -59,6 +59,12 @@ Name:           %pgname
 %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 @@ BuildRequires:  zlib-devel
 %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 @@ PACKAGE_TARNAME=%pgname %configure \
 %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 @@ find %buildroot -type f -cnewer flag -printf "/%%P\n" |
      > 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 @@ genlists main \
 	pg_receivewal \
 	pg_verify_checksums \
 	pg_checksums \
+	pg_combinebackup \
 	pg_verifybackup
 
 %find_lang plpgsql-$VLANG main.files
@@ -711,6 +724,8 @@ genlists server \
 	pg_ctl \
 	pg_controldata \
 	pg_resetwal \
+	pg_createsubscriber \
+	pg_walsummary \
 	pg_waldump \
 	pg_resetxlog \
 %if %pgmajor >= 15
@@ -924,7 +939,6 @@ fi
 
 %files llvmjit-devel
 %defattr(-,root,root)
-%doc README
 
 %files pltcl -f pltcl.lang
 %defattr(-,root,root)