Security update for postgresql10

Announcement ID:	SUSE-SU-2021:3481-1
Rating:	important
References:	bsc#1178961 bsc#1179765 bsc#1179945 bsc#1183118 bsc#1183168 bsc#1185924 bsc#1185925 bsc#1185952 bsc#1187751 bsc#1190177
Cross-References:	CVE-2021-32027 CVE-2021-32028
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:	HPE Helion OpenStack 8 SUSE Linux Enterprise High Performance Computing 12 SP2 SUSE Linux Enterprise High Performance Computing 12 SP3 SUSE Linux Enterprise High Performance Computing 12 SP4 SUSE Linux Enterprise High Performance Computing 12 SP5 SUSE Linux Enterprise Server 12 SP2 SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2 SUSE Linux Enterprise Server 12 SP3 SUSE Linux Enterprise Server 12 SP3 BCL 12-SP3 SUSE Linux Enterprise Server 12 SP3 ESPOS 12-SP3 SUSE Linux Enterprise Server 12 SP3 LTSS 12-SP3 SUSE Linux Enterprise Server 12 SP4 SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 SUSE Linux Enterprise Server 12 SP5 SUSE Linux Enterprise Server for SAP Applications 12 SP3 SUSE Linux Enterprise Server for SAP Applications 12 SP4 SUSE Linux Enterprise Server for SAP Applications 12 SP5 SUSE Linux Enterprise Software Development Kit 12 SP5 SUSE OpenStack Cloud 8 SUSE OpenStack Cloud 9 SUSE OpenStack Cloud Crowbar 8 SUSE OpenStack Cloud Crowbar 9

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

Description:

This update for postgresql10 fixes the following issues:

• Fix for build with llvm12 on s390x. (bsc#1185952)
• Re-enable 'icu' for PostgreSQL 10. (bsc#1179945)
• Add postgresqlXX-server-devel as a dependency for postgresql13-server-devel. (bsc#1187751)
• Upgrade to version 10.18. (bsc#1190177)

Upgrade to version 10.17 (already released for SUSE Linux Enterprise 12 SP5):

• 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).
• Fixed an issue droping irregular warning messages by removing the package. (bsc#1178961)
• Fixed an issue when build does not build the requiements to avoid dangling symlinks in the devel package. (bsc#1179765)
• Fix recently-added timetz test case so it works when the USA is not observing daylight savings time.

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:

• HPE Helion OpenStack 8
  zypper in -t patch HPE-Helion-OpenStack-8-2021-3481=1
• SUSE OpenStack Cloud 8
  zypper in -t patch SUSE-OpenStack-Cloud-8-2021-3481=1
• SUSE OpenStack Cloud 9
  zypper in -t patch SUSE-OpenStack-Cloud-9-2021-3481=1
• SUSE OpenStack Cloud Crowbar 8
  zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-8-2021-3481=1
• SUSE OpenStack Cloud Crowbar 9
  zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-9-2021-3481=1
• SUSE Linux Enterprise Server for SAP Applications 12 SP3
  zypper in -t patch SUSE-SLE-SAP-12-SP3-2021-3481=1
• SUSE Linux Enterprise Server for SAP Applications 12 SP4
  zypper in -t patch SUSE-SLE-SAP-12-SP4-2021-3481=1
• SUSE Linux Enterprise Software Development Kit 12 SP5
  zypper in -t patch SUSE-SLE-SDK-12-SP5-2021-3481=1
• SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2
  zypper in -t patch SUSE-SLE-SERVER-12-SP2-BCL-2021-3481=1
• SUSE Linux Enterprise Server 12 SP3 BCL 12-SP3
  zypper in -t patch SUSE-SLE-SERVER-12-SP3-BCL-2021-3481=1
• SUSE Linux Enterprise Server 12 SP3 ESPOS 12-SP3
  zypper in -t patch SUSE-SLE-SERVER-12-SP3-ESPOS-2021-3481=1
• SUSE Linux Enterprise Server 12 SP3 LTSS 12-SP3
  zypper in -t patch SUSE-SLE-SERVER-12-SP3-2021-3481=1
• SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4
  zypper in -t patch SUSE-SLE-SERVER-12-SP4-ESPOS-2021-3481=1
• SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4
  zypper in -t patch SUSE-SLE-SERVER-12-SP4-LTSS-2021-3481=1
• SUSE Linux Enterprise High Performance Computing 12 SP5
  zypper in -t patch SUSE-SLE-SERVER-12-SP5-2021-3481=1
• SUSE Linux Enterprise Server 12 SP5
  zypper in -t patch SUSE-SLE-SERVER-12-SP5-2021-3481=1
• SUSE Linux Enterprise Server for SAP Applications 12 SP5
  zypper in -t patch SUSE-SLE-SERVER-12-SP5-2021-3481=1

Package List:

• HPE Helion OpenStack 8 (x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• HPE Helion OpenStack 8 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE OpenStack Cloud 8 (x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE OpenStack Cloud 8 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE OpenStack Cloud 9 (x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE OpenStack Cloud 9 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE OpenStack Cloud Crowbar 8 (x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE OpenStack Cloud Crowbar 8 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE OpenStack Cloud Crowbar 9 (x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE OpenStack Cloud Crowbar 9 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Server for SAP Applications 12 SP3 (ppc64le x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server for SAP Applications 12 SP3 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Server for SAP Applications 12 SP4 (ppc64le x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server for SAP Applications 12 SP4 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Software Development Kit 12 SP5 (aarch64 ppc64le s390x x86_64)
  • postgresql10-devel-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-devel-debuginfo-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2 (x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP3 BCL 12-SP3 (x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP3 BCL 12-SP3 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP3 ESPOS 12-SP3 (aarch64 x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP3 ESPOS 12-SP3 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP3 LTSS 12-SP3 (aarch64 ppc64le s390x x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP3 LTSS 12-SP3 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 (aarch64 x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 (aarch64 ppc64le s390x x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise High Performance Computing 12 SP5 (aarch64 x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise High Performance Computing 12 SP5 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP5 (aarch64 ppc64le s390x x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server 12 SP5 (noarch)
  • postgresql10-docs-10.18-4.19.6
• SUSE Linux Enterprise Server for SAP Applications 12 SP5 (ppc64le x86_64)
  • postgresql10-10.18-4.19.6
  • postgresql10-server-10.18-4.19.6
  • postgresql10-pltcl-debuginfo-10.18-4.19.6
  • postgresql10-plpython-10.18-4.19.6
  • postgresql10-pltcl-10.18-4.19.6
  • postgresql10-plperl-debuginfo-10.18-4.19.6
  • postgresql10-server-debuginfo-10.18-4.19.6
  • postgresql10-debuginfo-10.18-4.19.6
  • postgresql10-contrib-debuginfo-10.18-4.19.6
  • postgresql10-debugsource-10.18-4.19.6
  • postgresql10-plpython-debuginfo-10.18-4.19.6
  • postgresql10-plperl-10.18-4.19.6
  • postgresql10-contrib-10.18-4.19.6
• SUSE Linux Enterprise Server for SAP Applications 12 SP5 (noarch)
  • postgresql10-docs-10.18-4.19.6

References:

• https://www.suse.com/security/cve/CVE-2021-32027.html
• https://www.suse.com/security/cve/CVE-2021-32028.html
• https://bugzilla.suse.com/show_bug.cgi?id=1178961
• https://bugzilla.suse.com/show_bug.cgi?id=1179765
• https://bugzilla.suse.com/show_bug.cgi?id=1179945
• https://bugzilla.suse.com/show_bug.cgi?id=1183118
• https://bugzilla.suse.com/show_bug.cgi?id=1183168
• https://bugzilla.suse.com/show_bug.cgi?id=1185924
• https://bugzilla.suse.com/show_bug.cgi?id=1185925
• https://bugzilla.suse.com/show_bug.cgi?id=1185952
• https://bugzilla.suse.com/show_bug.cgi?id=1187751
• https://bugzilla.suse.com/show_bug.cgi?id=1190177