Security update for postgresql10

Announcement ID: SUSE-SU-2021:2777-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
Affected Products:
  • SUSE Linux Enterprise High Performance Computing 15
  • SUSE Linux Enterprise High Performance Computing 15 LTSS 15
  • SUSE Linux Enterprise Server 15
  • SUSE Linux Enterprise Server 15 LTSS 15
  • SUSE Linux Enterprise Server ESPOS 15
  • SUSE Linux Enterprise Server for SAP Applications 15

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

Description:

This update for postgresql10 fixes the following issues:

  • Upgrade to version 10.17:
  • 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).

  • 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).
  • BuildRequire libpq5 and libecpg6 when not building them to avoid dangling symlinks in the devel package (bsc#1179765).

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 Linux Enterprise Server ESPOS 15
    zypper in -t patch SUSE-SLE-Product-HPC-15-2021-2777=1
  • SUSE Linux Enterprise High Performance Computing 15 LTSS 15
    zypper in -t patch SUSE-SLE-Product-HPC-15-2021-2777=1
  • SUSE Linux Enterprise Server 15 LTSS 15
    zypper in -t patch SUSE-SLE-Product-SLES-15-2021-2777=1
  • SUSE Linux Enterprise Server for SAP Applications 15
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-2021-2777=1

Package List:

  • SUSE Linux Enterprise Server ESPOS 15 (aarch64 x86_64)
    • postgresql10-10.17-4.35.1
    • postgresql10-contrib-10.17-4.35.1
    • libecpg6-debuginfo-10.17-4.35.1
    • postgresql10-contrib-debuginfo-10.17-4.35.1
    • postgresql10-plperl-debuginfo-10.17-4.35.1
    • libecpg6-10.17-4.35.1
    • libpq5-debuginfo-10.17-4.35.1
    • postgresql10-pltcl-debuginfo-10.17-4.35.1
    • postgresql10-devel-debuginfo-10.17-4.35.1
    • postgresql10-plperl-10.17-4.35.1
    • postgresql10-plpython-10.17-4.35.1
    • postgresql10-server-10.17-4.35.1
    • postgresql10-devel-10.17-4.35.1
    • postgresql10-debugsource-10.17-4.35.1
    • postgresql10-server-debuginfo-10.17-4.35.1
    • libpq5-10.17-4.35.1
    • postgresql10-pltcl-10.17-4.35.1
    • postgresql10-plpython-debuginfo-10.17-4.35.1
    • postgresql10-debuginfo-10.17-4.35.1
  • SUSE Linux Enterprise Server ESPOS 15 (noarch)
    • postgresql10-docs-10.17-4.35.1
  • SUSE Linux Enterprise Server ESPOS 15 (x86_64)
    • libpq5-32bit-debuginfo-10.17-4.35.1
    • libpq5-32bit-10.17-4.35.1
  • SUSE Linux Enterprise High Performance Computing 15 LTSS 15 (aarch64 x86_64)
    • postgresql10-10.17-4.35.1
    • postgresql10-contrib-10.17-4.35.1
    • libecpg6-debuginfo-10.17-4.35.1
    • postgresql10-contrib-debuginfo-10.17-4.35.1
    • postgresql10-plperl-debuginfo-10.17-4.35.1
    • libecpg6-10.17-4.35.1
    • libpq5-debuginfo-10.17-4.35.1
    • postgresql10-pltcl-debuginfo-10.17-4.35.1
    • postgresql10-devel-debuginfo-10.17-4.35.1
    • postgresql10-plperl-10.17-4.35.1
    • postgresql10-plpython-10.17-4.35.1
    • postgresql10-server-10.17-4.35.1
    • postgresql10-devel-10.17-4.35.1
    • postgresql10-debugsource-10.17-4.35.1
    • postgresql10-server-debuginfo-10.17-4.35.1
    • libpq5-10.17-4.35.1
    • postgresql10-pltcl-10.17-4.35.1
    • postgresql10-plpython-debuginfo-10.17-4.35.1
    • postgresql10-debuginfo-10.17-4.35.1
  • SUSE Linux Enterprise High Performance Computing 15 LTSS 15 (noarch)
    • postgresql10-docs-10.17-4.35.1
  • SUSE Linux Enterprise High Performance Computing 15 LTSS 15 (x86_64)
    • libpq5-32bit-debuginfo-10.17-4.35.1
    • libpq5-32bit-10.17-4.35.1
  • SUSE Linux Enterprise Server 15 LTSS 15 (aarch64 ppc64le s390x x86_64)
    • postgresql10-10.17-4.35.1
    • postgresql10-contrib-10.17-4.35.1
    • libecpg6-debuginfo-10.17-4.35.1
    • postgresql10-contrib-debuginfo-10.17-4.35.1
    • postgresql10-plperl-debuginfo-10.17-4.35.1
    • libecpg6-10.17-4.35.1
    • libpq5-debuginfo-10.17-4.35.1
    • postgresql10-pltcl-debuginfo-10.17-4.35.1
    • postgresql10-devel-debuginfo-10.17-4.35.1
    • postgresql10-plperl-10.17-4.35.1
    • postgresql10-plpython-10.17-4.35.1
    • postgresql10-server-10.17-4.35.1
    • postgresql10-devel-10.17-4.35.1
    • postgresql10-debugsource-10.17-4.35.1
    • postgresql10-server-debuginfo-10.17-4.35.1
    • libpq5-10.17-4.35.1
    • postgresql10-pltcl-10.17-4.35.1
    • postgresql10-plpython-debuginfo-10.17-4.35.1
    • postgresql10-debuginfo-10.17-4.35.1
  • SUSE Linux Enterprise Server 15 LTSS 15 (noarch)
    • postgresql10-docs-10.17-4.35.1
  • SUSE Linux Enterprise Server 15 LTSS 15 (x86_64)
    • libpq5-32bit-debuginfo-10.17-4.35.1
    • libpq5-32bit-10.17-4.35.1
  • SUSE Linux Enterprise Server for SAP Applications 15 (ppc64le x86_64)
    • postgresql10-10.17-4.35.1
    • postgresql10-contrib-10.17-4.35.1
    • libecpg6-debuginfo-10.17-4.35.1
    • postgresql10-contrib-debuginfo-10.17-4.35.1
    • postgresql10-plperl-debuginfo-10.17-4.35.1
    • libecpg6-10.17-4.35.1
    • libpq5-debuginfo-10.17-4.35.1
    • postgresql10-pltcl-debuginfo-10.17-4.35.1
    • postgresql10-devel-debuginfo-10.17-4.35.1
    • postgresql10-plperl-10.17-4.35.1
    • postgresql10-plpython-10.17-4.35.1
    • postgresql10-server-10.17-4.35.1
    • postgresql10-devel-10.17-4.35.1
    • postgresql10-debugsource-10.17-4.35.1
    • postgresql10-server-debuginfo-10.17-4.35.1
    • libpq5-10.17-4.35.1
    • postgresql10-pltcl-10.17-4.35.1
    • postgresql10-plpython-debuginfo-10.17-4.35.1
    • postgresql10-debuginfo-10.17-4.35.1
  • SUSE Linux Enterprise Server for SAP Applications 15 (noarch)
    • postgresql10-docs-10.17-4.35.1
  • SUSE Linux Enterprise Server for SAP Applications 15 (x86_64)
    • libpq5-32bit-debuginfo-10.17-4.35.1
    • libpq5-32bit-10.17-4.35.1

References: