Security update for postgresql10

SUSE Security Update: Security update for postgresql10
Announcement ID: SUSE-SU-2021:2777-1
Rating: moderate
References: #1179765 #1179945 #1183118 #1183168 #1185924 #1185925
Cross-References:CVE-2021-32027 CVE-2021-32028
Affected Products:
  • SUSE Linux Enterprise Server for SAP 15
  • SUSE Linux Enterprise Server 15-LTSS
  • SUSE Linux Enterprise High Performance Computing 15-LTSS
  • SUSE Linux Enterprise High Performance Computing 15-ESPOS

An update that solves two vulnerabilities and has four fixes is now available.

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

Package List:

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

References: