# Security update for postgresql14 Announcement ID: SUSE-SU-2024:1768-1 Rating: moderate References: * bsc#1224038 * bsc#1224051 Cross-References: * CVE-2024-4317 CVSS scores: * CVE-2024-4317 ( SUSE ): 6.2 CVSS:3.1/AV:L/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N Affected Products: * Legacy Module 15-SP5 * openSUSE Leap 15.5 * SUSE Linux Enterprise Desktop 15 SP5 * SUSE Linux Enterprise High Performance Computing 15 SP5 * SUSE Linux Enterprise Micro 5.5 * SUSE Linux Enterprise Real Time 15 SP5 * SUSE Linux Enterprise Server 15 SP5 * SUSE Linux Enterprise Server for SAP Applications 15 SP5 * SUSE Package Hub 15 15-SP5 An update that solves one vulnerability and has one security fix can now be installed. ## Description: This update for postgresql14 fixes the following issues: PostgreSQL upgrade to version 14.12 (bsc#1224051): * CVE-2024-4317: Fixed visibility restriction of pg_stats_ext and pg_stats_ext_exprs entries to the table owner (bsc#1224038). Bug fixes: * Fix incompatibility with LLVM 18. * Prepare for PostgreSQL 17. * Make sure all compilation and doc generation happens in %build. * Require LLVM <= 17 for now, because LLVM 18 doesn't seem to work. * Remove constraints file because improved memory usage for s390x * Use %patch -P N instead of deprecated %patchN. Release notes: * https://www.postgresql.org/docs/release/14.12/ ## Patch Instructions: To install this SUSE update use the SUSE recommended installation methods like YaST online_update or "zypper patch". Alternatively you can run the command listed for your product: * openSUSE Leap 15.5 zypper in -t patch openSUSE-SLE-15.5-2024-1768=1 * Legacy Module 15-SP5 zypper in -t patch SUSE-SLE-Module-Legacy-15-SP5-2024-1768=1 * SUSE Package Hub 15 15-SP5 zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP5-2024-1768=1 ## Package List: * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64) * postgresql14-plperl-14.12-150200.5.44.1 * postgresql14-plpython-debuginfo-14.12-150200.5.44.1 * postgresql14-plpython-14.12-150200.5.44.1 * postgresql14-contrib-14.12-150200.5.44.1 * postgresql14-debugsource-14.12-150200.5.44.1 * postgresql14-test-14.12-150200.5.44.1 * postgresql14-llvmjit-debuginfo-14.12-150200.5.44.1 * postgresql14-server-14.12-150200.5.44.1 * postgresql14-contrib-debuginfo-14.12-150200.5.44.1 * postgresql14-pltcl-debuginfo-14.12-150200.5.44.1 * postgresql14-llvmjit-14.12-150200.5.44.1 * postgresql14-debuginfo-14.12-150200.5.44.1 * postgresql14-llvmjit-devel-14.12-150200.5.44.1 * postgresql14-devel-14.12-150200.5.44.1 * postgresql14-pltcl-14.12-150200.5.44.1 * postgresql14-14.12-150200.5.44.1 * postgresql14-server-devel-14.12-150200.5.44.1 * postgresql14-devel-debuginfo-14.12-150200.5.44.1 * postgresql14-server-devel-debuginfo-14.12-150200.5.44.1 * postgresql14-server-debuginfo-14.12-150200.5.44.1 * postgresql14-plperl-debuginfo-14.12-150200.5.44.1 * openSUSE Leap 15.5 (noarch) * postgresql14-docs-14.12-150200.5.44.1 * Legacy Module 15-SP5 (aarch64 ppc64le s390x x86_64) * postgresql14-plperl-14.12-150200.5.44.1 * postgresql14-devel-debuginfo-14.12-150200.5.44.1 * postgresql14-plperl-debuginfo-14.12-150200.5.44.1 * postgresql14-plpython-debuginfo-14.12-150200.5.44.1 * postgresql14-pltcl-debuginfo-14.12-150200.5.44.1 * postgresql14-llvmjit-14.12-150200.5.44.1 * postgresql14-debuginfo-14.12-150200.5.44.1 * postgresql14-contrib-14.12-150200.5.44.1 * postgresql14-14.12-150200.5.44.1 * postgresql14-plpython-14.12-150200.5.44.1 * postgresql14-server-14.12-150200.5.44.1 * postgresql14-debugsource-14.12-150200.5.44.1 * postgresql14-llvmjit-devel-14.12-150200.5.44.1 * postgresql14-server-devel-debuginfo-14.12-150200.5.44.1 * postgresql14-server-devel-14.12-150200.5.44.1 * postgresql14-server-debuginfo-14.12-150200.5.44.1 * postgresql14-devel-14.12-150200.5.44.1 * postgresql14-llvmjit-debuginfo-14.12-150200.5.44.1 * postgresql14-contrib-debuginfo-14.12-150200.5.44.1 * postgresql14-pltcl-14.12-150200.5.44.1 * Legacy Module 15-SP5 (noarch) * postgresql14-docs-14.12-150200.5.44.1 * SUSE Package Hub 15 15-SP5 (aarch64 ppc64le s390x x86_64) * postgresql14-llvmjit-14.12-150200.5.44.1 * postgresql14-debuginfo-14.12-150200.5.44.1 * postgresql14-debugsource-14.12-150200.5.44.1 * postgresql14-test-14.12-150200.5.44.1 * postgresql14-llvmjit-debuginfo-14.12-150200.5.44.1 ## References: * https://www.suse.com/security/cve/CVE-2024-4317.html * https://bugzilla.suse.com/show_bug.cgi?id=1224038 * https://bugzilla.suse.com/show_bug.cgi?id=1224051