Security update for postgresql10

Announcement ID:	SUSE-SU-2022:2893-1
Rating:	important
References:	bsc#1179945 bsc#1183168 bsc#1185952 bsc#1187751 bsc#1190177 bsc#1190740 bsc#1192516 bsc#1195680 bsc#1199475 bsc#1202368
Cross-References:	CVE-2021-23214 CVE-2021-23222 CVE-2022-1552 CVE-2022-2625
CVSS scores:	CVE-2021-23214 ( SUSE ): 8.1 CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H CVE-2021-23214 ( NVD ): 8.1 CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H CVE-2021-23222 ( SUSE ): 3.7 CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:L/I:N/A:N CVE-2021-23222 ( NVD ): 5.9 CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:N/A:N CVE-2022-1552 ( SUSE ): 8.8 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H CVE-2022-1552 ( NVD ): 8.8 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H CVE-2022-2625 ( SUSE ): 7.1 CVSS:3.1/AV:N/AC:H/PR:L/UI:R/S:U/C:H/I:H/A:H CVE-2022-2625 ( NVD ): 8.0 CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
Affected Products:	SUSE CaaS Platform 4.0 SUSE Enterprise Storage 6 SUSE Linux Enterprise High Performance Computing 15 SUSE Linux Enterprise High Performance Computing 15 LTSS 15 SUSE Linux Enterprise High Performance Computing 15 SP1 SUSE Linux Enterprise High Performance Computing 15 SP1 ESPOS 15-SP1 SUSE Linux Enterprise High Performance Computing 15 SP1 LTSS 15-SP1 SUSE Linux Enterprise Server 15 SUSE Linux Enterprise Server 15 LTSS 15 SUSE Linux Enterprise Server 15 SP1 SUSE Linux Enterprise Server 15 SP1 Business Critical Linux 15-SP1 SUSE Linux Enterprise Server 15 SP1 LTSS 15-SP1 SUSE Linux Enterprise Server ESPOS 15 SUSE Linux Enterprise Server for SAP Applications 15 SUSE Linux Enterprise Server for SAP Applications 15 SP1

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

Description:

This update for postgresql10 fixes the following issues:

• Upgrade to 10.22:

• CVE-2022-2625: Fixed an issue where extension scripts would replace objects not belonging to that extension (bsc#1202368).

• Upgrade to 10.21:

• CVE-2022-1552: Confined additional operations within "security restricted operation" sandboxes (bsc#1199475).

• Upgrade to 10.20 (bsc#1195680)

• Add constraints file with 12GB of memory for s390x as a workaround (boo#1190740)

• Upgrade to version 10.19 (bsc#1192516):

• CVE-2021-23214: Made the server reject extraneous data after an SSL or GSS encryption handshake

• CVE-2021-23222: Made libpq reject extraneous data after an SSL or GSS encryption handshake

• 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)

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-2022-2893=1
• SUSE Linux Enterprise High Performance Computing 15 LTSS 15
  zypper in -t patch SUSE-SLE-Product-HPC-15-2022-2893=1
• SUSE Linux Enterprise High Performance Computing 15 SP1 ESPOS 15-SP1
  zypper in -t patch SUSE-SLE-Product-HPC-15-SP1-ESPOS-2022-2893=1
• SUSE Linux Enterprise High Performance Computing 15 SP1 LTSS 15-SP1
  zypper in -t patch SUSE-SLE-Product-HPC-15-SP1-LTSS-2022-2893=1
• SUSE Linux Enterprise Server 15 LTSS 15
  zypper in -t patch SUSE-SLE-Product-SLES-15-2022-2893=1
• SUSE Linux Enterprise Server 15 SP1 Business Critical Linux 15-SP1
  zypper in -t patch SUSE-SLE-Product-SLES-15-SP1-BCL-2022-2893=1
• SUSE Linux Enterprise Server 15 SP1 LTSS 15-SP1
  zypper in -t patch SUSE-SLE-Product-SLES-15-SP1-LTSS-2022-2893=1
• SUSE Linux Enterprise Server for SAP Applications 15
  zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-2022-2893=1
• SUSE Linux Enterprise Server for SAP Applications 15 SP1
  zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP1-2022-2893=1
• SUSE Enterprise Storage 6
  zypper in -t patch SUSE-Storage-6-2022-2893=1
• SUSE CaaS Platform 4.0
  To install this update, use the SUSE CaaS Platform 'skuba' tool. It will inform you if it detects new updates and let you then trigger updating of the complete cluster in a controlled way.

Package List:

• SUSE Linux Enterprise Server ESPOS 15 (aarch64 x86_64)
  • postgresql10-debuginfo-10.22-150000.4.42.1
  • libpq5-debuginfo-10.22-150000.4.42.1
  • postgresql10-pltcl-debuginfo-10.22-150000.4.42.1
  • postgresql10-server-debuginfo-10.22-150000.4.42.1
  • libecpg6-10.22-150000.4.42.1
  • postgresql10-pltcl-10.22-150000.4.42.1
  • postgresql10-plpython-debuginfo-10.22-150000.4.42.1
  • postgresql10-10.22-150000.4.42.1
  • libecpg6-debuginfo-10.22-150000.4.42.1
  • postgresql10-devel-10.22-150000.4.42.1
  • postgresql10-debugsource-10.22-150000.4.42.1
  • postgresql10-devel-debuginfo-10.22-150000.4.42.1
  • postgresql10-plperl-debuginfo-10.22-150000.4.42.1
  • postgresql10-plpython-10.22-150000.4.42.1
  • postgresql10-contrib-debuginfo-10.22-150000.4.42.1
  • postgresql10-contrib-10.22-150000.4.42.1
  • postgresql10-server-10.22-150000.4.42.1
  • libpq5-10.22-150000.4.42.1
  • postgresql10-plperl-10.22-150000.4.42.1
• SUSE Linux Enterprise Server ESPOS 15 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql10-docs-10.22-150000.4.42.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE Linux Enterprise Server ESPOS 15 (x86_64)
  • libpq5-32bit-debuginfo-10.22-150000.4.42.1
  • libpq5-32bit-10.22-150000.4.42.1
• SUSE Linux Enterprise High Performance Computing 15 LTSS 15 (aarch64 x86_64)
  • postgresql10-debuginfo-10.22-150000.4.42.1
  • libpq5-debuginfo-10.22-150000.4.42.1
  • postgresql10-pltcl-debuginfo-10.22-150000.4.42.1
  • postgresql10-server-debuginfo-10.22-150000.4.42.1
  • libecpg6-10.22-150000.4.42.1
  • postgresql10-pltcl-10.22-150000.4.42.1
  • postgresql10-plpython-debuginfo-10.22-150000.4.42.1
  • postgresql10-10.22-150000.4.42.1
  • libecpg6-debuginfo-10.22-150000.4.42.1
  • postgresql10-devel-10.22-150000.4.42.1
  • postgresql10-debugsource-10.22-150000.4.42.1
  • postgresql10-devel-debuginfo-10.22-150000.4.42.1
  • postgresql10-plperl-debuginfo-10.22-150000.4.42.1
  • postgresql10-plpython-10.22-150000.4.42.1
  • postgresql10-contrib-debuginfo-10.22-150000.4.42.1
  • postgresql10-contrib-10.22-150000.4.42.1
  • postgresql10-server-10.22-150000.4.42.1
  • libpq5-10.22-150000.4.42.1
  • postgresql10-plperl-10.22-150000.4.42.1
• SUSE Linux Enterprise High Performance Computing 15 LTSS 15 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql10-docs-10.22-150000.4.42.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE Linux Enterprise High Performance Computing 15 LTSS 15 (x86_64)
  • libpq5-32bit-debuginfo-10.22-150000.4.42.1
  • libpq5-32bit-10.22-150000.4.42.1
• SUSE Linux Enterprise High Performance Computing 15 SP1 ESPOS 15-SP1 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE Linux Enterprise High Performance Computing 15 SP1 LTSS 15-SP1 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE Linux Enterprise Server 15 LTSS 15 (aarch64 ppc64le s390x x86_64)
  • postgresql10-debuginfo-10.22-150000.4.42.1
  • libpq5-debuginfo-10.22-150000.4.42.1
  • postgresql10-pltcl-debuginfo-10.22-150000.4.42.1
  • postgresql10-server-debuginfo-10.22-150000.4.42.1
  • libecpg6-10.22-150000.4.42.1
  • postgresql10-pltcl-10.22-150000.4.42.1
  • postgresql10-plpython-debuginfo-10.22-150000.4.42.1
  • postgresql10-10.22-150000.4.42.1
  • libecpg6-debuginfo-10.22-150000.4.42.1
  • postgresql10-devel-10.22-150000.4.42.1
  • postgresql10-debugsource-10.22-150000.4.42.1
  • postgresql10-devel-debuginfo-10.22-150000.4.42.1
  • postgresql10-plperl-debuginfo-10.22-150000.4.42.1
  • postgresql10-plpython-10.22-150000.4.42.1
  • postgresql10-contrib-debuginfo-10.22-150000.4.42.1
  • postgresql10-contrib-10.22-150000.4.42.1
  • postgresql10-server-10.22-150000.4.42.1
  • libpq5-10.22-150000.4.42.1
  • postgresql10-plperl-10.22-150000.4.42.1
• SUSE Linux Enterprise Server 15 LTSS 15 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql10-docs-10.22-150000.4.42.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE Linux Enterprise Server 15 LTSS 15 (x86_64)
  • libpq5-32bit-debuginfo-10.22-150000.4.42.1
  • libpq5-32bit-10.22-150000.4.42.1
• SUSE Linux Enterprise Server 15 SP1 Business Critical Linux 15-SP1 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE Linux Enterprise Server 15 SP1 LTSS 15-SP1 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE Linux Enterprise Server for SAP Applications 15 (ppc64le x86_64)
  • postgresql10-debuginfo-10.22-150000.4.42.1
  • libpq5-debuginfo-10.22-150000.4.42.1
  • postgresql10-pltcl-debuginfo-10.22-150000.4.42.1
  • postgresql10-server-debuginfo-10.22-150000.4.42.1
  • libecpg6-10.22-150000.4.42.1
  • postgresql10-pltcl-10.22-150000.4.42.1
  • postgresql10-plpython-debuginfo-10.22-150000.4.42.1
  • postgresql10-10.22-150000.4.42.1
  • libecpg6-debuginfo-10.22-150000.4.42.1
  • postgresql10-devel-10.22-150000.4.42.1
  • postgresql10-debugsource-10.22-150000.4.42.1
  • postgresql10-devel-debuginfo-10.22-150000.4.42.1
  • postgresql10-plperl-debuginfo-10.22-150000.4.42.1
  • postgresql10-plpython-10.22-150000.4.42.1
  • postgresql10-contrib-debuginfo-10.22-150000.4.42.1
  • postgresql10-contrib-10.22-150000.4.42.1
  • postgresql10-server-10.22-150000.4.42.1
  • libpq5-10.22-150000.4.42.1
  • postgresql10-plperl-10.22-150000.4.42.1
• SUSE Linux Enterprise Server for SAP Applications 15 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql10-docs-10.22-150000.4.42.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE Linux Enterprise Server for SAP Applications 15 (x86_64)
  • libpq5-32bit-debuginfo-10.22-150000.4.42.1
  • libpq5-32bit-10.22-150000.4.42.1
• SUSE Linux Enterprise Server for SAP Applications 15 SP1 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE Enterprise Storage 6 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1
• SUSE CaaS Platform 4.0 (noarch)
  • postgresql-plperl-12.0.1-150000.8.19.1
  • postgresql-contrib-12.0.1-150000.8.19.1
  • postgresql-server-12.0.1-150000.8.19.1
  • postgresql-pltcl-12.0.1-150000.8.19.1
  • postgresql-server-devel-12.0.1-150000.8.19.1
  • postgresql-12.0.1-150000.8.19.1
  • postgresql-docs-12.0.1-150000.8.19.1
  • postgresql-plpython-12.0.1-150000.8.19.1
  • postgresql-devel-12.0.1-150000.8.19.1

References:

• https://www.suse.com/security/cve/CVE-2021-23214.html
• https://www.suse.com/security/cve/CVE-2021-23222.html
• https://www.suse.com/security/cve/CVE-2022-1552.html
• https://www.suse.com/security/cve/CVE-2022-2625.html
• https://bugzilla.suse.com/show_bug.cgi?id=1179945
• https://bugzilla.suse.com/show_bug.cgi?id=1183168
• 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
• https://bugzilla.suse.com/show_bug.cgi?id=1190740
• https://bugzilla.suse.com/show_bug.cgi?id=1192516
• https://bugzilla.suse.com/show_bug.cgi?id=1195680
• https://bugzilla.suse.com/show_bug.cgi?id=1199475
• https://bugzilla.suse.com/show_bug.cgi?id=1202368