Security update for postgresql15

Announcement ID: SUSE-SU-2023:3348-1
Rating: moderate
References:
Cross-References:
CVSS scores:
  • CVE-2023-39417 ( SUSE ): 6.3 CVSS:3.1/AV:L/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:N
  • CVE-2023-39417 ( NVD ): 8.8 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
Affected Products:
  • Basesystem Module 15-SP4
  • Legacy Module 15-SP5
  • openSUSE Leap 15.4
  • openSUSE Leap 15.5
  • Server Applications Module 15-SP4
  • SUSE Linux Enterprise Desktop 15 SP4
  • SUSE Linux Enterprise Desktop 15 SP5
  • SUSE Linux Enterprise High Performance Computing 15 SP4
  • SUSE Linux Enterprise High Performance Computing 15 SP5
  • SUSE Linux Enterprise Micro 5.3
  • SUSE Linux Enterprise Micro 5.4
  • SUSE Linux Enterprise Micro 5.5
  • SUSE Linux Enterprise Real Time 15 SP4
  • SUSE Linux Enterprise Real Time 15 SP5
  • SUSE Linux Enterprise Server 15 SP4
  • SUSE Linux Enterprise Server 15 SP5
  • SUSE Linux Enterprise Server for SAP Applications 15 SP4
  • SUSE Linux Enterprise Server for SAP Applications 15 SP5
  • SUSE Manager Proxy 4.2
  • SUSE Manager Proxy 4.3
  • SUSE Manager Retail Branch Server 4.2
  • SUSE Manager Retail Branch Server 4.3
  • SUSE Manager Server 4.2
  • SUSE Manager Server 4.3
  • SUSE Package Hub 15 15-SP4
  • SUSE Package Hub 15 15-SP5

An update that solves one vulnerability can now be installed.

Description:

This update for postgresql15 fixes the following issues:

  • Update to 14.9
  • CVE-2023-39417: Fixed potential SQL injection for trusted extensions. (bsc#1214059)

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:

  • SUSE Manager Retail Branch Server 4.2
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Retail-Branch-Server-4.2-2023-3348=1
  • SUSE Manager Server 4.2
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Server-4.2-2023-3348=1
  • openSUSE Leap 15.4
    zypper in -t patch openSUSE-SLE-15.4-2023-3348=1
  • openSUSE Leap 15.5
    zypper in -t patch openSUSE-SLE-15.5-2023-3348=1
  • Basesystem Module 15-SP4
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP4-2023-3348=1
  • Legacy Module 15-SP5
    zypper in -t patch SUSE-SLE-Module-Legacy-15-SP5-2023-3348=1
  • SUSE Package Hub 15 15-SP4
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP4-2023-3348=1
  • SUSE Package Hub 15 15-SP5
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP5-2023-3348=1
  • Server Applications Module 15-SP4
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP4-2023-3348=1
  • SUSE Manager Proxy 4.2
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Proxy-4.2-2023-3348=1

Package List:

  • SUSE Manager Retail Branch Server 4.2 (x86_64)
    • postgresql14-plpython-14.9-150200.5.29.1
    • postgresql14-pltcl-14.9-150200.5.29.1
    • postgresql14-pltcl-debuginfo-14.9-150200.5.29.1
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-server-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-contrib-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-14.9-150200.5.29.1
    • postgresql14-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-14.9-150200.5.29.1
    • postgresql14-14.9-150200.5.29.1
    • postgresql14-server-debuginfo-14.9-150200.5.29.1
    • postgresql14-plpython-debuginfo-14.9-150200.5.29.1
    • postgresql14-devel-14.9-150200.5.29.1
    • postgresql14-contrib-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-devel-14.9-150200.5.29.1
  • SUSE Manager Retail Branch Server 4.2 (noarch)
    • postgresql14-docs-14.9-150200.5.29.1
  • SUSE Manager Server 4.2 (ppc64le s390x x86_64)
    • postgresql14-plpython-14.9-150200.5.29.1
    • postgresql14-pltcl-14.9-150200.5.29.1
    • postgresql14-pltcl-debuginfo-14.9-150200.5.29.1
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-server-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-contrib-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-14.9-150200.5.29.1
    • postgresql14-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-14.9-150200.5.29.1
    • postgresql14-14.9-150200.5.29.1
    • postgresql14-server-debuginfo-14.9-150200.5.29.1
    • postgresql14-plpython-debuginfo-14.9-150200.5.29.1
    • postgresql14-devel-14.9-150200.5.29.1
    • postgresql14-contrib-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-devel-14.9-150200.5.29.1
  • SUSE Manager Server 4.2 (noarch)
    • postgresql14-docs-14.9-150200.5.29.1
  • openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64)
    • postgresql14-plpython-14.9-150200.5.29.1
    • postgresql14-pltcl-debuginfo-14.9-150200.5.29.1
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-llvmjit-debuginfo-14.9-150200.5.29.1
    • postgresql14-14.9-150200.5.29.1
    • postgresql14-plpython-debuginfo-14.9-150200.5.29.1
    • postgresql14-devel-14.9-150200.5.29.1
    • postgresql14-contrib-14.9-150200.5.29.1
    • postgresql14-pltcl-14.9-150200.5.29.1
    • postgresql14-server-debuginfo-14.9-150200.5.29.1
    • postgresql14-llvmjit-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
    • postgresql14-contrib-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-14.9-150200.5.29.1
    • postgresql14-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-14.9-150200.5.29.1
    • postgresql14-plperl-debuginfo-14.9-150200.5.29.1
    • postgresql14-llvmjit-devel-14.9-150200.5.29.1
    • postgresql14-server-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-test-14.9-150200.5.29.1
    • postgresql14-server-devel-14.9-150200.5.29.1
  • openSUSE Leap 15.4 (noarch)
    • postgresql14-docs-14.9-150200.5.29.1
  • openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
    • postgresql14-plpython-14.9-150200.5.29.1
    • postgresql14-pltcl-debuginfo-14.9-150200.5.29.1
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-llvmjit-debuginfo-14.9-150200.5.29.1
    • postgresql14-14.9-150200.5.29.1
    • postgresql14-plpython-debuginfo-14.9-150200.5.29.1
    • postgresql14-devel-14.9-150200.5.29.1
    • postgresql14-contrib-14.9-150200.5.29.1
    • postgresql14-pltcl-14.9-150200.5.29.1
    • postgresql14-server-debuginfo-14.9-150200.5.29.1
    • postgresql14-llvmjit-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
    • postgresql14-contrib-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-14.9-150200.5.29.1
    • postgresql14-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-14.9-150200.5.29.1
    • postgresql14-plperl-debuginfo-14.9-150200.5.29.1
    • postgresql14-llvmjit-devel-14.9-150200.5.29.1
    • postgresql14-server-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-test-14.9-150200.5.29.1
    • postgresql14-server-devel-14.9-150200.5.29.1
  • openSUSE Leap 15.5 (noarch)
    • postgresql14-docs-14.9-150200.5.29.1
  • Basesystem Module 15-SP4 (aarch64 ppc64le s390x x86_64)
    • postgresql14-14.9-150200.5.29.1
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
  • Legacy Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    • postgresql14-plpython-14.9-150200.5.29.1
    • postgresql14-pltcl-14.9-150200.5.29.1
    • postgresql14-pltcl-debuginfo-14.9-150200.5.29.1
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-server-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-contrib-debuginfo-14.9-150200.5.29.1
    • postgresql14-llvmjit-debuginfo-14.9-150200.5.29.1
    • postgresql14-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-14.9-150200.5.29.1
    • postgresql14-plperl-debuginfo-14.9-150200.5.29.1
    • postgresql14-14.9-150200.5.29.1
    • postgresql14-server-14.9-150200.5.29.1
    • postgresql14-server-debuginfo-14.9-150200.5.29.1
    • postgresql14-plpython-debuginfo-14.9-150200.5.29.1
    • postgresql14-devel-14.9-150200.5.29.1
    • postgresql14-llvmjit-devel-14.9-150200.5.29.1
    • postgresql14-llvmjit-14.9-150200.5.29.1
    • postgresql14-contrib-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-devel-14.9-150200.5.29.1
  • Legacy Module 15-SP5 (noarch)
    • postgresql14-docs-14.9-150200.5.29.1
  • SUSE Package Hub 15 15-SP4 (aarch64 ppc64le s390x x86_64)
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-llvmjit-debuginfo-14.9-150200.5.29.1
    • postgresql14-llvmjit-devel-14.9-150200.5.29.1
    • postgresql14-llvmjit-14.9-150200.5.29.1
    • postgresql14-test-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
  • SUSE Package Hub 15 15-SP5 (aarch64 ppc64le s390x x86_64)
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-llvmjit-debuginfo-14.9-150200.5.29.1
    • postgresql14-llvmjit-14.9-150200.5.29.1
    • postgresql14-test-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
  • Server Applications Module 15-SP4 (aarch64 ppc64le s390x x86_64)
    • postgresql14-plpython-14.9-150200.5.29.1
    • postgresql14-pltcl-14.9-150200.5.29.1
    • postgresql14-pltcl-debuginfo-14.9-150200.5.29.1
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-server-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-contrib-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-14.9-150200.5.29.1
    • postgresql14-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-14.9-150200.5.29.1
    • postgresql14-server-debuginfo-14.9-150200.5.29.1
    • postgresql14-plpython-debuginfo-14.9-150200.5.29.1
    • postgresql14-devel-14.9-150200.5.29.1
    • postgresql14-contrib-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-devel-14.9-150200.5.29.1
  • Server Applications Module 15-SP4 (noarch)
    • postgresql14-docs-14.9-150200.5.29.1
  • SUSE Manager Proxy 4.2 (x86_64)
    • postgresql14-plpython-14.9-150200.5.29.1
    • postgresql14-pltcl-14.9-150200.5.29.1
    • postgresql14-pltcl-debuginfo-14.9-150200.5.29.1
    • postgresql14-debugsource-14.9-150200.5.29.1
    • postgresql14-server-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-contrib-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-14.9-150200.5.29.1
    • postgresql14-devel-debuginfo-14.9-150200.5.29.1
    • postgresql14-plperl-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-14.9-150200.5.29.1
    • postgresql14-14.9-150200.5.29.1
    • postgresql14-server-debuginfo-14.9-150200.5.29.1
    • postgresql14-plpython-debuginfo-14.9-150200.5.29.1
    • postgresql14-devel-14.9-150200.5.29.1
    • postgresql14-contrib-14.9-150200.5.29.1
    • postgresql14-debuginfo-14.9-150200.5.29.1
    • postgresql14-server-devel-14.9-150200.5.29.1
  • SUSE Manager Proxy 4.2 (noarch)
    • postgresql14-docs-14.9-150200.5.29.1

References: