# Security update for postgresql15

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

  * #1214059

  
Cross-References:

  * CVE-2023-39417

  
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

  
Affected Products:

  * openSUSE Leap 15.4
  * openSUSE Leap 15.5

  
  
An update that solves one vulnerability can now be installed.

## Description:

This update for postgresql15 fixes the following issues:

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

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

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

## Package List:

  * openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64)
    * postgresql12-pltcl-debuginfo-12.16-150200.8.47.1
    * postgresql12-plperl-debuginfo-12.16-150200.8.47.1
    * postgresql12-devel-12.16-150200.8.47.1
    * postgresql12-llvmjit-devel-12.16-150200.8.47.1
    * postgresql12-plperl-12.16-150200.8.47.1
    * postgresql12-llvmjit-debuginfo-12.16-150200.8.47.1
    * postgresql12-plpython-12.16-150200.8.47.1
    * postgresql12-llvmjit-12.16-150200.8.47.1
    * postgresql12-12.16-150200.8.47.1
    * postgresql12-devel-debuginfo-12.16-150200.8.47.1
    * postgresql12-pltcl-12.16-150200.8.47.1
    * postgresql12-contrib-debuginfo-12.16-150200.8.47.1
    * postgresql12-server-devel-12.16-150200.8.47.1
    * postgresql12-test-12.16-150200.8.47.1
    * postgresql12-contrib-12.16-150200.8.47.1
    * postgresql12-plpython-debuginfo-12.16-150200.8.47.1
    * postgresql12-debuginfo-12.16-150200.8.47.1
    * postgresql12-server-devel-debuginfo-12.16-150200.8.47.1
    * postgresql12-server-12.16-150200.8.47.1
    * postgresql12-debugsource-12.16-150200.8.47.1
    * postgresql12-server-debuginfo-12.16-150200.8.47.1
  * openSUSE Leap 15.4 (noarch)
    * postgresql12-docs-12.16-150200.8.47.1
  * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
    * postgresql12-pltcl-debuginfo-12.16-150200.8.47.1
    * postgresql12-plperl-debuginfo-12.16-150200.8.47.1
    * postgresql12-devel-12.16-150200.8.47.1
    * postgresql12-llvmjit-devel-12.16-150200.8.47.1
    * postgresql12-plperl-12.16-150200.8.47.1
    * postgresql12-llvmjit-debuginfo-12.16-150200.8.47.1
    * postgresql12-plpython-12.16-150200.8.47.1
    * postgresql12-llvmjit-12.16-150200.8.47.1
    * postgresql12-12.16-150200.8.47.1
    * postgresql12-devel-debuginfo-12.16-150200.8.47.1
    * postgresql12-pltcl-12.16-150200.8.47.1
    * postgresql12-contrib-debuginfo-12.16-150200.8.47.1
    * postgresql12-server-devel-12.16-150200.8.47.1
    * postgresql12-test-12.16-150200.8.47.1
    * postgresql12-contrib-12.16-150200.8.47.1
    * postgresql12-plpython-debuginfo-12.16-150200.8.47.1
    * postgresql12-debuginfo-12.16-150200.8.47.1
    * postgresql12-server-devel-debuginfo-12.16-150200.8.47.1
    * postgresql12-server-12.16-150200.8.47.1
    * postgresql12-debugsource-12.16-150200.8.47.1
    * postgresql12-server-debuginfo-12.16-150200.8.47.1
  * openSUSE Leap 15.5 (noarch)
    * postgresql12-docs-12.16-150200.8.47.1

## References:

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