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