Sync from SUSE:SLFO:Main postgresql15 revision f85d8c39ade3813a100ea7e8637be7da

2024-05-03 19:34:06 +02:00 · 2024-05-03 19:34:06 +02:00 · f6a1f2475e
commit f6a1f2475e
16 changed files with 1680 additions and 0 deletions
--- a/.gitattributes
+++ b/.gitattributes
@ -0,0 +1,23 @@
+## Default LFS
+*.7z filter=lfs diff=lfs merge=lfs -text
+*.bsp filter=lfs diff=lfs merge=lfs -text
+*.bz2 filter=lfs diff=lfs merge=lfs -text
+*.gem filter=lfs diff=lfs merge=lfs -text
+*.gz filter=lfs diff=lfs merge=lfs -text
+*.jar filter=lfs diff=lfs merge=lfs -text
+*.lz filter=lfs diff=lfs merge=lfs -text
+*.lzma filter=lfs diff=lfs merge=lfs -text
+*.obscpio filter=lfs diff=lfs merge=lfs -text
+*.oxt filter=lfs diff=lfs merge=lfs -text
+*.pdf filter=lfs diff=lfs merge=lfs -text
+*.png filter=lfs diff=lfs merge=lfs -text
+*.rpm filter=lfs diff=lfs merge=lfs -text
+*.tbz filter=lfs diff=lfs merge=lfs -text
+*.tbz2 filter=lfs diff=lfs merge=lfs -text
+*.tgz filter=lfs diff=lfs merge=lfs -text
+*.ttf filter=lfs diff=lfs merge=lfs -text
+*.txz filter=lfs diff=lfs merge=lfs -text
+*.whl filter=lfs diff=lfs merge=lfs -text
+*.xz filter=lfs diff=lfs merge=lfs -text
+*.zip filter=lfs diff=lfs merge=lfs -text
+*.zst filter=lfs diff=lfs merge=lfs -text
--- a/0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
+++ b/0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
@ -0,0 +1,96 @@
+From 0edaa982336823d4d7af8f10b91579fe0099ef3d Mon Sep 17 00:00:00 2001
+From: Tom Stellard <tstellar@redhat.com>
+Date: Tue, 20 Apr 2021 20:14:21 -0700
+Subject: [PATCH] jit: Workaround potential datalayout mismatch on s390x
+
+LLVM's s390x target uses a different datalayout for z13 and newer processors.
+If llvmjit_types.bc is compiled to target a processor older than z13, and
+then the JIT runs on a z13 or newer processor, then there will be a mismatch
+in datalayouts between llvmjit_types.bc and the JIT engine.  This mismatch
+causes the JIT to fail at runtime.
+---
+ src/backend/jit/llvm/llvmjit.c | 46 ++++++++++++++++++++++++++++++++--
+ 1 file changed, 44 insertions(+), 2 deletions(-)
+
+Index: src/backend/jit/llvm/llvmjit.c
+===================================================================
+--- src/backend/jit/llvm/llvmjit.c.orig
+++ src/backend/jit/llvm/llvmjit.c
+@@ -777,6 +777,35 @@ llvm_compile_module(LLVMJitContext *cont
+ }
+ 
+ /*
+ * For the systemz target, LLVM uses a different datalayout for z13 and newer
+ * CPUs than it does for older CPUs.  This can cause a mismatch in datalayouts
+ * in the case where the llvm_types_module is compiled with a pre-z13 CPU
+ * and the JIT is running on z13 or newer.
+ * See computeDataLayout() function in
+ * llvm/lib/Target/SystemZ/SystemZTargetMachine.cpp for information on the
+ * datalayout differences.
+ */
+static bool
+needs_systemz_workaround(void)
+{
+	bool ret = false;
+	LLVMContextRef llvm_context;
+	LLVMTypeRef vec_type;
+	LLVMTargetDataRef llvm_layoutref;
+	if (strncmp(LLVMGetTargetName(llvm_targetref), "systemz", strlen("systemz")))
+	{
+		return false;
+	}
+
+	llvm_context = LLVMGetModuleContext(llvm_types_module);
+	vec_type = LLVMVectorType(LLVMIntTypeInContext(llvm_context, 32), 4);
+	llvm_layoutref = LLVMCreateTargetData(llvm_layout);
+	ret = (LLVMABIAlignmentOfType(llvm_layoutref, vec_type) == 16);
+	LLVMDisposeTargetData(llvm_layoutref);
+	return ret;
+}
+
+/*
+  * Per session initialization.
+  */
+ static void
+@@ -785,6 +814,7 @@ llvm_session_initialize(void)
+ 	MemoryContext oldcontext;
+ 	char	   *error = NULL;
+ 	char	   *cpu = NULL;
+	char       *host_features = NULL;
+ 	char	   *features = NULL;
+ 	LLVMTargetMachineRef opt0_tm;
+ 	LLVMTargetMachineRef opt3_tm;
+@@ -816,10 +846,17 @@ llvm_session_initialize(void)
+ 	 * features not all CPUs have (weird, huh).
+ 	 */
+ 	cpu = LLVMGetHostCPUName();
+-	features = LLVMGetHostCPUFeatures();
+	features = host_features = LLVMGetHostCPUFeatures();
+ 	elog(DEBUG2, "LLVMJIT detected CPU \"%s\", with features \"%s\"",
+ 		 cpu, features);
+ 
+	if (needs_systemz_workaround())
+	{
+		const char *no_vector =",-vector";
+		features = malloc(sizeof(char) * (strlen(host_features) + strlen(no_vector) + 1));
+		sprintf(features, "%s%s", host_features, no_vector);
+	}
+
+ 	opt0_tm =
+ 		LLVMCreateTargetMachine(llvm_targetref, llvm_triple, cpu, features,
+ 								LLVMCodeGenLevelNone,
+@@ -833,8 +870,13 @@ llvm_session_initialize(void)
+ 
+ 	LLVMDisposeMessage(cpu);
+ 	cpu = NULL;
+-	LLVMDisposeMessage(features);
+	if (features != host_features)
+	{
+		free(features);
+	}
+ 	features = NULL;
+	LLVMDisposeMessage(host_features);
+	host_features = NULL;
+ 
+ 	/* force symbols in main binary to be loaded */
+ 	LLVMLoadLibraryPermanently(NULL);
--- a/13
+++ b/13
@ -0,0 +1,13 @@
+<?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>
--- a/3
+++ b/3
@ -0,0 +1,3 @@
+<multibuild>
+  <package>mini</package>
+</multibuild>
--- a/baselibs.conf
+++ b/baselibs.conf
@ -0,0 +1,5 @@
+libpq5
+	provides  "postgresql-libs-<targettype> = <version>"
+	obsoletes "postgresql-libs-<targettype> < <version>"
+	conflicts "postgresql-libs-<targettype> < 9.1.6"
+libecpg6
--- a/postgresql-15.4.tar.bz2
+++ b/postgresql-15.4.tar.bz2
--- a/postgresql-15.4.tar.bz2.sha256
+++ b/postgresql-15.4.tar.bz2.sha256
@ -0,0 +1 @@
+baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9  postgresql-15.4.tar.bz2
--- a/postgresql-README.SUSE
+++ b/postgresql-README.SUSE
@ -0,0 +1,80 @@
+Unix-Domain Socket Directory
+============================
+
+
+
+Upgrading PostgreSQL on openSUSE and SUSE Linux Enterprise Server
+=================================================================
+
+Current versions of PostgreSQL come with the pg_upgrade tool that
+simplifies and speeds up the migration of a PostgreSQL installation to
+a new version. Before version 9.1 dump and restore was needed which
+was much slower.
+
+pg_upgrade needs to have the server binaries of both versions
+available. To allow this, we had to change the way PostgreSQL is
+packaged as well as the naming of the packages, so that two or more
+versions of PostgreSQL can be installed in parallel.  The package
+names for PostgreSQL contain numbers indicating the major version.
+
+In PostgreSQL terms for versions up to 9.6 the major version consisted
+of the first two components of the three-component version number,
+i.e. 8.3, 8.4, 9.0, or 9.1. So, the packages for Postgresql 9.1 are
+named postgresql91, postgresql91-server, etc. Inside the packages the
+files were moved from their standard locations to a versioned location
+such as /usr/lib/postgresql83/bin or /usr/lib/postgresql91/bin to
+avoid file conflicts if packages are installed in parallel.
+
+Starting with version 10 the PostgreSQL project changed their
+versioning scheme from from three components to two, which means one
+component for the major version and one for the minor.  So, the
+sequence of major version across the versioning scheme change will be:
+9.4, 9.5, 9.6, 10, 11, 12. For versions that use the new versioning
+scheme SUSE only puts the single component major version into the
+package name, so the postgresql96 package (containg version 9.6
+according to the old versioning scheme) will be followed by
+postgresql10, then postgresql11, and so on.
+
+The update-alternatives mechanism creates and maintains symbolic links
+that cause one version (by default the highest installed version) to
+re-appear in the standard locations. By default, database data are
+stored under /var/lib/pgsql/data on SUSE Linux.
+
+The following preconditions have to be fulfilled before data migration
+can be started:
+
+ 1. If not already done, the packages of the old PostgreSQL version
+ must be upgraded to the new packaging scheme through a maintenance
+ update.
+
+ 2. The packages of the new PostgreSQL major version need to be
+ installed. As pg_upgrade is contained in postgresql91-contrib, that
+ one has to be installed as well, at least until the migration is
+ done.
+
+ 3. Unless pg_upgrade is used in link mode, the server must have
+ enough free disk space to temporarily hold a copy of the database
+ files. If the database instance was installed in the default
+ location, the needed space in megabytes can be determined by running
+ the follwing command as root: "du -hs /var/lib/pgsql/data". If space
+ is tight, it might help to run the "VACUUM FULL" SQL command on each
+ database in the instance to be migrated, but be aware that it might
+ take very long.
+
+The latest upstream documentation for pg_upgrade including step by
+step instructions for performing a database migration can be found
+online under https://www.postgresql.org/docs/current/pgupgrade.html ,
+or locally under
+file:///usr/share/doc/packages/postgresqlXX/html/pgupgrade.html , if
+the postgresqlXX-docs package is installed. XX is a place holder for
+the respective major version here.
+
+NOTE: The online documentation starts with explaining how you can
+install PostgreSQL from the upstream sources (which is not necessary
+when you install the SUSE RPMs) and also uses other directory names
+(/usr/local instead of the update-alternatives based path as described
+above).
+
+For background information about the inner workings of pg_upgrade and
+a performance comparison with the old dump and restore method, see
+http://momjian.us/main/writings/pgsql/pg_upgrade.pdf .
--- a/postgresql-conf.patch
+++ b/postgresql-conf.patch
@ -0,0 +1,29 @@
+Index: src/backend/utils/misc/postgresql.conf.sample
+===================================================================
+--- src/backend/utils/misc/postgresql.conf.sample.orig
+++ src/backend/utils/misc/postgresql.conf.sample
+@@ -442,14 +442,14 @@
+ 
+ # - Where to Log -
+ 
+-#log_destination = 'stderr'		# Valid values are combinations of
+log_destination = 'stderr'		# Valid values are combinations of
+ 					# stderr, csvlog, jsonlog, syslog, and
+ 					# eventlog, depending on platform.
+ 					# csvlog and jsonlog require
+ 					# logging_collector to be on.
+ 
+ # This is used when logging to stderr:
+-#logging_collector = off		# Enable capturing of stderr, jsonlog,
+logging_collector = on		# Enable capturing of stderr, jsonlog,
+ 					# and csvlog into log files. Required
+ 					# to be on for csvlogs and jsonlogs.
+ 					# (change requires restart)
+@@ -558,6 +558,7 @@
+ #log_error_verbosity = default		# terse, default, or verbose messages
+ #log_hostname = off
+ #log_line_prefix = '%m [%p] '		# special values:
+log_line_prefix = '%m %d %u [%p]'
+ 					#   %a = application name
+ 					#   %u = user name
+ 					#   %d = database name
--- a/postgresql-llvm-optional.patch
+++ b/postgresql-llvm-optional.patch
@ -0,0 +1,16 @@
+--- src/Makefile.global.in.orig
+++ src/Makefile.global.in
+@@ -192,7 +192,12 @@ with_krb_srvnam	= @with_krb_srvnam@
+ with_ldap	= @with_ldap@
+ with_libxml	= @with_libxml@
+ with_libxslt	= @with_libxslt@
+-with_llvm	= @with_llvm@
+# Only build for LLVM, if the core supports it and the llvm and clang packages are installed.
+ifeq (@with_llvm@ $(wildcard /usr/bin/clang /usr/bin/llvm-lto),yes /usr/bin/clang /usr/bin/llvm-lto)
+with_llvm	= yes
+else
+with_llvm	= no
+endif
+ with_system_tzdata = @with_system_tzdata@
+ with_uuid	= @with_uuid@
+ with_zlib	= @with_zlib@
--- a/postgresql-plperl-keep-rpath.patch
+++ b/postgresql-plperl-keep-rpath.patch
@ -0,0 +1,34 @@
+This patch keeps PosgreSQL's configure script from removing the rpath from
+Perl's linker options, because otherwise the PL/Perl module can't find
+libperl.so (bsc#578053).
+
+Index: config/perl.m4
+===================================================================
+--- config/perl.m4.orig
+++ config/perl.m4
+@@ -98,9 +98,7 @@ if test "$PORTNAME" = "win32" ; then
+ 		fi
+ 	fi
+ else
+-	pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
+-	pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
+-	perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e ["s/ -arch [-a-zA-Z0-9_]*//g"]`
+	perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
+ fi
+ AC_SUBST(perl_embed_ldflags)dnl
+ if test -z "$perl_embed_ldflags" ; then
+Index: configure
+===================================================================
+--- configure.orig
+++ configure
+@@ -10421,9 +10421,7 @@ if test "$PORTNAME" = "win32" ; then
+ 		fi
+ 	fi
+ else
+-	pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
+-	pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
+-	perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e "s/ -arch [-a-zA-Z0-9_]*//g"`
+	perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
+ fi
+ if test -z "$perl_embed_ldflags" ; then
+ 	{ $as_echo "$as_me:${as_lineno-$LINENO}: result: no" >&5
--- a/9
+++ b/9
@ -0,0 +1,9 @@
+addFilter("useless-explicit-provides")
+addFilter("unnecessary-buildrequires")
+addFilter("patch-not-applied")
+addFilter("non-standard-uid")
+addFilter("file-not-in-%lang")
+addFilter("no-dependency-on")
+addFilter("no-soname")
+addFilter("devel-file-in-non-devel-package")
+addFilter("shlib-policy-name-error")
--- a/postgresql-testsuite-keep-results-file.patch
+++ b/postgresql-testsuite-keep-results-file.patch
@ -0,0 +1,18 @@
+commit 463154c669010cffc0e96b683576f1e879b61d8b
+Author: yac <yac@blesmrt.net>
+Date:   Mon Mar 11 18:42:39 2013 +0100
+
+    don't unlink the result file
+
+Index: postgresql-15beta1/src/test/regress/pg_regress.c
+===================================================================
+--- postgresql-15beta1.orig/src/test/regress/pg_regress.c
+++ postgresql-15beta1/src/test/regress/pg_regress.c
+@@ -2574,7 +2574,6 @@ regression_main(int argc, char *argv[],
+ 	else
+ 	{
+ 		unlink(difffilename);
+-		unlink(logfilename);
+ 	}
+ 
+ 	if (fail_count != 0)
--- a/postgresql-var-run-socket.patch
+++ b/postgresql-var-run-socket.patch
@ -0,0 +1,54 @@
+Change the built-in default socket directory to be /var/run/postgresql.
+For backwards compatibility with (probably non-libpq-based) clients that
+might still expect to find the socket in /tmp, also create a socket in
+/tmp.  This is to resolve communication problems with clients operating
+under systemd's PrivateTmp environment, which won't be using the same
+global /tmp directory as the server; see bug #825448.
+
+Note that we apply the socket directory change at the level of the
+hard-wired defaults in the C code, not by just twiddling the setting in
+postgresql.conf.sample; this is so that the change will take effect on
+server package update, without requiring any existing postgresql.conf
+to be updated.  (Of course, a user who dislikes this behavior can still
+override it via postgresql.conf.)
+
+
+Index: src/backend/utils/misc/guc.c
+===================================================================
+--- src/backend/utils/misc/guc.c.orig
+++ src/backend/utils/misc/guc.c
+@@ -4451,7 +4451,7 @@ static struct config_string ConfigureNam
+ 		},
+ 		&Unix_socket_directories,
+ #ifdef HAVE_UNIX_SOCKETS
+-		DEFAULT_PGSOCKET_DIR,
+		DEFAULT_PGSOCKET_DIR ", /tmp",
+ #else
+ 		"",
+ #endif
+Index: src/bin/initdb/initdb.c
+===================================================================
+--- src/bin/initdb/initdb.c.orig
+++ src/bin/initdb/initdb.c
+@@ -1044,7 +1044,7 @@ setup_config(void)
+ 
+ #ifdef HAVE_UNIX_SOCKETS
+ 	snprintf(repltok, sizeof(repltok), "#unix_socket_directories = '%s'",
+-			 DEFAULT_PGSOCKET_DIR);
+			 DEFAULT_PGSOCKET_DIR ", /tmp");
+ #else
+ 	snprintf(repltok, sizeof(repltok), "#unix_socket_directories = ''");
+ #endif
+Index: src/include/pg_config_manual.h
+===================================================================
+--- src/include/pg_config_manual.h.orig
+++ src/include/pg_config_manual.h
+@@ -224,7 +224,7 @@
+  * support them yet.
+  */
+ #ifndef WIN32
+-#define DEFAULT_PGSOCKET_DIR  "/tmp"
+#define DEFAULT_PGSOCKET_DIR  "/var/run/postgresql"
+ #else
+ #define DEFAULT_PGSOCKET_DIR ""
+ #endif
--- a/postgresql15.changes
+++ b/postgresql15.changes
@ -0,0 +1,325 @@
+-------------------------------------------------------------------
+Wed Aug  9 09:14:59 UTC 2023 - Reinhard Max <max@suse.com>
+
+- Update to 15.4:
+  * 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.
+  * bsc#1214061, CVE-2023-39418: Fix MERGE to enforce row security
+    policies properly.
+  * https://www.postgresql.org/docs/15/release-15-4.html
+
+-------------------------------------------------------------------
+Tue May  9 11:07:48 UTC 2023 - Reinhard Max <max@suse.com>
+
+- Update to 15.3:
+  * 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/docs/15/release-15-3.html
+
+-------------------------------------------------------------------
+Tue Apr 18 09:05:09 UTC 2023 - Reinhard Max <max@suse.com>
+
+- 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 <fvogt@suse.com>
+
+- Include -mini in Name: to avoid conflicts in the source package
+  name and OBS internal dependency tracking.
+
+-------------------------------------------------------------------
+Thu Feb  9 11:38:35 UTC 2023 - Reinhard Max <max@suse.com>
+
+- Update to 15.2:
+  * CVE-2022-41862, bsc#1208102: memory leak in libpq
+  * https://www.postgresql.org/about/news/2592/
+  * https://www.postgresql.org/docs/15/release-15-2.html
+- Bump latest_supported_llvm_ver to 15.
+
+-------------------------------------------------------------------
+Thu Nov 10 14:35:02 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Update to 15.1:
+  * https://www.postgresql.org/about/news/2543/
+  * https://www.postgresql.org/docs/15/release-15-1.html
+
+-------------------------------------------------------------------
+Thu Oct 13 14:03:27 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Update to 15.0:
+  * https://www.postgresql.org/about/news/p-2526/ 
+  * https://www.postgresql.org/docs/15/release-15.html
+- Move pg_upgrade from *-contrib to *-server.
+- Drop support for the 9.x versioning scheme.
+
+-------------------------------------------------------------------
+Thu Oct  6 13:20:57 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Update to 15~rc2
+  * https://www.postgresql.org/about/news/p-2521/
+  * Reverting the "optimized order of GROUP BY keys" feature.
+
+-------------------------------------------------------------------
+Fri Sep 30 10:43:09 UTC 2022 - Fabian Vogt <fvogt@suse.com>
+
+- Fix source URLs
+
+-------------------------------------------------------------------
+Thu Sep 29 14:02:38 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Update to 15~rc1
+  https://www.postgresql.org/about/news/p-2516/
+
+-------------------------------------------------------------------
+Thu Sep 22 21:26:36 UTC 2022 - Aaron Puchert <aaronpuchert@alice-dsl.net>
+
+- Create mechanism to specify the latest supported LLVM version.
+  Automatically pin to that version if the distribution has a newer
+  unsupported default version.
+
+-------------------------------------------------------------------
+Mon Sep 12 09:25:30 UTC 2022 - Andreas Schwab <schwab@suse.de>
+
+- Disable LLVM JIT on riscv64
+
+-------------------------------------------------------------------
+Thu Sep  8 13:37:01 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Update to 15~beta4
+  https://www.postgresql.org/about/news/p-2507/
+
+-------------------------------------------------------------------
+Mon Sep  5 09:20:34 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Update to 15~beta3
+  https://www.postgresql.org/about/news/p-2496/
+
+-------------------------------------------------------------------
+Sat May 21 20:48:45 UTC 2022 - Marcus Rueckert <mrueckert@suse.de>
+
+- use %version requires for the contrib package for now as
+  15~beta1 is actually smaller than 15.
+
+-------------------------------------------------------------------
+Sat May 21 15:25:26 UTC 2022 - Marcus Rueckert <mrueckert@suse.de>
+
+- Add proper conditionals for lz4 and zstd
+
+-------------------------------------------------------------------
+Sat May 21 15:07:19 UTC 2022 - Marcus Rueckert <mrueckert@suse.de>
+
+- Upgrade to 15~beta1 
+  https://www.postgresql.org/about/news/postgresql-15-beta-1-released-2453/
+  https://www.postgresql.org/docs/15/release-15.html
+- Refreshed patches to apply cleanly again:
+  0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
+  postgresql-conf.patch
+  postgresql-llvm-optional.patch
+  postgresql-plperl-keep-rpath.patch
+  postgresql-testsuite-keep-results-file.patch
+  postgresql-var-run-socket.patch
+- Add buildrequires for lz4 and zstd support
+
+-------------------------------------------------------------------
+Sat May 21 14:39:42 UTC 2022 - Marcus Rueckert <mrueckert@suse.de>
+
+- fork package for postgresql 15
+
+-------------------------------------------------------------------
+Thu May 12 10:33:20 UTC 2022 - Reinhard Max <max@suse.com>
+
+- 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
+
+-------------------------------------------------------------------
+Wed Apr 13 12:17:48 UTC 2022 - Reinhard Max <max@suse.com>
+
+- bsc#1198166: Pin to llvm13 until the next patchlevel update.
+
+-------------------------------------------------------------------
+Tue Feb  8 14:01:56 UTC 2022 - Reinhard Max <max@suse.com>
+
+- 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 <ada.lovelace@gmx.de>
+
+- boo#1190740: Add constraints file with 12GB of memory for s390x
+  as a workaround
+
+-------------------------------------------------------------------
+Thu Nov 25 11:02:15 UTC 2021 - Reinhard Max <max@suse.com>
+
+- 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.
+
+-------------------------------------------------------------------
+Wed Nov 10 16:56:57 UTC 2021 - Reinhard Max <max@suse.com>
+
+- 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 <max@suse.com>
+
+- boo#1191782: Let rpmlint ignore shlib-policy-name-error.
+
+-------------------------------------------------------------------
+Tue Oct  5 11:34:50 UTC 2021 - Reinhard Max <max@suse.com>
+
+- Remove postgresql-testsuite-int8.sql.patch, because its purpose
+  is unclear. This affects only the test subpackage.
+
+-------------------------------------------------------------------
+Thu Sep 30 17:28:37 UTC 2021 - Marcus Rueckert <mrueckert@suse.de>
+
+- Upgrade to 14.0
+  https://www.postgresql.org/about/news/postgresql-14-released-2318/
+  https://www.postgresql.org/docs/14/release-14.html
+
+-------------------------------------------------------------------
+Mon Sep 27 14:04:01 UTC 2021 - Reinhard Max <max@suse.com>
+
+- Let genlists skip non-existing binaries to avoid lots of version
+  conditionals in the file lists.
+
+-------------------------------------------------------------------
+Sat Sep 25 00:34:52 UTC 2021 - Marcus Rueckert <mrueckert@suse.de>
+
+- Upgrade to 14~rc1
+  https://www.postgresql.org/about/news/postgresql-14-rc-1-released-2309/
+  https://www.postgresql.org/docs/14/release-14.html
+  https://wiki.postgresql.org/wiki/PostgreSQL_14_Open_Items
+
+-------------------------------------------------------------------
+Fri Jun 25 01:45:20 UTC 2021 - Marcus Rueckert <mrueckert@suse.de>
+
+- Upgrade to 14~beta2
+  https://www.postgresql.org/about/news/postgresql-14-beta-2-released-2249/
+  https://www.postgresql.org/docs/14/release-14.html
+  https://wiki.postgresql.org/wiki/PostgreSQL_14_Open_Items
+
+-------------------------------------------------------------------
+Fri May 21 22:48:32 UTC 2021 - Marcus Rueckert <mrueckert@suse.de>
+
+- Upgrade to 14~beta1
+  https://www.postgresql.org/about/news/postgresql-14-beta-1-released-2213/
+  https://www.postgresql.org/docs/14/release-14.html
+  https://wiki.postgresql.org/wiki/PostgreSQL_14_Open_Items
+- disable postgresql-testsuite-int8.sql.patch:
+  it seems it is not needed anymore, need to be double checked.
+
+-------------------------------------------------------------------
+Wed May 19 15:24:24 UTC 2021 - Reinhard Max <max@suse.com>
+
+- bsc#1185952: llvm12 breaks PostgreSQL 11 and 12 on s390x.
+  Use llvm11 as a workaround.
+
+-------------------------------------------------------------------
+Tue May 11 13:50:14 UTC 2021 - Reinhard Max <max@suse.com>
+
+- Upgrade to version 13.3:
+  * https://www.postgresql.org/docs/13/release-13-3.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).
+
+-------------------------------------------------------------------
+Mon Mar 15 19:29:39 UTC 2021 - Reinhard Max <max@suse.com>
+
+- Re-enable build of the llvmjit subpackage on SLE, but it will
+  only be delivered on PackageHub for now (boo#1183118).
+
+-------------------------------------------------------------------
+Tue Mar  9 13:52:19 UTC 2021 - Reinhard Max <max@suse.com>
+
+- Remove leftover PreReq on chkconfig, we stopped using it long
+  time ago.
+
+-------------------------------------------------------------------
+Fri Feb 19 15:30:08 UTC 2021 - Reinhard Max <max@suse.com>
+
+- boo#1179945: Disable icu for PostgreSQL 10 (and older) on TW.
+
+-------------------------------------------------------------------
+Wed Feb 10 13:16:32 UTC 2021 - Reinhard Max <max@suse.com>
+
+- Upgrade to version 13.2:
+  * https://www.postgresql.org/docs/13/release-13-2.html
+  * Updating stored views and reindexing might be needed after
+    applying this update.
+  * CVE-2021-3393, bsc#1182040: Fix information leakage in
+    constraint-violation error messages.
+  * CVE-2021-20229, bsc#1182039: Fix failure to check per-column
+    SELECT privileges in some join queries.
+  * Obsoletes postgresql-icu68.patch.
+
+-------------------------------------------------------------------
+Mon Dec 14 16:19:05 UTC 2020 - Callum Farmer <gmbr3@opensuse.org>
+
+- Add postgresql-icu68.patch: fix build with ICU 68
+
+-------------------------------------------------------------------
+Fri Nov 20 11:51:37 UTC 2020 - Reinhard Max <max@suse.com>
+
+- 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.
+
+-------------------------------------------------------------------
+Wed Nov 11 11:36:01 UTC 2020 - Reinhard Max <max@suse.com>
+
+- Upgrade to version 13.1:
+  * 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/13/release-13-1.html
+
+-------------------------------------------------------------------
+Tue Nov  3 13:54:38 UTC 2020 - Reinhard Max <max@suse.com>
+
+- Fix a DST problem in the test suite: postgresql-timetz.patch
+  https://postgr.es/m/16689-57701daa23b377bf@postgresql.org
+
+-------------------------------------------------------------------
+Fri Sep 25 06:57:55 UTC 2020 - Reinhard Max <max@suse.com>
+
+- Initial packaging of PostgreSQL 13:
+  * https://www.postgresql.org/about/news/2077/
+  * https://www.postgresql.org/docs/13/release-13.html
--- a/postgresql15.spec
+++ b/postgresql15.spec
@ -0,0 +1,971 @@
+#
+# spec file
+#
+# 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
+# upon. The license for this file, and modifications and additions to the
+# file, is the same license as for the pristine package itself (unless the
+# license for the pristine package is not an Open Source License, in which
+# case the license is the MIT License). An "Open Source License" is a
+# license that conforms to the Open Source Definition (Version 1.9)
+# published by the Open Source Initiative.
+
+# Please submit bugfixes or comments via https://bugs.opensuse.org/
+#
+
+
+%define pgversion 15.4
+%define pgmajor 15
+%define buildlibs 1
+%define tarversion %{pgversion}
+%define latest_supported_llvm_ver 15
+
+### CUT HERE ###
+%define pgname postgresql%pgmajor
+%define libpq libpq5
+%define libecpg libecpg6
+%define libpq_so libpq.so.5
+%define libecpg_so libecpg.so.6
+%define pgbasedir %_prefix/lib/%pgname
+%define pgtestdir %pgbasedir/test
+%define pgbindir %pgbasedir/bin
+%define pglibdir %pgbasedir/%_lib
+%define pgincludedir %_includedir/pgsql
+%define pgdatadir %_datadir/%pgname
+%define pgdocdir %_docdir/%pgname
+%define pgextensiondir %pgdatadir/extension
+%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")
+
+%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.
+# Use Python 3 for everything else.
+%if 0%{?is_opensuse} || 0%{?sle_version} >= 150000 || %pgmajor > 10
+%define python python3
+%else
+%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
+%else
+BuildRequires:  %{python}-devel
+BuildRequires:  docbook_4
+BuildRequires:  gettext-devel
+BuildRequires:  libuuid-devel
+BuildRequires:  ncurses-devel
+BuildRequires:  pam-devel
+BuildRequires:  readline-devel
+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
+BuildRequires:  %libecpg
+BuildRequires:  %libpq
+%endif
+
+%if 0%{?suse_version} >= 1500 && %pgmajor >= 11
+%ifarch riscv64
+%bcond_with     llvm
+%else
+%bcond_without  llvm
+%endif
+%else
+%bcond_with     llvm
+%endif
+%endif
+
+%ifnarch %arm
+%bcond_without  check
+%else
+%bcond_with     check
+%endif
+
+%if %pgmajor >= 11 || %mini
+%bcond_without server_devel
+%else
+%bcond_with server_devel
+%endif
+
+BuildRequires:  fdupes
+%if %{with icu}
+BuildRequires:  libicu-devel
+%endif
+%if %{with selinux}
+BuildRequires:  libselinux-devel
+%endif
+%if %{with llvm}
+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
+BuildRequires:  pkg-config
+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
+Summary:        Basic Clients and Utilities for PostgreSQL
+License:        PostgreSQL
+Group:          Productivity/Databases/Tools
+Version:        %pgversion
+Release:        0
+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)
+Patch4:         postgresql-plperl-keep-rpath.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
+Provides:       postgresql-implementation = %version-%release
+Requires:       %libpq >= %version
+Requires(post): 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
+
+%description
+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
+types and functions.
+
+This package contains the basic utility and client programs necessary
+to maintain and work with local or remote PostgreSQL databases as well
+as manual pages for the SQL commands that PostgreSQL supports. Full
+HTML documentation for PostgreSQL can be found in the postgresql-docs
+package.
+
+%package -n %libpq
+Summary:        Shared Libraries Required for PostgreSQL Clients
+Group:          Productivity/Databases/Clients
+Provides:       postgresql-libs:%_libdir/libpq.so.5
+Obsoletes:      postgresql-libs < %version
+# bug437293
+%if "%_lib" == "lib64"
+Conflicts:      %libpq-32bit < %version
+%endif
+%ifarch ia64
+Conflicts:      %libpq-x86 < %version
+%endif
+%ifarch ppc64
+Obsoletes:      postgresql-libs-64bit
+%endif
+
+%description -n %libpq
+
+PostgreSQL is an advanced object-relational database management system
+that supports an extended subset of the SQL standard, including
+transactions, foreign keys, subqueries, triggers, user-defined types
+and functions.
+
+This package provides the client library that most PostgreSQL client
+program or language bindings are using.
+
+%package -n %libecpg
+
+Summary:        Shared Libraries Required for PostgreSQL Clients
+Group:          Productivity/Databases/Clients
+Provides:       postgresql-libs:%_libdir/libecpg.so.6
+
+%description -n %libecpg
+PostgreSQL is an advanced object-relational database management system
+that supports an extended subset of the SQL standard, including
+transactions, foreign keys, subqueries, triggers, user-defined types
+and functions.
+
+This package provides the runtime library of the embedded SQL C
+preprocessor for PostgreSQL.
+
+%package -n %pgname-%devel
+Summary:        PostgreSQL client development header files and libraries
+Group:          Development/Libraries/C and C++
+Provides:       postgresql-devel = %version-%release
+Provides:       postgresql-devel-implementation = %version-%release
+%if %mini
+Requires:       this-is-only-for-build-envs
+Provides:       %libecpg = %version-%release
+Provides:       %libpq = %version-%release
+Provides:       %pgname-devel = %version-%release
+Conflicts:      %libecpg
+Conflicts:      %libpq
+Conflicts:      %pgname-devel
+%else
+Requires:       %libecpg >= %version
+Requires:       %libpq >= %version
+Requires:       postgresql-devel-noarch >= %pgmajor
+%endif
+# Installation of postgresql??-devel is exclusive
+Provides:       postgresql-devel-exclusive = %pgmajor
+Conflicts:      postgresql-devel-exclusive < %pgmajor
+
+%if %{with server_devel}
+%package server-devel
+Summary:        PostgreSQL server development header files and utilities
+Group:          Development/Libraries/C and C++
+%else
+Provides:       %pgname-server-devel = %version-%release
+%endif
+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:       %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
+Requires:       libxslt-devel
+Requires:       openssl-devel
+Requires:       pam-devel
+Requires:       readline-devel
+Requires:       zlib-devel
+Requires:       pkgconfig(krb5)
+%if %{with selinux}
+Requires:       libselinux-devel
+%endif
+%if %{with llvm}
+Recommends:     %pgname-llvmjit-devel = %version-%release
+%endif
+
+%if %{with server_devel}
+%description server-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
+types and functions.
+
+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%pgmajor-devel package.
+%endif
+
+%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
+types and functions.
+
+This package contains the header files and libraries needed to compile
+C applications which will directly interact with a PostgreSQL database
+management server and the ECPG Embedded C Postgres preprocessor. You
+need to install this package if you want to develop applications in C
+which will interact with a PostgreSQL server.
+
+For building PostgreSQL server extensions, see the
+postgresql%pgmajor-server-devel package.
+
+%package server
+Summary:        The Programs Needed to Create and Run a PostgreSQL Server
+Group:          Productivity/Databases/Servers
+PreReq:         postgresql = %version
+Requires:       glibc-locale
+Requires:       timezone
+%if %{with llvm}
+Recommends:     %{name}-llvmjit
+%endif
+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(post): postgresql-noarch >= %pgmajor
+Requires(postun):postgresql-noarch >= %pgmajor
+
+%description server
+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 includes the programs needed to create and run a
+PostgreSQL server, which will in turn allow you to create and maintain
+PostgreSQL databases.
+
+%package llvmjit
+Summary:        Just-in-time compilation support for PostgreSQL
+Group:          Productivity/Databases/Servers
+Provides:       postgresql-llvmjit-implementation = %version-%release
+Requires:       %pgname-server = %version-%release
+Requires:       postgresql-llvmjit-noarch >= %pgmajor
+
+%description llvmjit
+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 contains support for just-in-time compiling parts of
+PostgreSQL queries. Using LLVM it compiles e.g. expressions and tuple
+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
+Provides:       postgresql-test-implementation = %version-%release
+Requires:       %pgname-server = %version
+Requires:       postgresql-test-noarch >= %pgmajor
+
+%description test
+This package contains the sources and pre-built binaries of various
+tests for the PostgreSQL database management system, including
+regression tests and benchmarks.
+
+%package docs
+Summary:        HTML Documentation for PostgreSQL
+Group:          Productivity/Databases/Tools
+Provides:       postgresql-docs-implementation = %version-%release
+Requires:       postgresql-docs-noarch >= %pgmajor
+BuildArch:      noarch
+
+%description docs
+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
+types and functions.
+
+This package contains the HTML documentation for PostgreSQL. The start
+page is: file:///usr/share/doc/packages/%pgname/html/index.html .
+Manual pages for the PostgreSQL SQL statements can be found in the
+postgresql package.
+
+%package contrib
+Summary:        Contributed Extensions and Additions to PostgreSQL
+Group:          Productivity/Databases/Tools
+Provides:       postgresql-contrib-implementation = %version-%release
+Requires:       postgresql-contrib-noarch >= %pgmajor
+Requires(post): %pgname >= %{version}
+Requires:       %pgname >= %{version}
+PreReq:         %pgname-server = %version-%release
+
+%description contrib
+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
+types and functions.
+
+The postgresql-contrib package includes extensions and additions that
+are distributed along with the PostgreSQL sources, but are not (yet)
+officially part of the PostgreSQL core.
+
+Documentation for the modules contained in this package can be found in
+/usr/share/doc/packages/postgresql/contrib.
+
+%package plperl
+Summary:        The PL/Tcl, PL/Perl, and  PL/Python procedural languages for PostgreSQL
+Group:          Productivity/Databases/Servers
+Provides:       postgresql-plperl-implementation = %version-%release
+Requires:       %pgname-server = %version-%release
+Requires:       perl = %perl_version
+Requires:       postgresql-plperl-noarch >= %pgmajor
+
+%description plperl
+This package contains the the PL/Tcl, PL/Perl, and PL/Python procedural
+languages for the back-end.  With these modules one can use Perl,
+Python, and Tcl to write stored procedures, functions and triggers.
+
+PostgreSQL also offers the builtin procedural language PL/SQL.
+
+%package plpython
+Summary:        The PL/Python Procedural Languages for PostgreSQL
+Group:          Productivity/Databases/Servers
+Provides:       postgresql-plpython-implementation = %version-%release
+Requires:       %pgname-server = %version-%release
+Requires:       %python
+Requires:       postgresql-plpython-noarch >= %pgmajor
+
+%description plpython
+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
+types and functions.
+
+This package contains the PL/Python procedural language for PostgreSQL.
+With this module one can use Python to write stored procedures,
+functions, and triggers.
+
+PostgreSQL also offers the built-in procedural language PL/SQL which is
+included in the postgresql-server package.
+
+%package pltcl
+Summary:        PL/Tcl Procedural Language for PostgreSQL
+Group:          Productivity/Databases/Tools
+Provides:       postgresql-pltcl-implementation = %version-%release
+Requires:       %pgname-server = %version
+Requires:       postgresql-pltcl-noarch >= %pgmajor
+Requires:       tcl
+
+%description pltcl
+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
+types and functions.
+
+This package contains the PL/Tcl procedural language for PostgreSQL.
+With thie module one can use Tcl to write stored procedures, functions,
+and triggers.
+
+PostgreSQL also offers the built-in procedural language PL/SQL which is
+included in the postgresql-server package.
+
+%prep
+%setup -q -n postgresql-%tarversion
+# Keep the timestamp of configure, because patching it would otherwise
+# confuse PostgreSQL's build system
+touch -r configure tmp
+%patch1
+%patch4
+%patch8 -p1
+%patch9
+%if %{with llvm}
+%patch10
+%patch11
+%endif
+touch -r tmp configure
+rm tmp
+find src/test/ -name '*.orig' -delete
+find -name .gitignore -delete
+
+%build
+%global _lto_cflags %{_lto_cflags} -ffat-lto-objects
+export PYTHON=%python
+%ifarch %arm
+export USE_ARMV8_CRC32C=0
+%endif
+PACKAGE_TARNAME=%pgname %configure \
+        --bindir=%pgbindir \
+        --libdir=%pglibdir \
+        --includedir=%pgincludedir \
+        --datadir=%pgdatadir \
+        --docdir=%pgdocdir \
+        --mandir=%pgmandir \
+        --disable-rpath \
+        --enable-nls \
+        --enable-thread-safety \
+        --enable-integer-datetimes \
+%if !%mini
+        --with-python \
+        --with-perl \
+        --with-tcl \
+        --with-tclconfig=%_libdir \
+        --with-pam \
+        --with-uuid=e2fs \
+        --with-libxml \
+        --with-libxslt \
+%if %{with liblz4}
+        --with-lz4 \
+%endif
+%if %{with libzstd}
+        --with-zstd \
+%endif
+        --with-systemd \
+%if %{with selinux}
+        --with-selinux \
+%endif
+%if %{with icu}
+        --with-icu \
+%endif
+%if %{with llvm}
+	--with-llvm \
+%endif
+%else
+        --without-readline \
+%endif
+        --with-openssl \
+        --with-ldap \
+        --with-gssapi \
+        --with-krb5 \
+        --with-system-tzdata=/usr/share/zoneinfo
+%if %mini
+make -C src/interfaces %{?_smp_mflags} PACKAGE_TARNAME=%pgname
+%else
+make %{?_smp_mflags} PACKAGE_TARNAME=%pgname
+
+%if %{with check}
+
+%check
+#
+# Run the regression tests.
+#
+make check || {
+  for f in src/test/regress/log/* {,src/test/regress/}regression.diffs; do
+    if test -f $f; then
+	cat $f
+    fi
+  done
+  exit 1
+}
+%endif
+%endif
+
+%install
+VLANG=%pgmajor
+%if %mini
+make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname -C src/include install
+make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname -C src/interfaces install
+rm -rf %buildroot%pgincludedir/server
+%else
+make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname install install-docs
+%if 0
+mv %buildroot%pgincludedir/{server,..}
+make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname -C src/interfaces uninstall
+rm -rf %buildroot%pgincludedir/*
+mv %buildroot%pgincludedir{/../server,}
+%endif
+
+# {{{ the test package
+mkdir -p %buildroot%pgtestdir/regress
+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
+	test -d $i && cp -r $i %buildroot%pgtestdir/regress/
+done
+install -m 0644 src/test/regress/*_schedule %buildroot%pgtestdir/regress
+# }}}
+%endif
+
+# The client libraries go to libdir
+mkdir -p %buildroot/%_libdir
+ls %buildroot%pglibdir/lib* |
+   grep -v walreceiver |
+   xargs mv -t %buildroot/%_libdir
+mv %buildroot%pglibdir/pkgconfig %buildroot%_libdir
+find %buildroot%_libdir/pkgconfig -type f -exec sed -i 's, -L%pglibdir,,' '{}' +
+
+# Don't ship static libraries,
+# libpgport.a and libpgcommon.a are needed, though.
+rm -f $(ls %buildroot/%_libdir/*.a %buildroot%pglibdir/*.a | grep -F -v -e libpgport.a -e libpgcommon.a)
+
+%if !%mini
+#
+# Install and collect the contrib stuff
+#
+touch flag; sleep 1 # otherwise we have installed files that are not newer than flag
+make DESTDIR=%buildroot -C contrib install
+find %buildroot -type f -cnewer flag -printf "/%%P\n" |
+     grep -v -e %_docdir -e %pgbindir -e %pgincludedir -e %pglibdir/bitcode \
+     > contrib.files
+rm flag
+install -d -m 750 %buildroot/var/lib/pgsql
+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
+done
+%endif
+
+mkdir -p %buildroot{%_bindir,%_mandir/man1}
+mkdir -p %buildroot/etc/alternatives
+genlists ()
+{
+    # usage: genlists packagename basenames
+    PKG=$1
+    shift
+    for f in $@
+    do
+        BIN=%_bindir/$f
+        ALTBIN=/etc/alternatives/$f
+        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
+
+        echo "$PGBIN" >> $PKG.files
+        echo "$BIN" >> $PKG.files
+        echo "%ghost $ALTBIN" >> $PKG.files
+        test -e %buildroot$MAN &&
+            echo "%doc $MAN" >> $PKG.files
+        %find_lang $f-$VLANG $PKG.files ||:
+    done
+}
+%if !%mini
+genlists main \
+	createdb \
+	clusterdb \
+	createuser \
+	dropdb \
+	dropuser \
+	pg_dump \
+	pg_dumpall \
+	pg_restore \
+	pg_rewind \
+	psql \
+	vacuumdb \
+	reindexdb \
+	pg_basebackup \
+	pg_isready \
+	pg_recvlogical \
+	createlang \
+	droplang \
+	pg_receivexlog \
+	pg_receivewal \
+	pg_verify_checksums \
+	pg_checksums \
+	pg_verifybackup
+
+%find_lang plpgsql-$VLANG main.files
+%find_lang pgscripts-$VLANG main.files
+
+genlists server \
+	initdb \
+	pg_ctl \
+	pg_controldata \
+	pg_resetwal \
+	pg_waldump \
+	pg_resetxlog \
+%if %pgmajor >= 15
+	pg_upgrade \
+%endif
+	postgres \
+	postmaster
+
+genlists contrib \
+	pg_xlogdump \
+	oid2name \
+	pg_archivecleanup \
+	pg_amcheck \
+	pg_standby \
+	pg_test_fsync \
+%if %pgmajor < 15
+	pg_upgrade \
+%endif
+        pgbench \
+	vacuumlo \
+	pg_test_timing
+for pl in plperl plpython pltcl; do
+    %find_lang $pl-$VLANG $pl.lang
+done
+ln -s /etc/alternatives/postgresql %buildroot/usr/lib/postgresql
+touch %buildroot/etc/alternatives/postgresql
+
+# Remove mostly unneeded buildtime requirements for server extensions
+sed -i '/^LIBS = /s/= .*/=/' %buildroot/%pglibdir/pgxs/src/Makefile.global
+%endif
+
+# Make sure we can also link agaist newer versions
+pushd %buildroot%_libdir
+for f in *.so; do
+    ln -sf $f.? $f
+done
+%if 0
+for long in *.so.*.*; do
+    short=${long%%.*}
+    so=${short%%.*}
+    ln -sf $long $short
+    ln -sf $short $so
+done
+%endif
+popd
+
+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
+
+%if !%mini
+%find_lang pg_config-$VLANG server-devel.files
+ln -s %pgbindir/pg_config %buildroot%_bindir/pg_config
+%endif
+
+%if %{without server_devel}
+cat server-devel.files >> devel.files
+%endif
+
+# Build up the file lists for the libpq and libecpg packages
+cat > libpq.files <<EOF
+%defattr(-,root,root)
+%dir %pgdatadir
+%pgdatadir/pg_service.conf.sample
+EOF
+find %buildroot -name 'libpq*.so.*' -printf '/%%P\n' >> libpq.files
+%find_lang libpq5-$VLANG libpq.files
+
+cat > libecpg.files <<EOF
+%defattr(-,root,root)
+EOF
+find %buildroot \( -name 'libecpg*.so.*' -o -name 'libpgtypes.so.*' \) -printf '/%%P\n' >> libecpg.files
+%find_lang ecpglib6-$VLANG libecpg.files
+
+%if !%buildlibs
+# Delete the contents of the library packages, if we don't want to build them
+awk -v P=%buildroot '/^(%lang|[^%])/{print P $NF}' libpq.files libecpg.files | xargs rm
+%endif
+
+%fdupes %buildroot
+
+%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
+%if %{with server_devel}
+%postun server-devel
+%endif
+/usr/share/postgresql/install-alternatives %pgmajor
+
+%if !%mini
+
+%postun
+/usr/share/postgresql/install-alternatives %pgmajor
+
+%post
+/usr/share/postgresql/install-alternatives %pgmajor
+
+%post server
+/usr/share/postgresql/install-alternatives %pgmajor
+
+%preun server
+# Stop only when we are uninstalling the currently running version
+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
+      %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
+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
+      %service_del_postun postgresql.service
+  fi
+fi
+
+%post contrib
+/usr/share/postgresql/install-alternatives %pgmajor
+
+%postun contrib
+/usr/share/postgresql/install-alternatives %pgmajor
+
+%if %buildlibs
+%post -n %libpq -p /sbin/ldconfig
+
+%postun -n %libpq -p /sbin/ldconfig
+
+%post -n %libecpg -p /sbin/ldconfig
+
+%postun -n %libecpg -p /sbin/ldconfig
+%endif
+
+%files -f main.files
+%defattr(-,root,root)
+%dir %pgbindir
+%doc %pgmandir/man7/*
+%docdir %pgdocdir
+%dir %pgdocdir
+%pgdocdir/[[:upper:]]*
+%dir %pglibdir
+/usr/lib/postgresql
+%ghost /etc/alternatives/postgresql
+
+%files test
+%defattr(-,root,root,-)
+%pgtestdir
+
+%files docs
+%defattr(-,root,root)
+%doc %pgmandir/man3/*
+%docdir %pgdocdir
+%dir %pgdocdir
+%pgdocdir/html
+
+%files contrib -f contrib.files
+%defattr(-,root,root)
+%docdir %pgdocdir
+%dir %pgdocdir
+%pgdocdir/extension
+%dir %pgdatadir
+%dir %pgcontribdir
+
+%files server -f server.files
+%defattr(-,root,root)
+%dir %pgbasedir
+%dir %pgextensiondir
+%dir %pglibdir
+%pglibdir/pgoutput.so
+%pglibdir/plpgsql.so
+%pglibdir/dict_snowball.so
+%pgdatadir/tsearch_data
+%exclude %pgdatadir/tsearch_data/*.rules
+%dir %pgdatadir
+%pgdatadir/timezone*
+%pgdatadir/*.*
+%if %buildlibs
+%exclude %pgdatadir/pg_service.conf.sample
+%endif
+%pglibdir/*_and_*.so
+%pglibdir/euc2004_sjis2004.so
+%pglibdir/libpqwalreceiver.so
+%pgextensiondir/plpgsql*
+%attr(750,postgres,postgres) %dir /var/lib/pgsql
+
+%if %{with llvm}
+%dir %pglibdir/bitcode
+
+%files llvmjit
+%defattr(-,root,root)
+%pglibdir/llvm*
+%pglibdir/bitcode/*
+%endif
+
+%files llvmjit-devel
+%defattr(-,root,root)
+%doc README
+
+%files pltcl -f pltcl.lang
+%defattr(-,root,root)
+%pgextensiondir/pltcl*
+%pglibdir/pltcl.so
+
+%files plperl -f plperl.lang
+%defattr(-,root,root)
+%pgextensiondir/plperl*
+%pglibdir/plperl.so
+
+%files plpython -f plpython.lang
+%defattr(-,root,root)
+%pgextensiondir/plpython*
+%pglibdir/plpython*.so
+
+%endif
+
+%if %buildlibs && !%mini
+%files -n %libpq -f libpq.files
+
+%files -n %libecpg -f libecpg.files
+%endif
+
+%if %buildlibs && %mini
+%files -n %pgname-%devel -f devel.files -f libpq.files -f libecpg.files
+%defattr(-,root,root)
+%else
+
+%files -n %pgname-%devel -f devel.files
+%defattr(-,root,root)
+%endif
+
+%dir %pgbasedir
+%dir %pgbindir
+%ghost %_bindir/ecpg
+%_libdir/pkgconfig/*
+%_libdir/lib*.so
+%pgbindir/ecpg
+%pgincludedir
+%if %{with server_devel}
+%exclude %pgincludedir/server
+%endif
+%doc %pgmandir/man1/ecpg.1*
+
+%if !%mini
+%if %{with server_devel}
+%files server-devel -f server-devel.files
+%endif
+%defattr(-,root,root)
+%ghost %_bindir/pg_config
+%pgbindir/pg_config
+%pgincludedir/server
+%pglibdir/pgxs
+%_libdir/lib*.a
+%doc %pgmandir/man1/pg_config.1*
+%endif
+
+%changelog
				`@ -0,0 +1 @@`
				`baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9 postgresql-15.4.tar.bz2`