Security update for postgresql16

Announcement ID: SUSE-SU-2024:1652-1
Rating: moderate
References:
Cross-References:
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-SP5
  • openSUSE Leap 15.5
  • Server Applications Module 15-SP5
  • 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 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.5
    zypper in -t patch openSUSE-SLE-15.5-2024-1652=1
  • Basesystem Module 15-SP5
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP5-2024-1652=1
  • SUSE Package Hub 15 15-SP5
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP5-2024-1652=1
  • Server Applications Module 15-SP5
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP5-2024-1652=1

Package List:

  • openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
    • postgresql16-pltcl-debuginfo-16.3-150200.5.13.1
    • postgresql16-devel-debuginfo-16.3-150200.5.13.1
    • postgresql16-server-devel-16.3-150200.5.13.1
    • postgresql16-plpython-debuginfo-16.3-150200.5.13.1
    • postgresql16-devel-mini-debuginfo-16.3-150200.5.13.1
    • postgresql16-test-16.3-150200.5.13.1
    • libecpg6-16.3-150200.5.13.1
    • postgresql16-llvmjit-debuginfo-16.3-150200.5.13.1
    • postgresql16-plperl-debuginfo-16.3-150200.5.13.1
    • postgresql16-server-16.3-150200.5.13.1
    • postgresql16-contrib-debuginfo-16.3-150200.5.13.1
    • postgresql16-mini-debugsource-16.3-150200.5.13.1
    • postgresql16-server-debuginfo-16.3-150200.5.13.1
    • libecpg6-debuginfo-16.3-150200.5.13.1
    • postgresql16-devel-16.3-150200.5.13.1
    • postgresql16-pltcl-16.3-150200.5.13.1
    • postgresql16-contrib-16.3-150200.5.13.1
    • libpq5-debuginfo-16.3-150200.5.13.1
    • postgresql16-devel-mini-16.3-150200.5.13.1
    • libpq5-16.3-150200.5.13.1
    • postgresql16-llvmjit-16.3-150200.5.13.1
    • postgresql16-debuginfo-16.3-150200.5.13.1
    • postgresql16-debugsource-16.3-150200.5.13.1
    • postgresql16-16.3-150200.5.13.1
    • postgresql16-server-devel-debuginfo-16.3-150200.5.13.1
    • postgresql16-llvmjit-devel-16.3-150200.5.13.1
    • postgresql16-plperl-16.3-150200.5.13.1
    • postgresql16-plpython-16.3-150200.5.13.1
  • openSUSE Leap 15.5 (x86_64)
    • libpq5-32bit-16.3-150200.5.13.1
    • libpq5-32bit-debuginfo-16.3-150200.5.13.1
    • libecpg6-32bit-16.3-150200.5.13.1
    • libecpg6-32bit-debuginfo-16.3-150200.5.13.1
  • openSUSE Leap 15.5 (noarch)
    • postgresql16-docs-16.3-150200.5.13.1
  • Basesystem Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    • libpq5-debuginfo-16.3-150200.5.13.1
    • libpq5-16.3-150200.5.13.1
    • postgresql16-debuginfo-16.3-150200.5.13.1
    • postgresql16-16.3-150200.5.13.1
    • postgresql16-debugsource-16.3-150200.5.13.1
  • Basesystem Module 15-SP5 (x86_64)
    • libpq5-32bit-debuginfo-16.3-150200.5.13.1
    • libpq5-32bit-16.3-150200.5.13.1
  • SUSE Package Hub 15 15-SP5 (aarch64 ppc64le s390x x86_64)
    • postgresql16-test-16.3-150200.5.13.1
    • postgresql16-llvmjit-debuginfo-16.3-150200.5.13.1
    • postgresql16-llvmjit-16.3-150200.5.13.1
    • postgresql16-llvmjit-devel-16.3-150200.5.13.1
  • Server Applications Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    • postgresql16-pltcl-debuginfo-16.3-150200.5.13.1
    • postgresql16-contrib-16.3-150200.5.13.1
    • postgresql16-devel-debuginfo-16.3-150200.5.13.1
    • postgresql16-plpython-debuginfo-16.3-150200.5.13.1
    • libecpg6-16.3-150200.5.13.1
    • postgresql16-plperl-debuginfo-16.3-150200.5.13.1
    • postgresql16-server-16.3-150200.5.13.1
    • postgresql16-contrib-debuginfo-16.3-150200.5.13.1
    • postgresql16-pltcl-16.3-150200.5.13.1
    • postgresql16-server-debuginfo-16.3-150200.5.13.1
    • libecpg6-debuginfo-16.3-150200.5.13.1
    • postgresql16-server-devel-16.3-150200.5.13.1
    • postgresql16-debuginfo-16.3-150200.5.13.1
    • postgresql16-plperl-16.3-150200.5.13.1
    • postgresql16-server-devel-debuginfo-16.3-150200.5.13.1
    • postgresql16-devel-16.3-150200.5.13.1
    • postgresql16-plpython-16.3-150200.5.13.1
    • postgresql16-debugsource-16.3-150200.5.13.1
  • Server Applications Module 15-SP5 (noarch)
    • postgresql16-docs-16.3-150200.5.13.1

References: