OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/postgresql13?expand=0&rev=91

2024-09-26 14:38:02 +00:00 · 2024-09-26 14:38:02 +00:00 · b88c2d48dd
commit b88c2d48dd
16 changed files with 1651 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/.gitignore
+++ b/.gitignore
@ -0,0 +1 @@
+.osc
--- a/0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
+++ b/0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
@ -0,0 +1,94 @@
+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(-)
+
+--- src/backend/jit/llvm/llvmjit.c.orig
+++ src/backend/jit/llvm/llvmjit.c
+@@ -736,6 +736,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
+@@ -744,6 +773,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;
+@@ -775,10 +805,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,
+@@ -792,8 +829,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/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-13.15.tar.bz2
+++ b/postgresql-13.15.tar.bz2
@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:42edd415446d33b8c242be76d1ad057531b2264b2e86939339b7075c6e4ec925
+size 21597871
--- a/postgresql-13.15.tar.bz2.sha256
+++ b/postgresql-13.15.tar.bz2.sha256
@ -0,0 +1 @@
+42edd415446d33b8c242be76d1ad057531b2264b2e86939339b7075c6e4ec925  postgresql-13.15.tar.bz2
--- a/postgresql-13.16.tar.bz2
+++ b/postgresql-13.16.tar.bz2
@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:c9cbbb6129f02328204828066bb3785c00a85c8ca8fd329c2a8a53c1f5cd8865
+size 21639411
--- a/postgresql-13.16.tar.bz2.sha256
+++ b/postgresql-13.16.tar.bz2.sha256
@ -0,0 +1 @@
+c9cbbb6129f02328204828066bb3785c00a85c8ca8fd329c2a8a53c1f5cd8865  postgresql-13.16.tar.bz2
--- a/postgresql-conf.patch
+++ b/postgresql-conf.patch
@ -0,0 +1,28 @@
+Index: src/backend/utils/misc/postgresql.conf.sample
+===================================================================
+--- src/backend/utils/misc/postgresql.conf.sample.orig
+++ src/backend/utils/misc/postgresql.conf.sample
+@@ -416,13 +416,13 @@
+ 
+ # - Where to Log -
+ 
+-#log_destination = 'stderr'		# Valid values are combinations of
+log_destination = 'stderr'		# Valid values are combinations of
+ 					# stderr, csvlog, syslog, and eventlog,
+ 					# depending on platform.  csvlog
+ 					# requires logging_collector to be on.
+ 
+ # This is used when logging to stderr:
+-#logging_collector = off		# Enable capturing of stderr and csvlog
+logging_collector = on			# Enable capturing of stderr and csvlog
+ 					# into log files. Required to be on for
+ 					# csvlogs.
+ 					# (change requires restart)
+@@ -514,6 +514,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
+@@ -9696,9 +9696,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/8
+++ b/8
@ -0,0 +1,8 @@
+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")
--- a/postgresql-testsuite-keep-results-file.patch
+++ b/postgresql-testsuite-keep-results-file.patch
@ -0,0 +1,16 @@
+commit 463154c669010cffc0e96b683576f1e879b61d8b
+Author: yac <yac@blesmrt.net>
+Date:   Mon Mar 11 18:42:39 2013 +0100
+
+    don't unlink the result file
+
+--- src/test/regress/pg_regress.c.orig
+++ src/test/regress/pg_regress.c
+@@ -2668,7 +2668,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,48 @@
+Change the built-in default socket directory to be /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.)
+
+
+--- src/backend/utils/misc/guc.c.orig
+++ src/backend/utils/misc/guc.c
+@@ -4159,7 +4159,7 @@ static struct config_string ConfigureNam
+ 		},
+ 		&Unix_socket_directories,
+ #ifdef HAVE_UNIX_SOCKETS
+-		DEFAULT_PGSOCKET_DIR,
+		DEFAULT_PGSOCKET_DIR ", /tmp",
+ #else
+ 		"",
+ #endif
+--- src/bin/initdb/initdb.c.orig
+++ src/bin/initdb/initdb.c
+@@ -1091,7 +1091,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
+--- src/include/pg_config_manual.h.orig
+++ src/include/pg_config_manual.h
+@@ -201,7 +201,7 @@
+  * support them yet.
+  */
+ #ifndef WIN32
+-#define DEFAULT_PGSOCKET_DIR  "/tmp"
+#define DEFAULT_PGSOCKET_DIR  "/run/postgresql"
+ #else
+ #define DEFAULT_PGSOCKET_DIR ""
+ #endif
--- a/postgresql13.changes
+++ b/postgresql13.changes
@ -0,0 +1,373 @@
+-------------------------------------------------------------------
+Thu Sep 26 11:05:46 UTC 2024 - Reinhard Max <max@suse.com>
+
+- Sync spec file from postgresql17.
+
+-------------------------------------------------------------------
+Sat Aug 10 14:13:54 UTC 2024 - Marcus Rueckert <mrueckert@suse.de>
+
+- Upgrade to 13.16 (bsc#1229013):
+  * bsc#1229013, CVE-2024-7348 PostgreSQL relation replacement
+    during pg_dump executes arbitrary SQL
+  * https://www.postgresql.org/about/news/postgresql-164-158-1413-1316-1220-and-17-beta-3-released-2910/
+  * https://www.postgresql.org/docs/release/13.16/
+
+-------------------------------------------------------------------
+Wed May  8 14:10:27 UTC 2024 - Reinhard Max <max@suse.com>
+
+- Upgrade to 13.15 (bsc#1224051):
+  * Fix incompatibility with LLVM 18.
+  * https://www.postgresql.org/docs/release/13.15/
+- Prepare for PostgreSQL 17.
+- Make sure all compilation and doc generation happens in %build.
+
+-------------------------------------------------------------------
+Wed May  1 15:24:39 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:37:18 UTC 2024 - Dominique Leuenberger <dimstar@opensuse.org>
+
+- Use %patch -P N instead of deprecated %patchN.
+
+-------------------------------------------------------------------
+Thu Feb  8 14:10:04 UTC 2024 - Reinhard Max <max@suse.com>
+
+- Upgrade to 13.14:
+  * 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/13.14/
+
+-------------------------------------------------------------------
+Wed Nov  8 14:35:06 UTC 2023 - Reinhard Max <max@suse.com>
+
+- Update to 13.13:
+  * 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/docs/13/release-13-13.html
+
+-------------------------------------------------------------------
+Tue Oct 31 10:57:13 UTC 2023 - Reinhard Max <max@suse.com>
+
+- boo#1216734: Revert the last change and make the devel package
+  independend of all other subpackages except for the libs.
+
+-------------------------------------------------------------------
+Tue Oct 10 12:49:02 UTC 2023 - Reinhard Max <max@suse.com>
+
+- 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 <dimstar@opensuse.org>
+
+- 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:55:59 UTC 2023 - Reinhard Max <max@suse.com>
+
+- Update to 13.12:
+  * 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/13/release-13-12.html
+
+-------------------------------------------------------------------
+Fri May 26 11:48:38 UTC 2023 - Reinhard Max <max@suse.com>
+
+- 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:22:10 UTC 2023 - Reinhard Max <max@suse.com>
+
+- 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.
+
+-------------------------------------------------------------------
+Wed May 10 13:02:46 UTC 2023 - Reinhard Max <max@suse.com>
+
+- Update to 13.11:
+  * 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/13/release-13-11.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 12:01:58 UTC 2023 - Reinhard Max <max@suse.com>
+
+- Update to 13.10:
+  * CVE-2022-41862, bsc#1208102: memory leak in libpq
+  * https://www.postgresql.org/about/news/2592/
+  * https://www.postgresql.org/docs/13/release-13-10.html
+- Bump latest_supported_llvm_ver to 15.
+
+-------------------------------------------------------------------
+Thu Nov 10 16:28:29 UTC 2022 - Reinhard Max <max@suse.com>
+
+- bsc#1205300: Update to 13.9:
+  * https://www.postgresql.org/about/news/2543/
+  * https://www.postgresql.org/docs/13/release-13-9.html
+- Sync spec file with postgresql15.
+
+-------------------------------------------------------------------
+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.
+
+-------------------------------------------------------------------
+Tue Sep 13 12:38:38 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Sync spec file with postgresql15.
+
+-------------------------------------------------------------------
+Mon Sep 12 07:52:42 UTC 2022 - Andreas Schwab <schwab@suse.de>
+
+- Disable LLVM JIT on riscv64
+
+-------------------------------------------------------------------
+Fri Aug 12 11:16:34 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Update to 13.8:
+  * bsc#1202368, CVE-2022-2625: Extension scripts replace objects
+    not belonging to the extension.
+  * https://www.postgresql.org/docs/release/13.8/
+
+-------------------------------------------------------------------
+Thu May 12 10:45:07 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Upgrade to 13.7:
+  * bsc#1199475, CVE-2022-1552: Confine additional operations
+    within "security restricted operation" sandboxes.
+  * https://www.postgresql.org/docs/13/release-13-7.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:23:38 UTC 2022 - Reinhard Max <max@suse.com>
+
+- bsc#1195680: Upgrade to 13.6:
+  * https://www.postgresql.org/docs/13/release-13-6.html
+  * Reindexing might be needed after applying this upgrade, so
+    please read the release notes carefully.
+- boo#1190740: Add constraints file with 12GB of memory for s390x
+  as a workaround
+
+-------------------------------------------------------------------
+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 18:04:28 UTC 2021 - Reinhard Max <max@suse.com>
+
+- bsc#1192516: Upgrade to 13.5:
+  * 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/13/release-13-5.html
+
+-------------------------------------------------------------------
+Mon Sep 27 13:58:17 UTC 2021 - Reinhard Max <max@suse.com>
+
+- Stop building the mini and lib packages as they are now coming
+  from postgresql14.
+- Let genlists skip non-existing binaries to avoid lots of version
+  conditionals in the file lists.
+- Remove postgresql-testsuite-int8.sql.patch, because its purpose
+  is unclear. This affects only the test subpackage.
+
+-------------------------------------------------------------------
+Tue Aug 31 11:14:53 UTC 2021 - Reinhard Max <max@suse.com>
+
+- bsc#1185952: fix build with llvm12 on s390x.
+  0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch 
+- bsc#1179945: Re-enable icu for PostgreSQL 10.
+
+-------------------------------------------------------------------
+Tue Aug 24 12:45:53 UTC 2021 - Marcus Rueckert <mrueckert@suse.de>
+
+- Upgrade to version 13.4:
+  https://www.postgresql.org/docs/13/release-13-4.html
+  * CVE-2021-3677 (boo#1189748)
+    The planner could create an incorrect plan in cases where two
+    ProjectionPaths were stacked on top of each other. The only
+    known way to trigger that situation involves parallel sort
+    operations, but there may be other instances. The result would
+    be crashes or incorrect query results. Disclosure of server
+    memory contents is also possible.
+
+-------------------------------------------------------------------
+Mon Jun 28 10:00:46 UTC 2021 - Reinhard Max <max@suse.com>
+
+- bsc#1187751: Make the dependency of postgresqlXX-server-devel on
+  llvm and clang optional (postgresql-llvm-optional.patch).
+
+-------------------------------------------------------------------
+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/postgresql13.spec
+++ b/postgresql13.spec
@ -0,0 +1,997 @@
+#
+# spec file for package postgresql13
+#
+# 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
+# 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 13.16
+%define pgmajor 13
+%define buildlibs 0
+%define tarversion %{pgversion}
+%define oldest_supported_llvm_ver 7
+%define latest_supported_llvm_ver 18
+
+### 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 %pgmajor >= 17
+%bcond_with derived
+%else
+%bcond_without derived
+%endif
+
+%if 0%{?suse_version} >= 1500
+%bcond_without liblz4
+%endif
+
+%if 0%{?sle_version} >= 150100 || 0%{?suse_version} >= 1550
+%bcond_without libzstd
+%endif
+
+%if %{without derived}
+BuildRequires:  bison
+BuildRequires:  docbook-xsl-stylesheets
+BuildRequires:  flex
+BuildRequires:  perl
+%endif
+%if %mini
+%bcond_with  selinux
+%if %pgmajor >= 16
+%bcond_without icu
+%else
+%bcond_with  icu
+%endif
+%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++
+BuildRequires:  (cmake(Clang) >= %{oldest_supported_llvm_ver} with cmake(Clang) <= %{latest_supported_llvm_ver})
+BuildRequires:  (cmake(LLVM)  >= %{oldest_supported_llvm_ver} with cmake(LLVM)  <= %{latest_supported_llvm_ver})
+%endif
+BuildRequires:  libxslt-devel
+BuildRequires:  openldap2-devel
+BuildRequires:  openssl-devel
+BuildRequires:  pkg-config
+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-server-devel-implementation
+#!BuildIgnore:  postgresql-llvmjit-devel-implementation
+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
+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
+%patch -P 1
+%patch -P 4
+%patch -P 8
+%patch -P 9
+%if %{with llvm}
+%patch -P 10
+%patch -P 11
+%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 world
+
+%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
+rm -rf %buildroot%pgdatadir
+%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 -m 755 %buildroot%pgdocdir
+cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \
+   README* HISTORY  %buildroot%pgdocdir
+# 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_combinebackup \
+	pg_verifybackup
+
+%find_lang plpgsql-$VLANG main.files
+%find_lang pgscripts-$VLANG main.files
+
+genlists server \
+	initdb \
+	pg_ctl \
+	pg_controldata \
+	pg_resetwal \
+	pg_createsubscriber \
+	pg_walsummary \
+	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
+
+%find_lang ecpg-$VLANG devel.files
+# 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
+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)
+%if !%mini
+%dir %pgdatadir
+%pgdatadir/pg_service.conf.sample
+%endif
+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
+
+%postun -n %pgname-%devel
+/sbin/ldconfig
+
+%if %{with server_devel}
+%post server-devel
+/usr/share/postgresql/install-alternatives %pgmajor
+
+%postun server-devel
+/usr/share/postgresql/install-alternatives %pgmajor
+%endif
+
+%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)
+
+%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
+%_bindir/ecpg
+%_libdir/pkgconfig/*
+%_libdir/lib*.so
+%pgincludedir
+
+%if %{with server_devel}
+%exclude %pgincludedir/server
+%endif
+
+%if !%mini
+%doc %pgmandir/man1/ecpg.1*
+%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 @@`
				`42edd415446d33b8c242be76d1ad057531b2264b2e86939339b7075c6e4ec925 postgresql-13.15.tar.bz2`
				`@ -0,0 +1 @@`
				`c9cbbb6129f02328204828066bb3785c00a85c8ca8fd329c2a8a53c1f5cd8865 postgresql-13.16.tar.bz2`