# Security update for postgresql16 Announcement ID: SUSE-SU-2024:2266-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: * Basesystem Module 15-SP6 * openSUSE Leap 15.6 * Server Applications Module 15-SP6 * SUSE Linux Enterprise Desktop 15 SP6 * SUSE Linux Enterprise Real Time 15 SP6 * SUSE Linux Enterprise Server 15 SP6 * SUSE Linux Enterprise Server for SAP Applications 15 SP6 An update that solves one vulnerability and has one security fix can now be installed. ## Description: This update for postgresql16 fixes the following issues: PostgreSQL upgrade to version 16.3 (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/16.3/ ## 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.6 zypper in -t patch SUSE-2024-2266=1 openSUSE-SLE-15.6-2024-2266=1 * Basesystem Module 15-SP6 zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP6-2024-2266=1 * Server Applications Module 15-SP6 zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP6-2024-2266=1 ## Package List: * openSUSE Leap 15.6 (aarch64 ppc64le s390x x86_64 i586) * postgresql16-plperl-16.2-150600.16.2.1 * postgresql16-plpython-16.2-150600.16.2.1 * postgresql16-devel-mini-16.2-150600.16.2.1 * postgresql16-server-devel-16.2-150600.16.2.1 * postgresql16-debuginfo-16.2-150600.16.2.1 * libecpg6-16.2-150600.16.2.1 * libpq5-debuginfo-16.2-150600.16.2.1 * postgresql16-devel-debuginfo-16.2-150600.16.2.1 * postgresql16-devel-mini-debuginfo-16.2-150600.16.2.1 * postgresql16-contrib-16.2-150600.16.2.1 * postgresql16-test-16.2-150600.16.2.1 * postgresql16-debugsource-16.2-150600.16.2.1 * postgresql16-pltcl-debuginfo-16.2-150600.16.2.1 * postgresql16-mini-debugsource-16.2-150600.16.2.1 * postgresql16-server-16.2-150600.16.2.1 * postgresql16-plperl-debuginfo-16.2-150600.16.2.1 * postgresql16-server-devel-debuginfo-16.2-150600.16.2.1 * libpq5-16.2-150600.16.2.1 * postgresql16-devel-16.2-150600.16.2.1 * libecpg6-debuginfo-16.2-150600.16.2.1 * postgresql16-llvmjit-devel-16.2-150600.16.2.1 * postgresql16-16.2-150600.16.2.1 * postgresql16-plpython-debuginfo-16.2-150600.16.2.1 * postgresql16-server-debuginfo-16.2-150600.16.2.1 * postgresql16-pltcl-16.2-150600.16.2.1 * postgresql16-contrib-debuginfo-16.2-150600.16.2.1 * postgresql16-llvmjit-16.2-150600.16.2.1 * postgresql16-llvmjit-debuginfo-16.2-150600.16.2.1 * openSUSE Leap 15.6 (x86_64) * libecpg6-32bit-debuginfo-16.2-150600.16.2.1 * libecpg6-32bit-16.2-150600.16.2.1 * libpq5-32bit-debuginfo-16.2-150600.16.2.1 * libpq5-32bit-16.2-150600.16.2.1 * openSUSE Leap 15.6 (noarch) * postgresql16-docs-16.2-150600.16.2.1 * openSUSE Leap 15.6 (aarch64_ilp32) * libpq5-64bit-debuginfo-16.2-150600.16.2.1 * libecpg6-64bit-debuginfo-16.2-150600.16.2.1 * libpq5-64bit-16.2-150600.16.2.1 * libecpg6-64bit-16.2-150600.16.2.1 * Basesystem Module 15-SP6 (aarch64 ppc64le s390x x86_64) * postgresql16-16.2-150600.16.2.1 * postgresql16-debuginfo-16.2-150600.16.2.1 * postgresql16-debugsource-16.2-150600.16.2.1 * libpq5-16.2-150600.16.2.1 * libpq5-debuginfo-16.2-150600.16.2.1 * Basesystem Module 15-SP6 (x86_64) * libpq5-32bit-16.2-150600.16.2.1 * libpq5-32bit-debuginfo-16.2-150600.16.2.1 * Server Applications Module 15-SP6 (aarch64 ppc64le s390x x86_64) * postgresql16-server-16.2-150600.16.2.1 * postgresql16-plpython-debuginfo-16.2-150600.16.2.1 * postgresql16-plperl-16.2-150600.16.2.1 * postgresql16-plperl-debuginfo-16.2-150600.16.2.1 * postgresql16-plpython-16.2-150600.16.2.1 * postgresql16-server-debuginfo-16.2-150600.16.2.1 * postgresql16-pltcl-16.2-150600.16.2.1 * postgresql16-server-devel-debuginfo-16.2-150600.16.2.1 * postgresql16-contrib-16.2-150600.16.2.1 * postgresql16-contrib-debuginfo-16.2-150600.16.2.1 * postgresql16-server-devel-16.2-150600.16.2.1 * postgresql16-debuginfo-16.2-150600.16.2.1 * libecpg6-16.2-150600.16.2.1 * postgresql16-debugsource-16.2-150600.16.2.1 * postgresql16-pltcl-debuginfo-16.2-150600.16.2.1 * postgresql16-devel-16.2-150600.16.2.1 * libecpg6-debuginfo-16.2-150600.16.2.1 * postgresql16-devel-debuginfo-16.2-150600.16.2.1 * Server Applications Module 15-SP6 (noarch) * postgresql16-docs-16.2-150600.16.2.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