commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package postgresql14 for openSUSE:Factory checked in at 2026-03-02 18:46:42 Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old) and /work/SRC/openSUSE:Factory/.postgresql14.new.29461 (New) Package is "postgresql14" Mon Mar 2 18:46:42 2026 rev:31 rq:1335836 version:14.22 Changes: --- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes 2026-02-12 19:38:03.174205617 +0100 +++ /work/SRC/openSUSE:Factory/.postgresql14.new.29461/postgresql14.changes 2026-03-02 18:46:47.304530014 +0100 @@ -1,0 +2,11 @@ +Tue Feb 24 12:21:09 UTC 2026 - Reinhard Max + +- bsc#1258754: Update to 14.22 to fix two regressions in 14.21: + * https://www.postgresql.org/docs/release/14.22/ + * The substring() function raises an error "invalid byte sequence +for encoding" on non-ASCII text values if the source of +that value is a database column. + * A standby may halt and return an error "could not access status +of transaction". + +--- Old: postgresql-14.21.tar.bz2 postgresql-14.21.tar.bz2.sha256 New: postgresql-14.22.tar.bz2 postgresql-14.22.tar.bz2.sha256 Other differences: -- ++ postgresql14.spec ++ --- /var/tmp/diff_new_pack.79dZat/_old 2026-03-02 18:46:49.228609717 +0100 +++ /var/tmp/diff_new_pack.79dZat/_new 2026-03-02 18:46:49.252610712 +0100 @@ -17,7 +17,7 @@ %define pgmajor 14 -%define pgminor 21 +%define pgminor 22 ### CUT HERE ### %define pgname postgresql%pgmajor ++ postgresql-14.21.tar.bz2 -> postgresql-14.22.tar.bz2 ++ /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.21.tar.bz2 /work/SRC/openSUSE:Factory/.postgresql14.new.29461/postgresql-14.22.tar.bz2 differ: char 11, line 1 ++ postgresql-14.21.tar.bz2.sha256 -> postgresql-14.22.tar.bz2.sha256 ++ --- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.21.tar.bz2.sha256 2026-02-12 19:38:03.114203092 +0100 +++ /work/SRC/openSUSE:Factory/.postgresql14.new.29461/postgresql-14.22.tar.bz2.sha256 2026-03-02 18:46:47.296529683 +0100 @@ -1 +1 @@ -5b30f19347efff32b6e09ed2cdff0b04e9aee913ec9bb7414de2b7c17b17f1f9 postgresql-14.21.tar.bz2 +f57938ad30067077720277f6d7db05aafc07d1545efd2ed82f199ba828a7ad34 postgresql-14.22.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2026-02-12 19:37:57
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1977 (New)
Package is "postgresql14"
Thu Feb 12 19:37:57 2026 rev:30 rq:1332748 version:14.21
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2025-12-18 18:37:18.280364490 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1977/postgresql14.changes
2026-02-12 19:38:03.174205617 +0100
@@ -2 +2,19 @@
-Fri Dec 12 08:12:36 UTC 2025 - Guillaume GARDET
+Wed Feb 11 19:27:43 UTC 2026 - Reinhard Max
+
+- Update to 14.21:
+ * https://www.postgresql.org/about/news/p-3235/
+ * https://www.postgresql.org/docs/release/14.21/
+ * bsc#1258008, CVE-2026-2003: Guard against unexpected
+dimensions of oidvector/int2vector
+ * bsc#1258009, CVE-2026-2004: Harden selectivity estimators
+against being attached to operators that accept unexpected
+data types.
+ * bsc#1258010, CVE-2026-2005: Fix buffer overrun in
+contrib/pgcrypto's PGP decryption functions.
+ * bsc#1258011, CVE-2026-2006: Fix inadequate validation of
+multibyte character lengths.
+ * obsoletes llvm-21-aarch64.patch
+- Disown /var/lib/pgsql to support transactional updates.
+
+---
+Tue Dec 9 08:23:44 UTC 2025 - Guillaume GARDET
@@ -8 +26 @@
-Mon Nov 24 16:49:27 UTC 2025 - Reinhard Max
+Mon Nov 24 16:22:39 UTC 2025 - Reinhard Max
Old:
llvm-21-aarch64.patch
postgresql-14.20.tar.bz2
postgresql-14.20.tar.bz2.sha256
New:
postgresql-14.21.tar.bz2
postgresql-14.21.tar.bz2.sha256
--(Old B)--
Old:multibyte character lengths.
* obsoletes llvm-21-aarch64.patch
- Disown /var/lib/pgsql to support transactional updates.
--(Old E)--
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.x8SE8q/_old 2026-02-12 19:38:03.894235913 +0100
+++ /var/tmp/diff_new_pack.x8SE8q/_new 2026-02-12 19:38:03.898236082 +0100
@@ -1,7 +1,7 @@
#
# spec file for package postgresql14
#
-# Copyright (c) 2025 SUSE LLC and contributors
+# Copyright (c) 2026 SUSE LLC and contributors
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@@ -17,7 +17,7 @@
%define pgmajor 14
-%define pgminor 20
+%define pgminor 21
### CUT HERE ###
%define pgname postgresql%pgmajor
@@ -218,8 +218,6 @@
%if %{with llvm}
Patch10:postgresql-llvm-optional.patch
Patch11:0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
-# PATCH-FIX-UPSTREAM - commit 0dceba2
-Patch12:llvm-21-aarch64.patch
%endif
URL:https://www.postgresql.org/
BuildRoot: %{_tmppath}/%{name}-%{version}-build
@@ -552,7 +550,6 @@
%if %{with llvm}
%patch -P 10
%patch -P 11
-%patch -P 12 -p1
%endif
touch -r tmp configure
rm tmp
@@ -688,7 +685,6 @@
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
@@ -956,7 +952,6 @@
%pglibdir/euc2004_sjis2004.so
%pglibdir/libpqwalreceiver.so
%pgextensiondir/plpgsql*
-%attr(750,postgres,postgres) %dir /var/lib/pgsql
%if %{with llvm}
%dir %pglibdir/bitcode
++ postgresql-14.20.tar.bz2 -> postgresql-14.21.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.20.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.1977/postgresql-14.21.tar.bz2
differ: char 11, line 1
++ postgresql-14.20.tar.bz2.sha256 -> postgresql-14.21.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.20.tar.bz2.sha256
2025-11-28 16:54:30.426264379 +0100
+++
/work/SRC/openSUSE:Factory/.postgresql14.new.1977/postgresql-14.21.tar.bz2.sha256
2026-02-12 19:38:03.114203092 +0100
@@ -1 +1 @@
-7527f10f1640761bc280ad97d105d286d0cf72e54d36d78cf68e5e5f752b646b
postgresql-14.20.tar.bz2
+5b30f19347efff32b6e09ed2cdff0b04e9aee913ec9bb7414de2b7c17b17f1f9
postgresql-14.21.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2025-12-18 18:36:21
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1928 (New)
Package is "postgresql14"
Thu Dec 18 18:36:21 2025 rev:29 rq:1323489 version:14.20
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2025-11-28 16:54:30.438264885 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1928/postgresql14.changes
2025-12-18 18:37:18.280364490 +0100
@@ -1,0 +2,6 @@
+Fri Dec 12 08:12:36 UTC 2025 - Guillaume GARDET
+
+- Fix build on aarch64 with upstream commit 0dceba2:
+ * llvm-21-aarch64.patch
+
+---
New:
llvm-21-aarch64.patch
--(New B)--
New:- Fix build on aarch64 with upstream commit 0dceba2:
* llvm-21-aarch64.patch
--(New E)--
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.XKJ3SG/_old 2025-12-18 18:37:19.256405494 +0100
+++ /var/tmp/diff_new_pack.XKJ3SG/_new 2025-12-18 18:37:19.260405663 +0100
@@ -218,6 +218,8 @@
%if %{with llvm}
Patch10:postgresql-llvm-optional.patch
Patch11:0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
+# PATCH-FIX-UPSTREAM - commit 0dceba2
+Patch12:llvm-21-aarch64.patch
%endif
URL:https://www.postgresql.org/
BuildRoot: %{_tmppath}/%{name}-%{version}-build
@@ -550,6 +552,7 @@
%if %{with llvm}
%patch -P 10
%patch -P 11
+%patch -P 12 -p1
%endif
touch -r tmp configure
rm tmp
++ llvm-21-aarch64.patch ++
>From 0dceba21d74f01e63aa690879b44808bbb74a9c3 Mon Sep 17 00:00:00 2001
From: Thomas Munro
Date: Sat, 22 Nov 2025 20:51:16 +1300
Subject: [PATCH] jit: Adjust AArch64-only code for LLVM 21.
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
LLVM 21 changed the arguments of RTDyldObjectLinkingLayer's
constructor, breaking compilation with the backported
SectionMemoryManager from commit 9044fc1d.
https://github.com/llvm/llvm-project/commit/cd585864c0bbbd74ed2a2b1ccc191eed4d1c8f90
Backpatch-through: 14
Author: Holger Hoffstätte
Reviewed-by: Anthonin Bonnefoy
Discussion:
https://postgr.es/m/d25e6e4a-d1b4-84d3-2f8a-6c45b975f53d%40applied-asynchrony.com
---
src/backend/jit/llvm/llvmjit_wrap.cpp | 7 +++
1 file changed, 7 insertions(+)
diff --git a/src/backend/jit/llvm/llvmjit_wrap.cpp
b/src/backend/jit/llvm/llvmjit_wrap.cpp
index da850d67ab647..c31a57b8563e8 100644
--- a/src/backend/jit/llvm/llvmjit_wrap.cpp
+++ b/src/backend/jit/llvm/llvmjit_wrap.cpp
@@ -53,7 +53,14 @@ DEFINE_SIMPLE_CONVERSION_FUNCTIONS(llvm::orc::ObjectLayer,
LLVMOrcObjectLayerRef
LLVMOrcObjectLayerRef
LLVMOrcCreateRTDyldObjectLinkingLayerWithSafeSectionMemoryManager(LLVMOrcExecutionSessionRef
ES)
{
+#if LLVM_VERSION_MAJOR >= 21
+ return wrap(new llvm::orc::RTDyldObjectLinkingLayer(
+ *unwrap(ES), [](const llvm::MemoryBuffer&) {
+ return
std::make_unique(nullptr, true);
+ }));
+#else
return wrap(new llvm::orc::RTDyldObjectLinkingLayer(
*unwrap(ES), [] { return
std::make_unique(nullptr, true); }));
+#endif
}
#endif
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2025-11-28 16:52:49
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.14147 (New)
Package is "postgresql14"
Fri Nov 28 16:52:49 2025 rev:28 rq:1320377 version:14.20
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2025-09-25 18:48:25.026010797 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.14147/postgresql14.changes
2025-11-28 16:54:30.438264885 +0100
@@ -1,0 +2,27 @@
+Mon Nov 24 16:49:27 UTC 2025 - Reinhard Max
+
+- Fix build with uring for post SLE15 code streams.
+
+---
+Fri Nov 14 15:43:43 UTC 2025 - Reinhard Max
+
+- Use %product_libs_llvm_ver to determine the LLVM version.
+- Remove conditionals for obsolete PostgreSQL releases.
+
+---
+Wed Nov 12 15:35:35 UTC 2025 - Reinhard Max
+
+- Upgrade to 14.20:
+ * https://www.postgresql.org/about/news/p-3171/
+ * https://www.postgresql.org/docs/release/14.20/
+ * bsc#1253332, CVE-2025-12817: Missing check for CREATE
+privileges on the schema in CREATE STATISTICS allowed table
+owners to create statistics in any schema, potentially leading
+to unexpected naming conflicts.
+ * bsc#125, CVE-2025-12818: Several places in libpq were not
+sufficiently careful about computing the required size of a
+memory allocation. Sufficiently large inputs could cause
+integer overflow, resulting in an undersized buffer, which
+would then lead to writing past the end of the buffer.
+
+---
Old:
postgresql-14.19.tar.bz2
postgresql-14.19.tar.bz2.sha256
New:
postgresql-14.20.tar.bz2
postgresql-14.20.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.dyUMSn/_old 2025-11-28 16:54:32.334344718 +0100
+++ /var/tmp/diff_new_pack.dyUMSn/_new 2025-11-28 16:54:32.334344718 +0100
@@ -16,13 +16,8 @@
#
-%define pgversion 14.19
%define pgmajor 14
-%define buildlibs 0
-%define tarversion %{pgversion}
-%define oldest_supported_llvm_ver 10
-# To be able to use cmake(LLVM) < ...
-%define latest_supported_llvm_ver_plus_one 19
+%define pgminor 20
### CUT HERE ###
%define pgname postgresql%pgmajor
@@ -40,6 +35,16 @@
%define pgextensiondir %pgdatadir/extension
%define pgcontribdir %pgdatadir/contrib
%define pgmandir %_mandir
+%define pgversion %{pgmajor}.%{pgminor}
+%define tarversion %{pgversion}%{?prerelease}
+
+%if %pgmajor == 18 || ( %pgmajor == 17 && 0%{?sle_version} == 120200 )
+# We still build the libs for PG 17 on SLE-12-SP2, because
+# newer PG versions will only be released for SP5.
+%define buildlibs 1
+%else
+%define buildlibs 0
+%endif
%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")
@@ -54,13 +59,8 @@
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} >= 15 || %pgmajor > 10
+# Use Python 3 for everything.
%define python python3
-%else
-%define python python
-%endif
%if %pgmajor >= 17
%bcond_with derived
@@ -68,10 +68,18 @@
%bcond_without derived
%endif
-%if %pgmajor >= 18
-%bcond_without curl
-%bcond_without uring
-%bcond_without numa
+%if %pgmajor >= 18 && 0%{?suse_version} >= 1500
+%bcond_without curl
+%if 0%{?sle_version} >= 150400 || 0%{?suse_version} >= 1600
+%bcond_without uring
+%else
+%bcond_with uring
+%endif
+%bcond_without numa
+%else
+%bcond_with curl
+%bcond_with uring
+%bcond_with numa
%endif
%if 0%{?suse_version} >= 1500
@@ -121,11 +129,12 @@
BuildRequires: %libpq
%endif
-%if 0%{?suse_version} >= 1500 && %pgmajor >= 11
+%if 0%{?suse_version} >= 1500
%ifarch riscv64 loongarch64
%bcond_with llvm
%else
%bcond_without llvm
+%{!?product_libs_llvm_ver: %global product_libs_llvm_ver 15}
%endif
%else
%bcond_with llvm
@@ -138,12 +147,6 @@
%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
@@ -152,14 +155,23 @@
BuildRequires: libselinux-devel
%endif
%if %{with llvm}
+BuildRequires: clang%{product_libs_llvm_ver}
BuildRequires: gcc-c++
-BuildRequires: (cmake(Clang) >= %{oldest_supported_llvm
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2025-08-15 21:52:19
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1085 (New)
Package is "postgresql14"
Fri Aug 15 21:52:19 2025 rev:26 rq:1299469 version:14.19
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2025-05-20 09:37:22.519479872 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1085/postgresql14.changes
2025-08-15 21:53:46.488397157 +0200
@@ -1,0 +2,17 @@
+Thu Aug 14 19:53:41 UTC 2025 - Marcus Rueckert
+
+- Upgrade to 14.19:
+ *
https://www.postgresql.org/about/news/postgresql-176-1610-1514-1419-1322-and-18-beta-3-released-3118/
+ * https://www.postgresql.org/docs/release/14.19/
+
+ Security Issues
+ * CVE-2025-8713: PostgreSQL optimizer statistics can expose
+sampled data within a view, partition, or child table
+(boo#1248120)
+ * CVE-2025-8714: PostgreSQL pg_dump lets superuser of origin
+server execute arbitrary code in psql client (boo#1248122)
+ * CVE-2025-8715: PostgreSQL pg_dump newline in object name
+executes arbitrary code in psql client and in restore target
+server (boo#1248119)
+
+---
Old:
postgresql-14.18.tar.bz2
postgresql-14.18.tar.bz2.sha256
New:
postgresql-14.19.tar.bz2
postgresql-14.19.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.dr25uL/_old 2025-08-15 21:53:47.308431257 +0200
+++ /var/tmp/diff_new_pack.dr25uL/_new 2025-08-15 21:53:47.308431257 +0200
@@ -1,7 +1,7 @@
#
# spec file for package postgresql14
#
-# Copyright (c) 2025 SUSE LLC
+# Copyright (c) 2025 SUSE LLC and contributors
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@@ -16,7 +16,7 @@
#
-%define pgversion 14.18
+%define pgversion 14.19
%define pgmajor 14
%define buildlibs 0
%define tarversion %{pgversion}
++ postgresql-14.18.tar.bz2 -> postgresql-14.19.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.18.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.1085/postgresql-14.19.tar.bz2
differ: char 11, line 1
++ postgresql-14.18.tar.bz2.sha256 -> postgresql-14.19.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.18.tar.bz2.sha256
2025-05-20 09:37:22.359472889 +0200
+++
/work/SRC/openSUSE:Factory/.postgresql14.new.1085/postgresql-14.19.tar.bz2.sha256
2025-08-15 21:53:46.480396825 +0200
@@ -1 +1 @@
-83ab29d6bfc3dc58b2ed3c664114fdfbeb6a0450c4b8d7fa69aee91e3ca14f8e
postgresql-14.18.tar.bz2
+727e9e334bc1a31940df808259f69fe47a59f6d42174b22ae62d67fe7a01ad80
postgresql-14.19.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2025-01-28 17:09:51
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.2316 (New)
Package is "postgresql14"
Tue Jan 28 17:09:51 2025 rev:22 rq:1240823 version:14.15
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2024-11-22 23:52:41.096297808 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.2316/postgresql14.changes
2025-01-28 17:09:52.486117045 +0100
@@ -1,0 +2,5 @@
+Tue Jan 28 12:23:29 UTC 2025 - Reinhard Max
+
+- Fix build, add postgresql-tzdata2025a.patch
+
+---
New:
postgresql-tzdata2025a.patch
BETA DEBUG BEGIN:
New:
- Fix build, add postgresql-tzdata2025a.patch
BETA DEBUG END:
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.rK1ABJ/_old 2025-01-28 17:09:53.238148104 +0100
+++ /var/tmp/diff_new_pack.rK1ABJ/_new 2025-01-28 17:09:53.242148270 +0100
@@ -1,7 +1,7 @@
#
# spec file for package postgresql14
#
-# Copyright (c) 2024 SUSE LLC
+# Copyright (c) 2025 SUSE LLC
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@@ -190,6 +190,7 @@
Patch10:postgresql-llvm-optional.patch
Patch11:0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
%endif
+Patch12:postgresql-tzdata2025a.patch
URL:https://www.postgresql.org/
BuildRoot: %{_tmppath}/%{name}-%{version}-build
Provides: postgresql = %version-%release
@@ -523,6 +524,7 @@
%if %{with llvm}
%patch -P 10
%patch -P 11
+%patch -P 12
%endif
touch -r tmp configure
rm tmp
++ postgresql-tzdata2025a.patch ++
--- src/test/regress/expected/timestamptz.out.orig
+++ src/test/regress/expected/timestamptz.out
@@ -2388,10 +2388,10 @@ SELECT make_timestamptz(2014, 12, 10, 0,
Tue Dec 09 23:00:00 2014
(1 row)
-SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE
'UTC';
+SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Asia/Singapore') AT TIME ZONE
'UTC';
timezone
--
- Wed Dec 09 15:56:00 1846
+ Fri Dec 09 17:04:35 1881
(1 row)
SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE
'UTC';
--- src/test/regress/sql/timestamptz.sql.orig
+++ src/test/regress/sql/timestamptz.sql
@@ -442,7 +442,7 @@ SELECT make_timestamptz(1973, 07, 15, 08
-- full timezone names
SELECT make_timestamptz(2014, 12, 10, 0, 0, 0, 'Europe/Prague') = timestamptz
'2014-12-10 00:00:00 Europe/Prague';
SELECT make_timestamptz(2014, 12, 10, 0, 0, 0, 'Europe/Prague') AT TIME ZONE
'UTC';
-SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE
'UTC';
+SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Asia/Singapore') AT TIME ZONE
'UTC';
SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE
'UTC';
SELECT make_timestamptz(1910, 12, 24, 0, 0, 0, 'Nehwon/Lankhmar');
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2024-05-10 12:05:15
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1880 (New)
Package is "postgresql14"
Fri May 10 12:05:15 2024 rev:18 rq:1172962 version:14.12
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2024-03-04 21:25:58.076206758 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1880/postgresql14.changes
2024-05-10 12:06:26.828341923 +0200
@@ -1,0 +2,23 @@
+Wed May 8 12:07:46 UTC 2024 - Reinhard Max
+
+- Upgrade to 14.12 (bsc#1224051):
+ * bsc#1224038, CVE-2024-4317: Restrict visibility of pg_stats_ext
+and pg_stats_ext_exprs entries to the table owner. See the
+release notes for the steps that have to be taken to fix
+existing PostgreSQL instances.
+ * Fix incompatibility with LLVM 18.
+ * https://www.postgresql.org/docs/release/14.12/
+- Prepare for PostgreSQL 17.
+- Make sure all compilation and doc generation happens in %build.
+
+---
+Wed May 1 15:24:39 UTC 2024 - Aaron Puchert
+
+- Require LLVM <= 17 for now, because LLVM 18 doesn't seem to work.
+
+---
+Thu Mar 7 15:04:40 UTC 2024 - Sarah Kriesch
+
+- Remove constraints file because improved memory usage for s390x
+
+---
Old:
_constraints
postgresql-14.11.tar.bz2
postgresql-14.11.tar.bz2.sha256
New:
postgresql-14.12.tar.bz2
postgresql-14.12.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.xUAagl/_old 2024-05-10 12:06:27.852379237 +0200
+++ /var/tmp/diff_new_pack.xUAagl/_new 2024-05-10 12:06:27.856379382 +0200
@@ -16,7 +16,7 @@
#
-%define pgversion 14.11
+%define pgversion 14.12
%define pgmajor 14
%define buildlibs 0
%define tarversion %{pgversion}
@@ -59,6 +59,12 @@
%define python python
%endif
+%if %pgmajor >= 17
+%bcond_with dreived
+%else
+%bcond_without derived
+%endif
+
%if 0%{?suse_version} >= 1500
%bcond_without liblz4
%endif
@@ -88,6 +94,12 @@
%if %{with liblz4}
BuildRequires: pkgconfig(liblz4)
%endif
+%if %{without derived}
+BuildRequires: bison
+BuildRequires: docbook-xsl-stylesheets
+BuildRequires: flex
+BuildRequires: perl
+%endif
%if %{with libzstd}
BuildRequires: pkgconfig(libzstd)
@@ -573,7 +585,7 @@
%if %mini
make -C src/interfaces %{?_smp_mflags} PACKAGE_TARNAME=%pgname
%else
-make %{?_smp_mflags} PACKAGE_TARNAME=%pgname
+make %{?_smp_mflags} PACKAGE_TARNAME=%pgname world
%if %{with check}
@@ -641,9 +653,9 @@
> contrib.files
rm flag
install -d -m 750 %buildroot/var/lib/pgsql
-install -d -m755 %buildroot%pgdocdir
+install -d -m 755 %buildroot%pgdocdir
cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \
- README HISTORY %buildroot%pgdocdir
+ README* HISTORY %buildroot%pgdocdir
# Use versioned names for the man pages:
for f in %buildroot%pgmandir/man*/*; do
mv $f ${f}pg%pgmajor
@@ -701,6 +713,7 @@
pg_receivewal \
pg_verify_checksums \
pg_checksums \
+ pg_combinebackup \
pg_verifybackup
%find_lang plpgsql-$VLANG main.files
@@ -711,6 +724,8 @@
pg_ctl \
pg_controldata \
pg_resetwal \
+ pg_createsubscriber \
+ pg_walsummary \
pg_waldump \
pg_resetxlog \
%if %pgmajor >= 15
@@ -924,7 +939,6 @@
%files llvmjit-devel
%defattr(-,root,root)
-%doc README
%files pltcl -f pltcl.lang
%defattr(-,root,root)
++ postgresql-14.11.tar.bz2 -> postgresql-14.12.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.11.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.1880/postgresql-14.12.tar.bz2
differ: char 11, line 1
++ postgresql-14.11.tar.bz2.sha256 -> postgresql-14.12.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.11.tar.bz2.sha256
2024-02-09 23:53:17.401061341 +0100
+++
/work/SRC/openSUSE:Factory/.postgresql14.new.1880/postgresql-14.12.tar.bz2.sha256
2024-05-10 12:06:26.716337842 +0200
@@ -1 +1 @@
-a670bd7dce22dcad4297b261136b3b1d4a09a6f541719562aa14ca63bf2968a8
postgresql-14.11.tar.bz2
+6118d08f9ddcc1bd83cf2b7cc74d3b583bdcec2f37e6245a8ac003b8faa80923
postgresql-14.12.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2024-02-09 23:52:55
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1815 (New)
Package is "postgresql14"
Fri Feb 9 23:52:55 2024 rev:16 rq:1145270 version:14.11
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-11-09 21:36:33.815467479 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1815/postgresql14.changes
2024-02-09 23:53:17.409061630 +0100
@@ -1,0 +2,18 @@
+Thu Feb 8 14:10:04 UTC 2024 - Reinhard Max
+
+- Upgrade to 14.11:
+ * bsc#1219679, CVE-2024-0985: Tighten security restrictions
+within REFRESH MATERIALIZED VIEW CONCURRENTLY.
+One step of a concurrent refresh command was run under weak
+security restrictions. If a materialized view's owner could
+persuade a superuser or other high-privileged user to perform a
+concurrent refresh on that view, the view's owner could control
+code executed with the privileges of the user running REFRESH.
+Fix things so that all user-determined code is run as the
+view's owner, as expected
+ * If you use GIN indexes, you may need to reindex after updating
+to this release.
+ * LLVM 18 is now supported.
+ * https://www.postgresql.org/docs/release/14.11/
+
+---
@@ -30 +47,0 @@
- * https://www.postgresql.org/about/news/2749
Old:
postgresql-14.10.tar.bz2
postgresql-14.10.tar.bz2.sha256
New:
postgresql-14.11.tar.bz2
postgresql-14.11.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.v2svXH/_old 2024-02-09 23:53:18.109086855 +0100
+++ /var/tmp/diff_new_pack.v2svXH/_new 2024-02-09 23:53:18.109086855 +0100
@@ -1,7 +1,7 @@
#
-# spec file
+# spec file for package postgresql14
#
-# Copyright (c) 2023 SUSE LLC
+# Copyright (c) 2024 SUSE LLC
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@@ -16,11 +16,11 @@
#
-%define pgversion 14.10
+%define pgversion 14.11
%define pgmajor 14
%define buildlibs 0
%define tarversion %{pgversion}
-%define latest_supported_llvm_ver 17
+%define latest_supported_llvm_ver 18
### CUT HERE ###
%define pgname postgresql%pgmajor
@@ -187,7 +187,7 @@
Provides: postgresql-implementation = %version-%release
Requires: %libpq >= %version
Requires(post): postgresql-noarch >= %pgmajor
-Requires(postun):postgresql-noarch >= %pgmajor
+Requires(postun): postgresql-noarch >= %pgmajor
# At this point we changed the package layout on SLE and conflict with
# older releases to get a clean cut.
Conflicts: postgresql-noarch < 12.0.1
@@ -277,7 +277,7 @@
Provides: postgresql-server-devel = %version-%release
Provides: postgresql-server-devel-implementation = %version-%release
Requires(post): postgresql-server-devel-noarch >= %pgmajor
-Requires(postun):postgresql-server-devel-noarch >= %pgmajor
+Requires(postun): postgresql-server-devel-noarch >= %pgmajor
Requires: %pgname-devel = %version
Requires: %pgname-server = %version-%release
# Installation of postgresql??-devel is exclusive
@@ -335,10 +335,10 @@
Provides: postgresql-server-implementation = %version-%release
Requires: %libpq >= %version
Requires(pre): postgresql-server-noarch >= %pgmajor
-Requires(preun):postgresql-server-noarch >= %pgmajor
-Requires(postun):postgresql-server-noarch >= %pgmajor
+Requires(preun): postgresql-server-noarch >= %pgmajor
+Requires(postun): postgresql-server-noarch >= %pgmajor
Requires(post): postgresql-noarch >= %pgmajor
-Requires(postun):postgresql-noarch >= %pgmajor
+Requires(postun): postgresql-noarch >= %pgmajor
%description server
PostgreSQL is an advanced object-relational database management system
@@ -377,7 +377,7 @@
%if %{with llvm}
Requires: %pgname-llvmjit = %version
Requires(post): postgresql-llvmjit-devel-noarch >= %pgmajor
-Requires(postun):postgresql-llvmjit-devel-noarch >= %pgmajor
+Requires(postun): postgresql-llvmjit-devel-noarch >= %pgmajor
%requires_file %_bindir/llc
%requires_file %_bindir/clang
%endif
++ postgresql-14.10.tar.bz2 -> postgresql-14.11.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.10.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.1815/postgresql-14.11.tar.bz2
differ: char 11, line 1
++ postgresql-14.10.tar.bz2.sha256 -> postgresql-14.11.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.10.tar.bz2.sha256
2023-11
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2023-11-09 21:36:15
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.17445 (New)
Package is "postgresql14"
Thu Nov 9 21:36:15 2023 rev:15 rq:1124707 version:14.10
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-10-31 20:26:50.344450871 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.17445/postgresql14.changes
2023-11-09 21:36:33.815467479 +0100
@@ -1,0 +2,32 @@
+Wed Nov 8 14:32:26 UTC 2023 - Reinhard Max
+
+- Update to 14.10:
+ * bsc#1216962, CVE-2023-5868: Fix handling of unknown-type
+arguments in DISTINCT "any" aggregate functions. This error led
+to a text-type value being interpreted as an unknown-type value
+(that is, a zero-terminated string) at runtime. This could
+result in disclosure of server memory following the text value.
+ * bsc#1216961, CVE-2023-5869: Detect integer overflow while
+computing new array dimensions. When assigning new elements to
+array subscripts that are outside the current array bounds, an
+undetected integer overflow could occur in edge cases. Memory
+stomps that are potentially exploitable for arbitrary code
+execution are possible, and so is disclosure of server memory.
+ * bsc#1216960, CVE-2023-5870: Prevent the pg_signal_backend role
+from signalling background workers and autovacuum processes.
+The documentation says that pg_signal_backend cannot issue
+signals to superuser-owned processes. It was able to signal
+these background processes, though, because they advertise a
+role OID of zero. Treat that as indicating superuser ownership.
+The security implications of cancelling one of these process
+types are fairly small so far as the core code goes (we'll just
+start another one), but extensions might add background workers
+that are more vulnerable.
+Also ensure that the is_superuser parameter is set correctly in
+such processes. No specific security consequences are known for
+that oversight, but it might be significant for some extensions.
+ * Add support for LLVM 16 and 17
+ * https://www.postgresql.org/about/news/2749
+ * https://www.postgresql.org/docs/14/release-14-10.html
+
+---
Old:
postgresql-14.9.tar.bz2
postgresql-14.9.tar.bz2.sha256
New:
postgresql-14.10.tar.bz2
postgresql-14.10.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.r88YSr/_old 2023-11-09 21:36:34.559494950 +0100
+++ /var/tmp/diff_new_pack.r88YSr/_new 2023-11-09 21:36:34.559494950 +0100
@@ -16,11 +16,11 @@
#
-%define pgversion 14.9
+%define pgversion 14.10
%define pgmajor 14
%define buildlibs 0
%define tarversion %{pgversion}
-%define latest_supported_llvm_ver 15
+%define latest_supported_llvm_ver 17
### CUT HERE ###
%define pgname postgresql%pgmajor
@@ -797,11 +797,9 @@
%post -n %pgname-%devel
/sbin/ldconfig
-/usr/share/postgresql/install-alternatives %pgmajor
%postun -n %pgname-%devel
/sbin/ldconfig
-/usr/share/postgresql/install-alternatives %pgmajor
%if %{with server_devel}
%post server-devel
++ postgresql-14.9.tar.bz2 -> postgresql-14.10.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.9.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.17445/postgresql-14.10.tar.bz2
differ: char 11, line 1
++ postgresql-14.9.tar.bz2.sha256 -> postgresql-14.10.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.9.tar.bz2.sha256
2023-10-25 18:05:36.536065373 +0200
+++
/work/SRC/openSUSE:Factory/.postgresql14.new.17445/postgresql-14.10.tar.bz2.sha256
2023-11-09 21:36:33.807467184 +0100
@@ -1 +1 @@
-b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
postgresql-14.9.tar.bz2
+c99431c48e9d470b0d0ab946eb2141a3cd19130c2fb4dc4b3284a7774ecc8399
postgresql-14.10.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2023-10-31 20:26:33
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.17445 (New)
Package is "postgresql14"
Tue Oct 31 20:26:33 2023 rev:14 rq:1121434 version:14.9
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-10-25 18:05:36.720071561 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.17445/postgresql14.changes
2023-10-31 20:26:50.344450871 +0100
@@ -1,0 +2,6 @@
+Tue Oct 31 10:57:13 UTC 2023 - Reinhard Max
+
+- boo#1216734: Revert the last change and make the devel package
+ independend of all other subpackages except for the libs.
+
+---
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.IxVPON/_old 2023-10-31 20:26:51.064477318 +0100
+++ /var/tmp/diff_new_pack.IxVPON/_new 2023-10-31 20:26:51.064477318 +0100
@@ -760,7 +760,9 @@
mkdir -p %buildroot%pgmandir/man1
cp -a doc/src/sgml/man1/ecpg.1 %buildroot%pgmandir/man1/ecpg.1pg%pgmajor
%find_lang ecpg-$VLANG devel.files
-ln -s %pgbindir/ecpg %buildroot%_bindir/ecpg
+# The devel subpackage is exclusive across versions
+# and not handled by update-alternatives.
+mv %buildroot%pgbindir/ecpg %buildroot%_bindir/ecpg
%if !%mini
%find_lang pg_config-$VLANG server-devel.files
@@ -960,10 +962,9 @@
%dir %pgbasedir
%dir %pgbindir
-%ghost %_bindir/ecpg
+%_bindir/ecpg
%_libdir/pkgconfig/*
%_libdir/lib*.so
-%pgbindir/ecpg
%pgincludedir
%if %{with server_devel}
%exclude %pgincludedir/server
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2023-10-25 18:04:45
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.24901 (New)
Package is "postgresql14"
Wed Oct 25 18:04:45 2023 rev:13 rq:1120251 version:14.9
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-05-12 20:40:03.562781445 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.24901/postgresql14.changes
2023-10-25 18:05:36.720071561 +0200
@@ -1,0 +2,39 @@
+Tue Oct 10 12:49:02 UTC 2023 - Reinhard Max
+
+- boo#1216022: Call install-alternatives from the devel subpackage
+ as well, otherwise the symlink for ecpg might be missing.
+
+---
+Mon Sep 18 15:24:14 UTC 2023 - Dominique Leuenberger
+
+- Also buildignore the postgresql*-implementation symbols: this is
+ needed in order to bootstrap when no postgresql version currently
+ has valid symbols provided. Once the packages are built, OBS
+ could translate this to the pgname-* packages and accept the
+ ignores; during bootstrap though, there is nothing providing the
+ symbol and the existing buildignores do not suffice.
+
+---
+Wed Aug 9 09:42:33 UTC 2023 - Reinhard Max
+
+- Update to 14.9:
+ * bsc#1214059, CVE-2023-39417: Disallow substituting a schema or
+owner name into an extension script if the name contains a
+quote, backslash, or dollar sign.
+ * https://www.postgresql.org/docs/14/release-14-9.html
+
+---
+Fri May 26 11:48:38 UTC 2023 - Reinhard Max
+
+- Restore the independence of mini builds from the main build after
+ the -mini name change from April 4, 2023.
+- Adjust icu handling to prepare for PostgreSQL 16.
+
+---
+Mon May 15 14:21:03 UTC 2023 - Reinhard Max
+
+- Overhaul postgresql-README.SUSE and move it from the binary
+ package to the noarch wrapper package.
+- Change the unix domain socket location from /var/run to /run.
+
+---
Old:
postgresql-14.8.tar.bz2
postgresql-14.8.tar.bz2.sha256
postgresql-README.SUSE
New:
postgresql-14.9.tar.bz2
postgresql-14.9.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.sx6ZIP/_old 2023-10-25 18:05:37.532098871 +0200
+++ /var/tmp/diff_new_pack.sx6ZIP/_new 2023-10-25 18:05:37.536099006 +0200
@@ -16,7 +16,7 @@
#
-%define pgversion 14.8
+%define pgversion 14.9
%define pgmajor 14
%define buildlibs 0
%define tarversion %{pgversion}
@@ -69,7 +69,11 @@
%if %mini
%bcond_with selinux
+%if %pgmajor >= 16
+%bcond_without icu
+%else
%bcond_with icu
+%endif
%else
BuildRequires: %{python}-devel
BuildRequires: docbook_4
@@ -143,11 +147,22 @@
BuildRequires: pkgconfig(krb5)
BuildRequires: pkgconfig(libsystemd)
BuildRequires: pkgconfig(systemd)
+#!BuildIgnore: %pgname
+#!BuildIgnore: %pgname-server
+#!BuildIgnore: %pgname-devel
+#!BuildIgnore: %pgname-server-devel
+#!BuildIgnore: %pgname-llvmjit
+#!BuildIgnore: %pgname-llvmjit-devel
+#!BuildIgnore: %pgname-contrib
+#!BuildIgnore: %pgname-docs
+#!BuildIgnore: %pgname-test
+#!BuildIgnore: %pgname-pltcl
+#!BuildIgnore: %pgname-plperl
+#!BuildIgnore: %pgname-plpython
#!BuildIgnore: postgresql-implementation
#!BuildIgnore: postgresql-server-implementation
-#!BuildIgnore: postgresql-devel-noarch
-#!BuildIgnore: postgresql-llvmjit-devel-noarch
-#!BuildIgnore: postgresql-server-devel-noarch
+#!BuildIgnore: postgresql-server-devel-implementation
+#!BuildIgnore: postgresql-llvmjit-devel-implementation
Summary:Basic Clients and Utilities for PostgreSQL
License:PostgreSQL
Group: Productivity/Databases/Tools
@@ -156,7 +171,6 @@
Source0:
https://ftp.postgresql.org/pub/source/v%{tarversion}/postgresql-%{tarversion}.tar.bz2
Source1:
https://ftp.postgresql.org/pub/source/v%{tarversion}/postgresql-%{tarversion}.tar.bz2.sha256
Source2:baselibs.conf
-Source3:postgresql-README.SUSE
Source17: postgresql-rpmlintrc
Patch1: postgresql-conf.patch
# PL/Perl needs to be linked with rpath (bsc#578053)
@@ -495,7 +509,7 @@
touch -r configure tmp
%patch1
%patch4
-%patch8 -p1
+%patch8
%patch9
%if %{with llvm}
%patch10
@@ -630,7 +644,6 @@
install -d -m755 %buildroot%pgdocdir
cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \
README HISTORY %buildroot%pgdocdir
-c
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2023-05-12 20:37:13
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1533 (New)
Package is "postgresql14"
Fri May 12 20:37:13 2023 rev:12 rq:1086555 version:14.8
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-04-21 14:17:56.086891271 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1533/postgresql14.changes
2023-05-12 20:40:03.562781445 +0200
@@ -1,0 +2,11 @@
+Wed May 10 12:58:22 UTC 2023 - Reinhard Max
+
+- Update to 14.8:
+ * bsc#1211228, CVE-2023-2454:
+Prevent CREATE SCHEMA from defeating changes in search_path
+ * bsc#1211229, CVE-2023-2455: Enforce row-level security
+policies correctly after inlining a set-returning function
+ * https://www.postgresql.org/about/news/2637/
+ * https://www.postgresql.org/docs/14/release-14-8.html
+
+---
Old:
postgresql-14.7.tar.bz2
postgresql-14.7.tar.bz2.sha256
New:
postgresql-14.8.tar.bz2
postgresql-14.8.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.LWdUhQ/_old 2023-05-12 20:40:04.350785776 +0200
+++ /var/tmp/diff_new_pack.LWdUhQ/_new 2023-05-12 20:40:04.382785952 +0200
@@ -16,7 +16,7 @@
#
-%define pgversion 14.7
+%define pgversion 14.8
%define pgmajor 14
%define buildlibs 0
%define tarversion %{pgversion}
++ postgresql-14.7.tar.bz2 -> postgresql-14.8.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.7.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.1533/postgresql-14.8.tar.bz2
differ: char 11, line 1
++ postgresql-14.7.tar.bz2.sha256 -> postgresql-14.8.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.7.tar.bz2.sha256
2023-02-10 14:33:57.861434372 +0100
+++
/work/SRC/openSUSE:Factory/.postgresql14.new.1533/postgresql-14.8.tar.bz2.sha256
2023-05-12 20:40:03.546781358 +0200
@@ -1 +1 @@
-cef60f0098fa8101c1546f4254e45b722af5431337945b37af207007630db331
postgresql-14.7.tar.bz2
+39d38f0030737ed03835debeefee3b37d335462ce4995e2497bc38d621ebe45a
postgresql-14.8.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2023-04-21 14:17:45
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1533 (New)
Package is "postgresql14"
Fri Apr 21 14:17:45 2023 rev:11 rq:1081146 version:14.7
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2023-02-10 14:33:57.865434396 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1533/postgresql14.changes
2023-04-21 14:17:56.086891271 +0200
@@ -1,0 +2,12 @@
+Tue Apr 18 09:05:09 UTC 2023 - Reinhard Max
+
+- bsc#1210303: Stop using the obsolete internal %_restart_on_update
+ macro and drop support for sysv init to simplify the scriptlets.
+
+---
+Tue Apr 4 10:57:41 UTC 2023 - Fabian Vogt
+
+- Include -mini in Name: to avoid conflicts in the source package
+ name and OBS internal dependency tracking.
+
+---
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.kMyRxg/_old 2023-04-21 14:17:57.442898873 +0200
+++ /var/tmp/diff_new_pack.kMyRxg/_new 2023-04-21 14:17:57.446898896 +0200
@@ -18,7 +18,6 @@
%define pgversion 14.7
%define pgmajor 14
-%define pgsuffix %pgmajor
%define buildlibs 0
%define tarversion %{pgversion}
%define latest_supported_llvm_ver 15
@@ -42,13 +41,14 @@
%define requires_file() %( readlink -f '%*' | LC_ALL=C xargs -r rpm -q --qf
'Requires: %%{name} >= %%{epoch}:%%{version}\\n' -f | sed -e 's/ (none):/ /' -e
's/ 0:/ /' | grep -v "is not")
-Name: %pgname
%if "@BUILD_FLAVOR@" == "mini"
%define devel devel-mini
%define mini 1
+Name: %pgname-mini
%else
%define devel devel
%define mini 0
+Name: %pgname
%endif
# Use Python 2 for for PostgreSQL 10 on SLE12.
@@ -95,13 +95,6 @@
BuildRequires: %libecpg
BuildRequires: %libpq
%endif
-%if 0%{?suse_version} >= 1300
-%bcond_without systemd
-%bcond_without systemd_notify
-%else
-%bcond_with systemd
-%bcond_with systemd_notify
-%endif
%if 0%{?suse_version} >= 1500 && %pgmajor >= 11
%ifarch riscv64
@@ -148,10 +141,8 @@
BuildRequires: openssl-devel
BuildRequires: pkg-config
BuildRequires: pkgconfig(krb5)
-%if %{with systemd_notify}
BuildRequires: pkgconfig(libsystemd)
BuildRequires: pkgconfig(systemd)
-%endif
#!BuildIgnore: postgresql-implementation
#!BuildIgnore: postgresql-server-implementation
#!BuildIgnore: postgresql-devel-noarch
@@ -240,7 +231,7 @@
This package provides the runtime library of the embedded SQL C
preprocessor for PostgreSQL.
-%package %devel
+%package -n %pgname-%devel
Summary:PostgreSQL client development header files and libraries
Group: Development/Libraries/C and C++
Provides: postgresql-devel = %version-%release
@@ -303,7 +294,7 @@
applications, see the postgresql%pgmajor-devel package.
%endif
-%description %devel
+%description -n %pgname-%devel
PostgreSQL is an advanced object-relational database management system
that supports an extended subset of the SQL standard, including
transactions, foreign keys, subqueries, triggers, and user-defined
@@ -547,9 +538,7 @@
%if %{with libzstd}
--with-zstd \
%endif
-%if %{with systemd_notify}
--with-systemd \
-%endif
%if %{with selinux}
--with-selinux \
%endif
@@ -791,14 +780,14 @@
%fdupes %buildroot
-%post %devel
+%post -n %pgname-%devel
/sbin/ldconfig
%if %{with server_devel}
%post server-devel
%endif
/usr/share/postgresql/install-alternatives %pgmajor
-%postun %devel
+%postun -n %pgname-%devel
/sbin/ldconfig
%if %{with server_devel}
%postun server-devel
@@ -818,45 +807,26 @@
%preun server
# Stop only when we are uninstalling the currently running version
-test -n "$FIRST_ARG" || FIRST_ARG="$1"
-if [ "$FIRST_ARG" -eq 0 ]; then
- %if %{with systemd}
-%define stop systemctl stop postgresql.service
-eval $(systemctl show postgresql.service --property=MainPID)
- %else
-%define stop /sbin/init.d postgresql stop
-MainPID=$(pidof -s postgres) || :
- %endif
- if test -n "$MainPID" && test "$MainPID" -ne 0; then
-BIN=$(readlink -n /proc/$MainPID/exe)
+test -x /usr/bin/systemctl &&
+ MAINPID=$(/usr/bin/systemctl show postgresql.service --property=MainPID
--value) ||:
+if test -n "$MAINPID" && test "$MAINPID" -ne 0; then
+ BIN=$(readlink -n /proc/$MAINPID/exe)
DIR=$(dirname ${BIN% *})
if test "$DIR" = "%pgbindir" -o "$DIR" = "%_bindir"; then
-%stop
-fi
+ %service_del_preun postgresql.service
fi
fi
%postun serve
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2023-02-10 14:33:52
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1848 (New)
Package is "postgresql14"
Fri Feb 10 14:33:52 2023 rev:10 rq:1064055 version:14.7
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2022-11-12 17:40:51.958059696 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1848/postgresql14.changes
2023-02-10 14:33:57.865434396 +0100
@@ -1,0 +2,9 @@
+Thu Feb 9 12:00:06 UTC 2023 - Reinhard Max
+
+- Update to 14.7:
+ * CVE-2022-41862, bsc#1208102: memory leak in libpq
+ * https://www.postgresql.org/about/news/2592/
+ * https://www.postgresql.org/docs/14/release-14-7.html
+- Bump latest_supported_llvm_ver to 15.
+
+---
Old:
postgresql-14.6.tar.bz2
postgresql-14.6.tar.bz2.sha256
New:
postgresql-14.7.tar.bz2
postgresql-14.7.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.CEPbpI/_old 2023-02-10 14:33:58.469438005 +0100
+++ /var/tmp/diff_new_pack.CEPbpI/_new 2023-02-10 14:33:58.473438029 +0100
@@ -1,7 +1,7 @@
#
# spec file
#
-# Copyright (c) 2022 SUSE LLC
+# Copyright (c) 2023 SUSE LLC
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@@ -16,12 +16,12 @@
#
-%define pgversion 14.6
+%define pgversion 14.7
%define pgmajor 14
%define pgsuffix %pgmajor
%define buildlibs 0
%define tarversion %{pgversion}
-%define latest_supported_llvm_ver 14
+%define latest_supported_llvm_ver 15
### CUT HERE ###
%define pgname postgresql%pgmajor
++ postgresql-14.6.tar.bz2 -> postgresql-14.7.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.6.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.1848/postgresql-14.7.tar.bz2
differ: char 11, line 1
++ postgresql-14.6.tar.bz2.sha256 -> postgresql-14.7.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.6.tar.bz2.sha256
2022-11-12 17:40:51.930059529 +0100
+++
/work/SRC/openSUSE:Factory/.postgresql14.new.1848/postgresql-14.7.tar.bz2.sha256
2023-02-10 14:33:57.861434372 +0100
@@ -1 +1 @@
-508840fc1809d39ab72274d5f137dabb9fd7fb4f933da4168aeebb20069edf22
postgresql-14.6.tar.bz2
+cef60f0098fa8101c1546f4254e45b722af5431337945b37af207007630db331
postgresql-14.7.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2022-11-12 17:40:42
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1597 (New)
Package is "postgresql14"
Sat Nov 12 17:40:42 2022 rev:9 rq:1035222 version:14.6
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2022-10-04 20:37:34.740903780 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1597/postgresql14.changes
2022-11-12 17:40:51.958059696 +0100
@@ -1,0 +2,8 @@
+Thu Nov 10 16:26:12 UTC 2022 - Reinhard Max
+
+- bsc#1205300: Update to 14.6:
+ * https://www.postgresql.org/about/news/2543/
+ * https://www.postgresql.org/docs/14/release-14-6.html
+- Sync spec file with postgresql15.
+
+---
Old:
postgresql-14.5.tar.bz2
postgresql-14.5.tar.bz2.sha256
New:
postgresql-14.6.tar.bz2
postgresql-14.6.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.LzO61D/_old 2022-11-12 17:40:52.834064911 +0100
+++ /var/tmp/diff_new_pack.LzO61D/_new 2022-11-12 17:40:52.834064911 +0100
@@ -16,7 +16,7 @@
#
-%define pgversion 14.5
+%define pgversion 14.6
%define pgmajor 14
%define pgsuffix %pgmajor
%define buildlibs 0
@@ -24,8 +24,7 @@
%define latest_supported_llvm_ver 14
### CUT HERE ###
-%define pgname postgresql%pgsuffix
-%define priority %pgsuffix
+%define pgname postgresql%pgmajor
%define libpq libpq5
%define libecpg libecpg6
%define libpq_so libpq.so.5
@@ -52,9 +51,9 @@
%define mini 0
%endif
-# Use Python 2 for PostgreSQL 9.x on all platforms and for PostgreSQL 10 on
SLE12.
+# Use Python 2 for for PostgreSQL 10 on SLE12.
# Use Python 3 for everything else.
-%if %pgsuffix < 90 && ( 0%{?is_opensuse} || 0%{?sle_version} >= 15 ||
%pgsuffix > 10 )
+%if 0%{?is_opensuse} || 0%{?sle_version} >= 15 || %pgmajor > 10
%define python python3
%else
%define python python
@@ -104,7 +103,7 @@
%bcond_with systemd_notify
%endif
-%if 0%{?suse_version} >= 1500 && %pgsuffix >= 11 && %pgsuffix < 90
+%if 0%{?suse_version} >= 1500 && %pgmajor >= 11
%ifarch riscv64
%bcond_with llvm
%else
@@ -121,7 +120,7 @@
%bcond_with check
%endif
-%if ( %pgsuffix >= 11 && %pgsuffix < 90 ) || %mini
+%if %pgmajor >= 11 || %mini
%bcond_without server_devel
%else
%bcond_with server_devel
@@ -163,8 +162,8 @@
Group: Productivity/Databases/Tools
Version:%pgversion
Release:0
-Source0:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{tarversion}.tar.bz2
-Source1:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{tarversion}.tar.bz2.sha256
+Source0:
https://ftp.postgresql.org/pub/source/v%{tarversion}/postgresql-%{tarversion}.tar.bz2
+Source1:
https://ftp.postgresql.org/pub/source/v%{tarversion}/postgresql-%{tarversion}.tar.bz2.sha256
Source2:baselibs.conf
Source3:postgresql-README.SUSE
Source17: postgresql-rpmlintrc
@@ -301,7 +300,7 @@
This package contains the header files and libraries needed to compile
C extensions that link into the PostgreSQL server. For building client
-applications, see the postgresql%pgsuffix-devel package.
+applications, see the postgresql%pgmajor-devel package.
%endif
%description %devel
@@ -317,7 +316,7 @@
which will interact with a PostgreSQL server.
For building PostgreSQL server extensions, see the
-postgresql%pgsuffix-server-devel package.
+postgresql%pgmajor-server-devel package.
%package server
Summary:The Programs Needed to Create and Run a PostgreSQL Server
@@ -645,7 +644,7 @@
cp -a %SOURCE3 %buildroot%pgdocdir/README.SUSE
# Use versioned names for the man pages:
for f in %buildroot%pgmandir/man*/*; do
-mv $f ${f}pg%pgsuffix
+mv $f ${f}pg%pgmajor
done
%endif
@@ -712,6 +711,9 @@
pg_resetwal \
pg_waldump \
pg_resetxlog \
+%if %pgmajor >= 15
+ pg_upgrade \
+%endif
postgres \
postmaster
@@ -722,7 +724,9 @@
pg_amcheck \
pg_standby \
pg_test_fsync \
+%if %pgmajor < 15
pg_upgrade \
+%endif
pgbench \
vacuumlo \
pg_test_timing
@@ -752,7 +756,7 @@
popd
mkdir -p %buildroot%pgmandir/man1
-cp -a doc/src/sgml/man1/ecpg.1 %buildroot%pgmandir/man1/ecpg.1pg%pgsuffix
+cp -a doc/src/sgml/man1/ecpg.1 %buildroot%pgmandir/man1/ecpg.1pg%pgmajor
%find_lang ecpg-$VLANG devel.files
ln -s %pgbindir/ecpg %buildroot%_bindir/ecpg
@@ -792,25 +796,25 @@
%if %{with server_devel}
%post server-devel
%endif
-/usr/share/pos
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2022-10-04 20:37:31
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.2275 (New)
Package is "postgresql14"
Tue Oct 4 20:37:31 2022 rev:8 rq:1006977 version:14.5
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2022-08-16 17:06:48.623710641 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.2275/postgresql14.changes
2022-10-04 20:37:34.740903780 +0200
@@ -1,0 +2,17 @@
+Thu Sep 22 21:26:36 UTC 2022 - Aaron Puchert
+
+- Create mechanism to specify the latest supported LLVM version.
+ Automatically pin to that version if the distribution has a newer
+ unsupported default version.
+
+---
+Tue Sep 13 12:32:36 UTC 2022 - Reinhard Max
+
+- Sync spec file with postgresql15.
+
+---
+Mon Sep 12 07:52:42 UTC 2022 - Andreas Schwab
+
+- Disable LLVM JIT on riscv64
+
+---
Old:
_multibuild
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.JQa9Nt/_old 2022-10-04 20:37:36.252905930 +0200
+++ /var/tmp/diff_new_pack.JQa9Nt/_new 2022-10-04 20:37:36.260905941 +0200
@@ -19,8 +19,9 @@
%define pgversion 14.5
%define pgmajor 14
%define pgsuffix %pgmajor
-%define buildlibs 1
+%define buildlibs 0
%define tarversion %{pgversion}
+%define latest_supported_llvm_ver 14
### CUT HERE ###
%define pgname postgresql%pgsuffix
@@ -59,6 +60,14 @@
%define python python
%endif
+%if 0%{?suse_version} >= 1500
+%bcond_without liblz4
+%endif
+
+%if 0%{?sle_version} >= 150100 || 0%{?suse_version} >= 1550
+%bcond_without libzstd
+%endif
+
%if %mini
%bcond_with selinux
%bcond_with icu
@@ -73,6 +82,14 @@
BuildRequires: tcl-devel
BuildRequires: timezone
BuildRequires: zlib-devel
+%if %{with liblz4}
+BuildRequires: pkgconfig(liblz4)
+%endif
+
+%if %{with libzstd}
+BuildRequires: pkgconfig(libzstd)
+%endif
+
%bcond_without selinux
%bcond_without icu
%if !%buildlibs
@@ -88,7 +105,11 @@
%endif
%if 0%{?suse_version} >= 1500 && %pgsuffix >= 11 && %pgsuffix < 90
+%ifarch riscv64
+%bcond_with llvm
+%else
%bcond_without llvm
+%endif
%else
%bcond_with llvm
%endif
@@ -114,10 +135,15 @@
BuildRequires: libselinux-devel
%endif
%if %{with llvm}
-BuildRequires: clang
BuildRequires: gcc-c++
+%if 0%{?product_libs_llvm_ver} > %{latest_supported_llvm_ver}
+BuildRequires: clang%{latest_supported_llvm_ver}
+BuildRequires: llvm%{latest_supported_llvm_ver}-devel
+%else
+BuildRequires: clang
BuildRequires: llvm-devel
%endif
+%endif
BuildRequires: libxslt-devel
BuildRequires: openldap2-devel
BuildRequires: openssl-devel
@@ -398,8 +424,8 @@
Group: Productivity/Databases/Tools
Provides: postgresql-contrib-implementation = %version-%release
Requires: postgresql-contrib-noarch >= %pgmajor
-Requires(post): %pgname >= %pgmajor
-Requires: %pgname >= %pgmajor
+Requires(post): %pgname >= %{version}
+Requires: %pgname >= %{version}
PreReq: %pgname-server = %version-%release
%description contrib
@@ -516,6 +542,12 @@
--with-uuid=e2fs \
--with-libxml \
--with-libxslt \
+%if %{with liblz4}
+--with-lz4 \
+%endif
+%if %{with libzstd}
+--with-zstd \
+%endif
%if %{with systemd_notify}
--with-systemd \
%endif
@@ -578,7 +610,7 @@
install -sm 0755 contrib/spi/{refint.so,autoinc.so}
%buildroot%pgtestdir/regress
install -sm 0755 src/test/regress/{pg_regress,regress.so}
%buildroot%pgtestdir/regress
for i in src/test/regress/{data,expected,input,output,sql}; do
- cp -r $i %buildroot%pgtestdir/regress/
+ test -d $i && cp -r $i %buildroot%pgtestdir/regress/
done
install -m 0644 src/test/regress/*_schedule %buildroot%pgtestdir/regress
# }}}
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package postgresql14 for openSUSE:Factory checked in at 2022-08-16 17:06:44 Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old) and /work/SRC/openSUSE:Factory/.postgresql14.new.1521 (New) Package is "postgresql14" Tue Aug 16 17:06:44 2022 rev:7 rq:995185 version:14.5 Changes: --- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes 2022-06-21 17:15:06.690327282 +0200 +++ /work/SRC/openSUSE:Factory/.postgresql14.new.1521/postgresql14.changes 2022-08-16 17:06:48.623710641 +0200 @@ -1,0 +2,8 @@ +Fri Aug 12 11:24:35 UTC 2022 - Reinhard Max + +- Update to 14.5: + * bsc#1202368, CVE-2022-2625: Extension scripts replace objects +not belonging to the extension. + * https://www.postgresql.org/docs/release/14.5/ + +--- Old: postgresql-14.4.tar.bz2 postgresql-14.4.tar.bz2.sha256 New: postgresql-14.5.tar.bz2 postgresql-14.5.tar.bz2.sha256 Other differences: -- ++ postgresql14.spec ++ --- /var/tmp/diff_new_pack.8N1PHi/_old 2022-08-16 17:06:49.455713129 +0200 +++ /var/tmp/diff_new_pack.8N1PHi/_new 2022-08-16 17:06:49.459713141 +0200 @@ -16,7 +16,7 @@ # -%define pgversion 14.4 +%define pgversion 14.5 %define pgmajor 14 %define pgsuffix %pgmajor %define buildlibs 1 ++ postgresql-14.4.tar.bz2 -> postgresql-14.5.tar.bz2 ++ /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.4.tar.bz2 /work/SRC/openSUSE:Factory/.postgresql14.new.1521/postgresql-14.5.tar.bz2 differ: char 11, line 1 ++ postgresql-14.4.tar.bz2.sha256 -> postgresql-14.5.tar.bz2.sha256 ++ --- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.4.tar.bz2.sha256 2022-06-21 17:15:06.678327271 +0200 +++ /work/SRC/openSUSE:Factory/.postgresql14.new.1521/postgresql-14.5.tar.bz2.sha256 2022-08-16 17:06:48.535710378 +0200 @@ -1 +1 @@ -c23b6237c5231c791511bdc79098617d6852e9e3bdf360efd8b5d15a1a3d8f6a postgresql-14.4.tar.bz2 +d4f72cb5fb857c9a9f75ec8cf091a1771272802f2178f0b2e65b7b6ff64f4a30 postgresql-14.5.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package postgresql14 for openSUSE:Factory checked in at 2022-06-21 17:15:05 Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old) and /work/SRC/openSUSE:Factory/.postgresql14.new.1548 (New) Package is "postgresql14" Tue Jun 21 17:15:05 2022 rev:6 rq:983858 version:14.4 Changes: --- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes 2022-05-14 22:54:54.891197325 +0200 +++ /work/SRC/openSUSE:Factory/.postgresql14.new.1548/postgresql14.changes 2022-06-21 17:15:06.690327282 +0200 @@ -1,0 +2,9 @@ +Fri Jun 17 06:32:15 UTC 2022 - Reinhard Max + +- bsc#1200437: Upgrade to 14.4: + * Prevent possible corruption of indexes created or rebuilt with +the CONCURRENTLY option. + * https://www.postgresql.org/docs/release/14.4/ + * https://www.postgresql.org/about/news/p-2470/ + +--- Old: postgresql-14.3.tar.bz2 postgresql-14.3.tar.bz2.sha256 New: postgresql-14.4.tar.bz2 postgresql-14.4.tar.bz2.sha256 Other differences: -- ++ postgresql14.spec ++ --- /var/tmp/diff_new_pack.1NEZLv/_old 2022-06-21 17:15:07.710328321 +0200 +++ /var/tmp/diff_new_pack.1NEZLv/_new 2022-06-21 17:15:07.714328326 +0200 @@ -16,7 +16,7 @@ # -%define pgversion 14.3 +%define pgversion 14.4 %define pgmajor 14 %define pgsuffix %pgmajor %define buildlibs 1 ++ postgresql-14.3.tar.bz2 -> postgresql-14.4.tar.bz2 ++ /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.3.tar.bz2 /work/SRC/openSUSE:Factory/.postgresql14.new.1548/postgresql-14.4.tar.bz2 differ: char 11, line 1 ++ postgresql-14.3.tar.bz2.sha256 -> postgresql-14.4.tar.bz2.sha256 ++ --- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.3.tar.bz2.sha256 2022-05-14 22:54:54.843197265 +0200 +++ /work/SRC/openSUSE:Factory/.postgresql14.new.1548/postgresql-14.4.tar.bz2.sha256 2022-06-21 17:15:06.678327271 +0200 @@ -1 +1 @@ -279057368bf59a919c05ada8f95c5e04abb43e74b9a2a69c3d46a20e07a9af38 postgresql-14.3.tar.bz2 +c23b6237c5231c791511bdc79098617d6852e9e3bdf360efd8b5d15a1a3d8f6a postgresql-14.4.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2022-05-14 22:54:47
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1538 (New)
Package is "postgresql14"
Sat May 14 22:54:47 2022 rev:5 rq:977049 version:14.3
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2022-04-14 17:23:10.779103090 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1538/postgresql14.changes
2022-05-14 22:54:54.891197325 +0200
@@ -1,0 +2,8 @@
+Thu May 12 10:33:20 UTC 2022 - Reinhard Max
+
+- Upgrade to 14.3:
+ * bsc#1199475, CVE-2022-1552: Confine additional operations
+within "security restricted operation" sandboxes.
+ * https://www.postgresql.org/docs/14/release-14-3.html
+
+---
Old:
postgresql-14.2.tar.bz2
postgresql-14.2.tar.bz2.sha256
New:
postgresql-14.3.tar.bz2
postgresql-14.3.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.5ZzGoj/_old 2022-05-14 22:54:55.715198354 +0200
+++ /var/tmp/diff_new_pack.5ZzGoj/_new 2022-05-14 22:54:55.719198360 +0200
@@ -16,7 +16,7 @@
#
-%define pgversion 14.2
+%define pgversion 14.3
%define pgmajor 14
%define pgsuffix %pgmajor
%define buildlibs 1
@@ -114,9 +114,9 @@
BuildRequires: libselinux-devel
%endif
%if %{with llvm}
-BuildRequires: clang13
+BuildRequires: clang
BuildRequires: gcc-c++
-BuildRequires: llvm13-devel
+BuildRequires: llvm-devel
%endif
BuildRequires: libxslt-devel
BuildRequires: openldap2-devel
++ postgresql-14.2.tar.bz2 -> postgresql-14.3.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.2.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.1538/postgresql-14.3.tar.bz2
differ: char 11, line 1
++ postgresql-14.2.tar.bz2.sha256 -> postgresql-14.3.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.2.tar.bz2.sha256
2022-04-14 17:23:10.343102580 +0200
+++
/work/SRC/openSUSE:Factory/.postgresql14.new.1538/postgresql-14.3.tar.bz2.sha256
2022-05-14 22:54:54.843197265 +0200
@@ -1 +1 @@
-2cf78b2e468912f8101d695db5340cf313c2e9f68a612fb71427524e8c9a977a
postgresql-14.2.tar.bz2
+279057368bf59a919c05ada8f95c5e04abb43e74b9a2a69c3d46a20e07a9af38
postgresql-14.3.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2022-04-14 17:22:57
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1941 (New)
Package is "postgresql14"
Thu Apr 14 17:22:57 2022 rev:4 rq:969861 version:14.2
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2021-12-07 00:00:30.720324665 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1941/postgresql14.changes
2022-04-14 17:23:10.779103090 +0200
@@ -1,0 +2,19 @@
+Wed Apr 13 12:17:48 UTC 2022 - Reinhard Max
+
+- bsc#1198166: Pin to llvm13 until the next patchlevel update.
+
+---
+Tue Feb 8 14:01:56 UTC 2022 - Reinhard Max
+
+- bsc#1195680: Upgrade to 14.2:
+ * https://www.postgresql.org/docs/14/release-14-2.html
+ * Reindexing might be needed after applying this upgrade, so
+please read the release notes carefully.
+
+---
+Sat Dec 11 17:27:53 UTC 2021 - Sarah Kriesch
+
+- boo#1190740: Add constraints file with 12GB of memory for s390x
+ as a workaround
+
+---
Old:
postgresql-14.1.tar.bz2
postgresql-14.1.tar.bz2.sha256
New:
_constraints
postgresql-14.2.tar.bz2
postgresql-14.2.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.gOFIyt/_old 2022-04-14 17:23:11.679104142 +0200
+++ /var/tmp/diff_new_pack.gOFIyt/_new 2022-04-14 17:23:11.683104146 +0200
@@ -1,7 +1,7 @@
#
# spec file
#
-# Copyright (c) 2021 SUSE LLC
+# Copyright (c) 2022 SUSE LLC
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@@ -16,7 +16,7 @@
#
-%define pgversion 14.1
+%define pgversion 14.2
%define pgmajor 14
%define pgsuffix %pgmajor
%define buildlibs 1
@@ -114,9 +114,9 @@
BuildRequires: libselinux-devel
%endif
%if %{with llvm}
-BuildRequires: clang
+BuildRequires: clang13
BuildRequires: gcc-c++
-BuildRequires: llvm-devel
+BuildRequires: llvm13-devel
%endif
BuildRequires: libxslt-devel
BuildRequires: openldap2-devel
++ _constraints ++
s390x
12
++ postgresql-14.1.tar.bz2 -> postgresql-14.2.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.1.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.1941/postgresql-14.2.tar.bz2
differ: char 11, line 1
++ postgresql-14.1.tar.bz2.sha256 -> postgresql-14.2.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.1.tar.bz2.sha256
2021-11-13 22:48:15.925237970 +0100
+++
/work/SRC/openSUSE:Factory/.postgresql14.new.1941/postgresql-14.2.tar.bz2.sha256
2022-04-14 17:23:10.343102580 +0200
@@ -1 +1 @@
-4d3c101ea7ae38982f06bdc73758b53727fb6402ecd9382006fa5ecc7c2ca41f
postgresql-14.1.tar.bz2
+2cf78b2e468912f8101d695db5340cf313c2e9f68a612fb71427524e8c9a977a
postgresql-14.2.tar.bz2
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2021-12-06 23:59:24
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.31177 (New)
Package is "postgresql14"
Mon Dec 6 23:59:24 2021 rev:3 rq:935204 version:14.1
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2021-11-13 22:48:15.953237991 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.31177/postgresql14.changes
2021-12-07 00:00:30.720324665 +0100
@@ -1,0 +2,9 @@
+Thu Nov 25 11:02:15 UTC 2021 - Reinhard Max
+
+- Add a llvmjit-devel subpackage to pull in the right versions
+ of clang and llvm for building extensions.
+- Fix some mistakes in the interdependencies between the
+ implementation packages and their noarch counterpart.
+- Update the BuildIgnore section.
+
+---
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.iuusKr/_old 2021-12-07 00:00:31.392322289 +0100
+++ /var/tmp/diff_new_pack.iuusKr/_new 2021-12-07 00:00:31.392322289 +0100
@@ -40,6 +40,8 @@
%define pgcontribdir %pgdatadir/contrib
%define pgmandir %_mandir
+%define requires_file() %( readlink -f '%*' | LC_ALL=C xargs -r rpm -q --qf
'Requires: %%{name} >= %%{epoch}:%%{version}\\n' -f | sed -e 's/ (none):/ /' -e
's/ 0:/ /' | grep -v "is not")
+
Name: %pgname
%if "@BUILD_FLAVOR@" == "mini"
%define devel devel-mini
@@ -125,10 +127,11 @@
BuildRequires: pkgconfig(libsystemd)
BuildRequires: pkgconfig(systemd)
%endif
-#!BuildIgnore: %pgname
-#!BuildIgnore: %pgname-server
#!BuildIgnore: postgresql-implementation
#!BuildIgnore: postgresql-server-implementation
+#!BuildIgnore: postgresql-devel-noarch
+#!BuildIgnore: postgresql-llvmjit-devel-noarch
+#!BuildIgnore: postgresql-server-devel-noarch
Summary:Basic Clients and Utilities for PostgreSQL
License:PostgreSQL
Group: Productivity/Databases/Tools
@@ -228,6 +231,7 @@
%else
Requires: %libecpg >= %version
Requires: %libpq >= %version
+Requires: postgresql-devel-noarch >= %pgmajor
%endif
# Installation of postgresql??-devel is exclusive
Provides: postgresql-devel-exclusive = %pgmajor
@@ -242,17 +246,13 @@
%endif
Provides: postgresql-server-devel = %version-%release
Provides: postgresql-server-devel-implementation = %version-%release
-Requires(post): postgresql-server-noarch >= %pgmajor
-Requires(postun):postgresql-server-noarch >= %pgmajor
+Requires(post): postgresql-server-devel-noarch >= %pgmajor
+Requires(postun):postgresql-server-devel-noarch >= %pgmajor
Requires: %pgname-devel = %version
Requires: %pgname-server = %version-%release
# Installation of postgresql??-devel is exclusive
Provides: postgresql-server-devel-exclusive = %pgmajor
Conflicts: postgresql-server-devel-exclusive < %pgmajor
-%if %{with llvm}
-Recommends: clang
-Recommends: llvm
-%endif
Requires: libxslt-devel
Requires: openssl-devel
Requires: pam-devel
@@ -262,6 +262,9 @@
%if %{with selinux}
Requires: libselinux-devel
%endif
+%if %{with llvm}
+Recommends: %pgname-llvmjit-devel = %version-%release
+%endif
%if %{with server_devel}
%description server-devel
@@ -335,6 +338,31 @@
deforming into native code, with the goal of accelerating analytics
queries.
+%package llvmjit-devel
+Summary:PostgreSQL development files for extensions with LLVM support
+Group: Development/Libraries/C and C++
+Provides: postgresql-llvmjit-devel = %version-%release
+Provides: postgresql-llvmjit-devel-implementation = %version-%release
+Requires: %pgname-server-devel = %version
+%if %{with llvm}
+Requires: %pgname-llvmjit = %version
+Requires(post): postgresql-llvmjit-devel-noarch >= %pgmajor
+Requires(postun):postgresql-llvmjit-devel-noarch >= %pgmajor
+%requires_file %_bindir/llc
+%requires_file %_bindir/clang
+%endif
+
+%description llvmjit-devel
+PostgreSQL is an advanced object-relational database management system
+that supports an extended subset of the SQL standard, including
+transactions, foreign keys, sub-queries, triggers, and user-defined
+types and functions.
+
+This package pulls in the right versions of llvm and clang to compile
+PostgreSQL extensions that support just-in-time compilation with LLVM,
+if llvm is supported. Otherwise it will just pull the
+%{pgname}-server-devel package.
+
%package test
Summary:The test suite for PostgreSQL
Group: Productivity/Databases/Servers
@@ -866,19 +894,21 @@
%pglibdir/*_and
commit postgresql14 for openSUSE:Factory
Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package postgresql14 for openSUSE:Factory
checked in at 2021-11-13 22:48:08
Comparing /work/SRC/openSUSE:Factory/postgresql14 (Old)
and /work/SRC/openSUSE:Factory/.postgresql14.new.1890 (New)
Package is "postgresql14"
Sat Nov 13 22:48:08 2021 rev:2 rq:930949 version:14.1
Changes:
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql14.changes
2021-10-12 21:48:16.863779619 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql14.new.1890/postgresql14.changes
2021-11-13 22:48:15.953237991 +0100
@@ -1,0 +2,15 @@
+Wed Nov 10 16:56:57 UTC 2021 - Reinhard Max
+
+- bsc#1192516: Upgrade to 14.1
+ * Make the server reject extraneous data after an SSL or GSS
+encryption handshake (CVE-2021-23214).
+ * Make libpq reject extraneous data after an SSL or GSS
+encryption handshake (CVE-2021-23222).
+ * https://www.postgresql.org/docs/14/release-14-1.html
+
+---
+Wed Oct 20 15:21:53 UTC 2021 - Reinhard Max
+
+- boo#1191782: Let rpmlint ignore shlib-policy-name-error.
+
+---
@@ -4,2 +18,0 @@
-- Let genlists skip non-existing binaries to avoid lots of version
- conditionals in the file lists.
Old:
postgresql-14.0.tar.bz2
postgresql-14.0.tar.bz2.sha256
New:
postgresql-14.1.tar.bz2
postgresql-14.1.tar.bz2.sha256
Other differences:
--
++ postgresql14.spec ++
--- /var/tmp/diff_new_pack.58wKE7/_old 2021-11-13 22:48:16.517238424 +0100
+++ /var/tmp/diff_new_pack.58wKE7/_new 2021-11-13 22:48:16.521238426 +0100
@@ -1,5 +1,5 @@
#
-# spec file for package postgresql14
+# spec file
#
# Copyright (c) 2021 SUSE LLC
#
@@ -16,7 +16,7 @@
#
-%define pgversion 14.0
+%define pgversion 14.1
%define pgmajor 14
%define pgsuffix %pgmajor
%define buildlibs 1
@@ -154,7 +154,7 @@
Provides: postgresql-implementation = %version-%release
Requires: %libpq >= %version
Requires(post): postgresql-noarch >= %pgmajor
-Requires(postun): postgresql-noarch >= %pgmajor
+Requires(postun):postgresql-noarch >= %pgmajor
# At this point we changed the package layout on SLE and conflict with
# older releases to get a clean cut.
Conflicts: postgresql-noarch < 12.0.1
@@ -243,7 +243,7 @@
Provides: postgresql-server-devel = %version-%release
Provides: postgresql-server-devel-implementation = %version-%release
Requires(post): postgresql-server-noarch >= %pgmajor
-Requires(postun): postgresql-server-noarch >= %pgmajor
+Requires(postun):postgresql-server-noarch >= %pgmajor
Requires: %pgname-devel = %version
Requires: %pgname-server = %version-%release
# Installation of postgresql??-devel is exclusive
@@ -302,10 +302,10 @@
Provides: postgresql-server-implementation = %version-%release
Requires: %libpq >= %version
Requires(pre): postgresql-server-noarch >= %pgmajor
-Requires(preun): postgresql-server-noarch >= %pgmajor
-Requires(postun): postgresql-server-noarch >= %pgmajor
+Requires(preun):postgresql-server-noarch >= %pgmajor
+Requires(postun):postgresql-server-noarch >= %pgmajor
Requires(post): postgresql-noarch >= %pgmajor
-Requires(postun): postgresql-noarch >= %pgmajor
+Requires(postun):postgresql-noarch >= %pgmajor
%description server
PostgreSQL is an advanced object-relational database management system
++ postgresql-14.0.tar.bz2 -> postgresql-14.1.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql14/postgresql-14.0.tar.bz2
/work/SRC/openSUSE:Factory/.postgresql14.new.1890/postgresql-14.1.tar.bz2
differ: char 11, line 1
++ postgresql-14.0.tar.bz2.sha256 -> postgresql-14.1.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql14/postgresql-14.0.tar.bz2.sha256
2021-10-12 21:48:16.475779064 +0200
+++
/work/SRC/openSUSE:Factory/.postgresql14.new.1890/postgresql-14.1.tar.bz2.sha256
2021-11-13 22:48:15.925237970 +0100
@@ -1 +1 @@
-ee2ad79126a7375e9102c4db77c4acae6ae6ffe3e082403b88826d96d927a122
postgresql-14.0.tar.bz2
+4d3c101ea7ae38982f06bdc73758b53727fb6402ecd9382006fa5ecc7c2ca41f
postgresql-14.1.tar.bz2
++ postgresql-rpmlintrc ++
--- /var/tmp/diff_new_pack.58wKE7/_old 2021-11-13 22:48:16.629238509 +0100
+++ /var/tmp/diff_new_pack.58wKE7/_new 2021-11-13 22:48:16.629238509 +0100
@@ -6,3 +6,4 @@
addFilter("no-dependency-on")
addFilter("no-soname")
addFilter("devel-file-in-non-devel-package")
+addFilter("shlib-policy-name-error")
