SUSE-SU-2023:3347-1: moderate: Security update for postgresql15

17 Aug 2023

      # Security update for postgresql15

Announcement ID: SUSE-SU-2023:3347-1  
Rating: moderate  
References:

  * #1214059
  * #1214061

Cross-References:

  * CVE-2023-39417
  * CVE-2023-39418

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 ):  7.5 CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H
  * CVE-2023-39418 ( SUSE ):  4.7 CVSS:3.1/AV:L/AC:H/PR:L/UI:N/S:U/C:N/I:H/A:N
  * CVE-2023-39418 ( NVD ):  3.1 CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:L/A:N

Affected Products:

  * Basesystem Module 15-SP4
  * Basesystem Module 15-SP5
  * openSUSE Leap 15.4
  * openSUSE Leap 15.5
  * Server Applications Module 15-SP4
  * Server Applications Module 15-SP5
  * 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 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

An update that solves two vulnerabilities can now be installed.

## Description:

This update for postgresql15 fixes the following issues:

  * Update to 15.4
  * CVE-2023-39417: Fixed potential SQL injection for trusted extensions.
    (bsc#1214059)
  * CVE-2023-39418: Fix MERGE to enforce row security. (bsc#1214061)

## Patch Instructions:

To install this SUSE Moderate 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.4  
    zypper in -t patch openSUSE-SLE-15.4-2023-3347=1

  * openSUSE Leap 15.5  
    zypper in -t patch openSUSE-SLE-15.5-2023-3347=1

  * Basesystem Module 15-SP4  
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP4-2023-3347=1

  * Basesystem Module 15-SP5  
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP5-2023-3347=1

  * SUSE Package Hub 15 15-SP4  
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP4-2023-3347=1

  * Server Applications Module 15-SP4  
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP4-2023-3347=1

  * Server Applications Module 15-SP5  
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP5-2023-3347=1

  * SUSE Manager Proxy 4.2  
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Proxy-4.2-2023-3347=1

  * SUSE Manager Retail Branch Server 4.2  
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Retail-Branch-
Server-4.2-2023-3347=1

  * SUSE Manager Server 4.2  
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Server-4.2-2023-3347=1

## Package List:

  * openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64)
    * postgresql15-plpython-15.4-150200.5.12.1
    * libecpg6-15.4-150200.5.12.1
    * postgresql15-devel-debuginfo-15.4-150200.5.12.1
    * libpq5-15.4-150200.5.12.1
    * postgresql15-devel-15.4-150200.5.12.1
    * postgresql15-server-devel-15.4-150200.5.12.1
    * postgresql15-llvmjit-15.4-150200.5.12.1
    * postgresql15-contrib-15.4-150200.5.12.1
    * postgresql15-15.4-150200.5.12.1
    * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-15.4-150200.5.12.1
    * postgresql15-llvmjit-devel-15.4-150200.5.12.1
    * postgresql15-server-15.4-150200.5.12.1
    * postgresql15-plpython-debuginfo-15.4-150200.5.12.1
    * libpq5-debuginfo-15.4-150200.5.12.1
    * postgresql15-debugsource-15.4-150200.5.12.1
    * postgresql15-test-15.4-150200.5.12.1
    * postgresql15-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1
    * libecpg6-debuginfo-15.4-150200.5.12.1
    * postgresql15-llvmjit-debuginfo-15.4-150200.5.12.1
    * postgresql15-plperl-15.4-150200.5.12.1
    * postgresql15-plperl-debuginfo-15.4-150200.5.12.1
    * postgresql15-server-debuginfo-15.4-150200.5.12.1
    * postgresql15-contrib-debuginfo-15.4-150200.5.12.1
  * openSUSE Leap 15.4 (x86_64)
    * libecpg6-32bit-debuginfo-15.4-150200.5.12.1
    * libpq5-32bit-debuginfo-15.4-150200.5.12.1
    * libpq5-32bit-15.4-150200.5.12.1
    * libecpg6-32bit-15.4-150200.5.12.1
  * openSUSE Leap 15.4 (noarch)
    * postgresql15-docs-15.4-150200.5.12.1
  * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
    * postgresql15-plpython-15.4-150200.5.12.1
    * libecpg6-15.4-150200.5.12.1
    * postgresql15-devel-debuginfo-15.4-150200.5.12.1
    * libpq5-15.4-150200.5.12.1
    * postgresql15-devel-15.4-150200.5.12.1
    * postgresql15-server-devel-15.4-150200.5.12.1
    * postgresql15-llvmjit-15.4-150200.5.12.1
    * postgresql15-contrib-15.4-150200.5.12.1
    * postgresql15-15.4-150200.5.12.1
    * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-15.4-150200.5.12.1
    * postgresql15-llvmjit-devel-15.4-150200.5.12.1
    * postgresql15-server-15.4-150200.5.12.1
    * postgresql15-plpython-debuginfo-15.4-150200.5.12.1
    * libpq5-debuginfo-15.4-150200.5.12.1
    * postgresql15-debugsource-15.4-150200.5.12.1
    * postgresql15-test-15.4-150200.5.12.1
    * postgresql15-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1
    * libecpg6-debuginfo-15.4-150200.5.12.1
    * postgresql15-llvmjit-debuginfo-15.4-150200.5.12.1
    * postgresql15-plperl-15.4-150200.5.12.1
    * postgresql15-plperl-debuginfo-15.4-150200.5.12.1
    * postgresql15-server-debuginfo-15.4-150200.5.12.1
    * postgresql15-contrib-debuginfo-15.4-150200.5.12.1
  * openSUSE Leap 15.5 (x86_64)
    * libecpg6-32bit-debuginfo-15.4-150200.5.12.1
    * libpq5-32bit-debuginfo-15.4-150200.5.12.1
    * libpq5-32bit-15.4-150200.5.12.1
    * libecpg6-32bit-15.4-150200.5.12.1
  * openSUSE Leap 15.5 (noarch)
    * postgresql15-docs-15.4-150200.5.12.1
  * Basesystem Module 15-SP4 (aarch64 ppc64le s390x x86_64)
    * postgresql15-debuginfo-15.4-150200.5.12.1
    * libpq5-15.4-150200.5.12.1
    * libpq5-debuginfo-15.4-150200.5.12.1
    * postgresql15-15.4-150200.5.12.1
    * postgresql15-debugsource-15.4-150200.5.12.1
  * Basesystem Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    * postgresql15-debuginfo-15.4-150200.5.12.1
    * libpq5-15.4-150200.5.12.1
    * libpq5-debuginfo-15.4-150200.5.12.1
    * postgresql15-15.4-150200.5.12.1
    * postgresql15-debugsource-15.4-150200.5.12.1
  * SUSE Package Hub 15 15-SP4 (aarch64 ppc64le s390x x86_64)
    * postgresql15-llvmjit-debuginfo-15.4-150200.5.12.1
    * postgresql15-test-15.4-150200.5.12.1
    * postgresql15-llvmjit-15.4-150200.5.12.1
    * postgresql15-llvmjit-devel-15.4-150200.5.12.1
  * Server Applications Module 15-SP4 (aarch64 ppc64le s390x x86_64)
    * postgresql15-plpython-15.4-150200.5.12.1
    * postgresql15-server-debuginfo-15.4-150200.5.12.1
    * postgresql15-debuginfo-15.4-150200.5.12.1
    * libecpg6-15.4-150200.5.12.1
    * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1
    * postgresql15-devel-debuginfo-15.4-150200.5.12.1
    * postgresql15-server-15.4-150200.5.12.1
    * libecpg6-debuginfo-15.4-150200.5.12.1
    * postgresql15-plpython-debuginfo-15.4-150200.5.12.1
    * postgresql15-devel-15.4-150200.5.12.1
    * postgresql15-plperl-15.4-150200.5.12.1
    * postgresql15-server-devel-15.4-150200.5.12.1
    * postgresql15-contrib-15.4-150200.5.12.1
    * postgresql15-debugsource-15.4-150200.5.12.1
    * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1
    * postgresql15-plperl-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-15.4-150200.5.12.1
    * postgresql15-contrib-debuginfo-15.4-150200.5.12.1
  * Server Applications Module 15-SP4 (noarch)
    * postgresql15-docs-15.4-150200.5.12.1
  * Server Applications Module 15-SP4 (ppc64le)
    * postgresql15-15.4-150200.5.12.1
  * Server Applications Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    * postgresql15-plpython-15.4-150200.5.12.1
    * postgresql15-server-debuginfo-15.4-150200.5.12.1
    * postgresql15-debuginfo-15.4-150200.5.12.1
    * libecpg6-15.4-150200.5.12.1
    * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1
    * postgresql15-devel-debuginfo-15.4-150200.5.12.1
    * postgresql15-server-15.4-150200.5.12.1
    * libecpg6-debuginfo-15.4-150200.5.12.1
    * postgresql15-plpython-debuginfo-15.4-150200.5.12.1
    * postgresql15-devel-15.4-150200.5.12.1
    * postgresql15-plperl-15.4-150200.5.12.1
    * postgresql15-server-devel-15.4-150200.5.12.1
    * postgresql15-contrib-15.4-150200.5.12.1
    * postgresql15-debugsource-15.4-150200.5.12.1
    * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1
    * postgresql15-plperl-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-15.4-150200.5.12.1
    * postgresql15-contrib-debuginfo-15.4-150200.5.12.1
  * Server Applications Module 15-SP5 (noarch)
    * postgresql15-docs-15.4-150200.5.12.1
  * SUSE Manager Proxy 4.2 (x86_64)
    * postgresql15-plpython-15.4-150200.5.12.1
    * libecpg6-15.4-150200.5.12.1
    * postgresql15-devel-debuginfo-15.4-150200.5.12.1
    * libpq5-15.4-150200.5.12.1
    * postgresql15-devel-15.4-150200.5.12.1
    * postgresql15-server-devel-15.4-150200.5.12.1
    * postgresql15-contrib-15.4-150200.5.12.1
    * postgresql15-15.4-150200.5.12.1
    * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-15.4-150200.5.12.1
    * postgresql15-server-15.4-150200.5.12.1
    * postgresql15-plpython-debuginfo-15.4-150200.5.12.1
    * libpq5-debuginfo-15.4-150200.5.12.1
    * postgresql15-debugsource-15.4-150200.5.12.1
    * postgresql15-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1
    * libecpg6-debuginfo-15.4-150200.5.12.1
    * postgresql15-plperl-15.4-150200.5.12.1
    * postgresql15-plperl-debuginfo-15.4-150200.5.12.1
    * postgresql15-server-debuginfo-15.4-150200.5.12.1
    * postgresql15-contrib-debuginfo-15.4-150200.5.12.1
  * SUSE Manager Proxy 4.2 (noarch)
    * postgresql15-docs-15.4-150200.5.12.1
  * SUSE Manager Retail Branch Server 4.2 (x86_64)
    * postgresql15-plpython-15.4-150200.5.12.1
    * libecpg6-15.4-150200.5.12.1
    * postgresql15-devel-debuginfo-15.4-150200.5.12.1
    * libpq5-15.4-150200.5.12.1
    * postgresql15-devel-15.4-150200.5.12.1
    * postgresql15-server-devel-15.4-150200.5.12.1
    * postgresql15-contrib-15.4-150200.5.12.1
    * postgresql15-15.4-150200.5.12.1
    * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-15.4-150200.5.12.1
    * postgresql15-server-15.4-150200.5.12.1
    * postgresql15-plpython-debuginfo-15.4-150200.5.12.1
    * libpq5-debuginfo-15.4-150200.5.12.1
    * postgresql15-debugsource-15.4-150200.5.12.1
    * postgresql15-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1
    * libecpg6-debuginfo-15.4-150200.5.12.1
    * postgresql15-plperl-15.4-150200.5.12.1
    * postgresql15-plperl-debuginfo-15.4-150200.5.12.1
    * postgresql15-server-debuginfo-15.4-150200.5.12.1
    * postgresql15-contrib-debuginfo-15.4-150200.5.12.1
  * SUSE Manager Retail Branch Server 4.2 (noarch)
    * postgresql15-docs-15.4-150200.5.12.1
  * SUSE Manager Server 4.2 (ppc64le s390x x86_64)
    * postgresql15-plpython-15.4-150200.5.12.1
    * libecpg6-15.4-150200.5.12.1
    * postgresql15-devel-debuginfo-15.4-150200.5.12.1
    * libpq5-15.4-150200.5.12.1
    * postgresql15-devel-15.4-150200.5.12.1
    * postgresql15-server-devel-15.4-150200.5.12.1
    * postgresql15-contrib-15.4-150200.5.12.1
    * postgresql15-15.4-150200.5.12.1
    * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-15.4-150200.5.12.1
    * postgresql15-server-15.4-150200.5.12.1
    * postgresql15-plpython-debuginfo-15.4-150200.5.12.1
    * libpq5-debuginfo-15.4-150200.5.12.1
    * postgresql15-debugsource-15.4-150200.5.12.1
    * postgresql15-debuginfo-15.4-150200.5.12.1
    * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1
    * libecpg6-debuginfo-15.4-150200.5.12.1
    * postgresql15-plperl-15.4-150200.5.12.1
    * postgresql15-plperl-debuginfo-15.4-150200.5.12.1
    * postgresql15-server-debuginfo-15.4-150200.5.12.1
    * postgresql15-contrib-debuginfo-15.4-150200.5.12.1
  * SUSE Manager Server 4.2 (noarch)
    * postgresql15-docs-15.4-150200.5.12.1

## References:

  * https://www.suse.com/security/cve/CVE-2023-39417.html
  * https://www.suse.com/security/cve/CVE-2023-39418.html
  * https://bugzilla.suse.com/show_bug.cgi?id=1214059
  * https://bugzilla.suse.com/show_bug.cgi?id=1214061

SUSE-SU-2023:3347-1: moderate: Security update for postgresql15

security＠lists.opensuse.org