Security update for postgresql12

Announcement ID: SUSE-SU-2021:1994-1
Rating: moderate
References:
Cross-References:
CVSS scores:
  • CVE-2021-32027 ( SUSE ): 8.8 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
  • CVE-2021-32027 ( NVD ): 8.8 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
  • CVE-2021-32028 ( SUSE ): 6.5 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
  • CVE-2021-32028 ( NVD ): 6.5 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
  • CVE-2021-32029 ( SUSE ): 6.5 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
  • CVE-2021-32029 ( NVD ): 6.5 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
Affected Products:
  • Basesystem Module 15-SP2
  • Legacy Module 15-SP3
  • Server Applications Module 15-SP2
  • SUSE Linux Enterprise Desktop 15 SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP3
  • SUSE Linux Enterprise Real Time 15 SP2
  • SUSE Linux Enterprise Server 15 SP2
  • SUSE Linux Enterprise Server 15 SP2 Business Critical Linux 15-SP2
  • SUSE Linux Enterprise Server 15 SP3
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3
  • SUSE Manager Proxy 4.1
  • SUSE Manager Proxy 4.2
  • SUSE Manager Retail Branch Server 4.1
  • SUSE Manager Retail Branch Server 4.2
  • SUSE Manager Server 4.1
  • SUSE Manager Server 4.2

An update that solves three vulnerabilities and has three security fixes can now be installed.

Description:

This update for postgresql12 fixes the following issues:

Upgrade to version 12.7:

  • CVE-2021-32027: Fixed integer overflows in array subscripting calculations (bsc#1185924).
  • CVE-2021-32028: Fixed mishandling of junk columns in INSERT ... ON CONFLICT ... UPDATE target lists (bsc#1185925).

  • CVE-2021-32029: Fixed possibly-incorrect computation of UPDATE ... RETURNING outputs for joined cross-partition updates (bsc#1185926).

  • Don't use %_stop_on_removal, because it was meant to be private and got removed from openSUSE. %_restart_on_update is also private, but still supported and needed for now (bsc#1183168).

  • Re-enable build of the llvmjit subpackage on SLE, but it will only be delivered on PackageHub for now (bsc#1183118).
  • Disable icu for PostgreSQL 10 (and older) on TW (bsc#1179945).

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:

  • Basesystem Module 15-SP2
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP2-2021-1994=1
  • Legacy Module 15-SP3
    zypper in -t patch SUSE-SLE-Module-Legacy-15-SP3-2021-1994=1
  • Server Applications Module 15-SP2
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP2-2021-1994=1

Package List:

  • Basesystem Module 15-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql12-debugsource-12.7-8.20.1
    • postgresql12-12.7-8.20.1
    • postgresql12-debuginfo-12.7-8.20.1
  • Legacy Module 15-SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql12-server-12.7-8.20.1
    • postgresql12-debuginfo-12.7-8.20.1
    • postgresql12-pltcl-debuginfo-12.7-8.20.1
    • postgresql12-contrib-12.7-8.20.1
    • postgresql12-plpython-debuginfo-12.7-8.20.1
    • postgresql12-server-devel-debuginfo-12.7-8.20.1
    • postgresql12-devel-debuginfo-12.7-8.20.1
    • postgresql12-server-debuginfo-12.7-8.20.1
    • postgresql12-contrib-debuginfo-12.7-8.20.1
    • postgresql12-debugsource-12.7-8.20.1
    • postgresql12-devel-12.7-8.20.1
    • postgresql12-plperl-12.7-8.20.1
    • postgresql12-pltcl-12.7-8.20.1
    • postgresql12-12.7-8.20.1
    • postgresql12-plperl-debuginfo-12.7-8.20.1
    • postgresql12-server-devel-12.7-8.20.1
    • postgresql12-plpython-12.7-8.20.1
  • Legacy Module 15-SP3 (noarch)
    • postgresql12-docs-12.7-8.20.1
  • Server Applications Module 15-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql12-server-12.7-8.20.1
    • postgresql12-debuginfo-12.7-8.20.1
    • postgresql12-pltcl-debuginfo-12.7-8.20.1
    • postgresql12-contrib-12.7-8.20.1
    • postgresql12-plpython-debuginfo-12.7-8.20.1
    • postgresql12-server-devel-debuginfo-12.7-8.20.1
    • postgresql12-devel-debuginfo-12.7-8.20.1
    • postgresql12-server-debuginfo-12.7-8.20.1
    • postgresql12-contrib-debuginfo-12.7-8.20.1
    • postgresql12-debugsource-12.7-8.20.1
    • postgresql12-devel-12.7-8.20.1
    • postgresql12-pltcl-12.7-8.20.1
    • postgresql12-plperl-12.7-8.20.1
    • postgresql12-plperl-debuginfo-12.7-8.20.1
    • postgresql12-server-devel-12.7-8.20.1
    • postgresql12-plpython-12.7-8.20.1
  • Server Applications Module 15-SP2 (noarch)
    • postgresql12-docs-12.7-8.20.1

References: