SUSE-SU-2024:0551-1: important: Security update for postgresql15

20 Feb 2024

      # Security update for postgresql15

Announcement ID: SUSE-SU-2024:0551-1  
Rating: important  
References:

  * bsc#1219679

Cross-References:

  * CVE-2024-0985

CVSS scores:

  * CVE-2024-0985 ( SUSE ):  8.0 CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
  * CVE-2024-0985 ( NVD ):  8.0 CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H

Affected Products:

  * Basesystem Module 15-SP5
  * openSUSE Leap 15.5
  * Server Applications Module 15-SP5
  * SUSE Enterprise Storage 7.1
  * SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4
  * SUSE Linux Enterprise Desktop 15 SP5
  * SUSE Linux Enterprise High Performance Computing 15 SP3
  * SUSE Linux Enterprise High Performance Computing 15 SP4
  * SUSE Linux Enterprise High Performance Computing 15 SP5
  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4
  * SUSE Linux Enterprise Real Time 15 SP5
  * SUSE Linux Enterprise Server 15 SP3
  * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3
  * SUSE Linux Enterprise Server 15 SP4
  * SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4
  * SUSE Linux Enterprise Server 15 SP5
  * SUSE Linux Enterprise Server for SAP Applications 15 SP3
  * SUSE Linux Enterprise Server for SAP Applications 15 SP4
  * SUSE Linux Enterprise Server for SAP Applications 15 SP5
  * SUSE Manager Proxy 4.3
  * SUSE Manager Retail Branch Server 4.3
  * SUSE Manager Server 4.3

An update that solves one vulnerability can now be installed.

## Description:

This update for postgresql15 fixes the following issues:

Upgrade to 15.6:

  * CVE-2024-0985: Tighten security restrictions within REFRESH MATERIALIZED
    VIEW CONCURRENTLY (bsc#1219679).

## 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-551=1

  * Basesystem Module 15-SP5  
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP5-2024-551=1

  * Server Applications Module 15-SP5  
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP5-2024-551=1

  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-LTSS-2024-551=1

  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-ESPOS-2024-551=1

  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-LTSS-2024-551=1

  * SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4  
    zypper in -t patch SUSE-SLE-Product-SLED-15-SP4-LTSS-2024-551=1

  * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3  
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP3-LTSS-2024-551=1

  * SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4  
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP4-LTSS-2024-551=1

  * SUSE Linux Enterprise Server for SAP Applications 15 SP3  
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP3-2024-551=1

  * SUSE Linux Enterprise Server for SAP Applications 15 SP4  
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP4-2024-551=1

  * SUSE Manager Proxy 4.3  
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Proxy-4.3-2024-551=1

  * SUSE Manager Retail Branch Server 4.3  
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Retail-Branch-
Server-4.3-2024-551=1

  * SUSE Manager Server 4.3  
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Server-4.3-2024-551=1

  * SUSE Enterprise Storage 7.1  
    zypper in -t patch SUSE-Storage-7.1-2024-551=1

## Package List:

  * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-test-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-llvmjit-15.6-150200.5.22.1
    * postgresql15-llvmjit-debuginfo-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-llvmjit-devel-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * openSUSE Leap 15.5 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * Basesystem Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
  * Server Applications Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * Server Applications Module 15-SP5 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64
    x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (aarch64
    x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (aarch64
    x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4 (x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
  * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (aarch64 ppc64le s390x
    x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (aarch64 ppc64le s390x
    x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP4 (ppc64le x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP4 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Manager Proxy 4.3 (x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Manager Proxy 4.3 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Manager Retail Branch Server 4.3 (x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Manager Retail Branch Server 4.3 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Manager Server 4.3 (ppc64le s390x x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Manager Server 4.3 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1
  * SUSE Enterprise Storage 7.1 (aarch64 x86_64)
    * postgresql15-15.6-150200.5.22.1
    * postgresql15-plpython-debuginfo-15.6-150200.5.22.1
    * postgresql15-server-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-15.6-150200.5.22.1
    * postgresql15-devel-15.6-150200.5.22.1
    * postgresql15-debuginfo-15.6-150200.5.22.1
    * postgresql15-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-plpython-15.6-150200.5.22.1
    * postgresql15-server-devel-debuginfo-15.6-150200.5.22.1
    * postgresql15-contrib-15.6-150200.5.22.1
    * postgresql15-server-15.6-150200.5.22.1
    * postgresql15-server-devel-15.6-150200.5.22.1
    * postgresql15-debugsource-15.6-150200.5.22.1
    * postgresql15-plperl-debuginfo-15.6-150200.5.22.1
    * postgresql15-pltcl-debuginfo-15.6-150200.5.22.1
    * postgresql15-plperl-15.6-150200.5.22.1
  * SUSE Enterprise Storage 7.1 (noarch)
    * postgresql15-docs-15.6-150200.5.22.1

## References:

  * https://www.suse.com/security/cve/CVE-2024-0985.html
  * https://bugzilla.suse.com/show_bug.cgi?id=1219679

SUSE-SU-2024:0551-1: important: Security update for postgresql15

OPENSUSE-SECURITY-UPDATES