SUSE-SU-2022:2958-1: important: Security update for postgresql12

sle-updates at lists.suse.com sle-updates at lists.suse.com
Wed Aug 31 16:17:51 UTC 2022 

   SUSE Security Update: Security update for postgresql12
______________________________________________________________________________

Announcement ID:    SUSE-SU-2022:2958-1
Rating:             important
References:         #1179945 #1183168 #1185924 #1185925 #1185926 
                    #1185952 #1187751 #1189748 #1190740 #1192516 
                    #1195680 #1198166 #1199475 #1202368 
Cross-References:   CVE-2021-23214 CVE-2021-23222 CVE-2021-32027
                    CVE-2021-32028 CVE-2021-32029 CVE-2021-3677
                    CVE-2022-1552 CVE-2022-2625
CVSS scores:
                    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-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-23222 (NVD) : 5.9 CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:N/A:N
                    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-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-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-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-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-32029 (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-3677 (NVD) : 6.5 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
                    CVE-2021-3677 (SUSE): 6.5 CVSS:3.1/AV:N/AC:L/PR:L/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-2625 (NVD) : 8 CVSS:3.1/AV:N/AC:L/PR:L/UI:R/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

Affected Products:
                    SUSE CaaS Platform 4.0
                    SUSE Enterprise Storage 6
                    SUSE Linux Enterprise High Performance Computing 15-SP1-ESPOS
                    SUSE Linux Enterprise High Performance Computing 15-SP1-LTSS
                    SUSE Linux Enterprise Server 15-SP1-BCL
                    SUSE Linux Enterprise Server 15-SP1-LTSS
                    SUSE Linux Enterprise Server for SAP 15-SP1
______________________________________________________________________________

   An update that solves 8 vulnerabilities and has 6 fixes is
   now available.

Description:

   This update for postgresql12 fixes the following issues:

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

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

   - Upgrade to 12.10 (bsc#1195680)
   - Add constraints file with 12GB of memory for s390x as a workaround
     (boo#1190740)

   - Upgrade to version 12.9 (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

   - Upgrade to version 12.8:
   - CVE-2021-3677: Fixed memory disclosure in certain queries (bsc#1189748).

   - 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 "pg_psql_temporary_savepoint" does not exist (bsc#1185926).

   - Fixed build with llvm12 on s390x (bsc#1185952).
   - Re-enabled icu for PostgreSQL 10 (bsc#1179945).
   - Made the dependency of postgresqlXX-server-devel on llvm and clang
     optional (bsc#1187751).
   - llvm12 breaks PostgreSQL 11 and 12 on s390x. Use llvm11 as a workaround
     (bsc#1185952).
   - 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).


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-SP1:

      zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP1-2022-2958=1

   - SUSE Linux Enterprise Server 15-SP1-LTSS:

      zypper in -t patch SUSE-SLE-Product-SLES-15-SP1-LTSS-2022-2958=1

   - SUSE Linux Enterprise Server 15-SP1-BCL:

      zypper in -t patch SUSE-SLE-Product-SLES-15-SP1-BCL-2022-2958=1

   - SUSE Linux Enterprise High Performance Computing 15-SP1-LTSS:

      zypper in -t patch SUSE-SLE-Product-HPC-15-SP1-LTSS-2022-2958=1

   - SUSE Linux Enterprise High Performance Computing 15-SP1-ESPOS:

      zypper in -t patch SUSE-SLE-Product-HPC-15-SP1-ESPOS-2022-2958=1

   - SUSE Enterprise Storage 6:

      zypper in -t patch SUSE-Storage-6-2022-2958=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 for SAP 15-SP1 (ppc64le x86_64):

      libecpg6-12.12-150100.3.33.1
      libecpg6-debuginfo-12.12-150100.3.33.1
      libpq5-12.12-150100.3.33.1
      libpq5-debuginfo-12.12-150100.3.33.1
      postgresql12-12.12-150100.3.33.1
      postgresql12-contrib-12.12-150100.3.33.1
      postgresql12-contrib-debuginfo-12.12-150100.3.33.1
      postgresql12-debuginfo-12.12-150100.3.33.1
      postgresql12-debugsource-12.12-150100.3.33.1
      postgresql12-devel-12.12-150100.3.33.1
      postgresql12-devel-debuginfo-12.12-150100.3.33.1
      postgresql12-plperl-12.12-150100.3.33.1
      postgresql12-plperl-debuginfo-12.12-150100.3.33.1
      postgresql12-plpython-12.12-150100.3.33.1
      postgresql12-plpython-debuginfo-12.12-150100.3.33.1
      postgresql12-pltcl-12.12-150100.3.33.1
      postgresql12-pltcl-debuginfo-12.12-150100.3.33.1
      postgresql12-server-12.12-150100.3.33.1
      postgresql12-server-debuginfo-12.12-150100.3.33.1
      postgresql12-server-devel-12.12-150100.3.33.1
      postgresql12-server-devel-debuginfo-12.12-150100.3.33.1

   - SUSE Linux Enterprise Server for SAP 15-SP1 (x86_64):

      libpq5-32bit-12.12-150100.3.33.1
      libpq5-32bit-debuginfo-12.12-150100.3.33.1

   - SUSE Linux Enterprise Server for SAP 15-SP1 (noarch):

      postgresql12-docs-12.12-150100.3.33.1

   - SUSE Linux Enterprise Server 15-SP1-LTSS (aarch64 ppc64le s390x x86_64):

      libecpg6-12.12-150100.3.33.1
      libecpg6-debuginfo-12.12-150100.3.33.1
      libpq5-12.12-150100.3.33.1
      libpq5-debuginfo-12.12-150100.3.33.1
      postgresql12-12.12-150100.3.33.1
      postgresql12-contrib-12.12-150100.3.33.1
      postgresql12-contrib-debuginfo-12.12-150100.3.33.1
      postgresql12-debuginfo-12.12-150100.3.33.1
      postgresql12-debugsource-12.12-150100.3.33.1
      postgresql12-devel-12.12-150100.3.33.1
      postgresql12-devel-debuginfo-12.12-150100.3.33.1
      postgresql12-plperl-12.12-150100.3.33.1
      postgresql12-plperl-debuginfo-12.12-150100.3.33.1
      postgresql12-plpython-12.12-150100.3.33.1
      postgresql12-plpython-debuginfo-12.12-150100.3.33.1
      postgresql12-pltcl-12.12-150100.3.33.1
      postgresql12-pltcl-debuginfo-12.12-150100.3.33.1
      postgresql12-server-12.12-150100.3.33.1
      postgresql12-server-debuginfo-12.12-150100.3.33.1
      postgresql12-server-devel-12.12-150100.3.33.1
      postgresql12-server-devel-debuginfo-12.12-150100.3.33.1

   - SUSE Linux Enterprise Server 15-SP1-LTSS (noarch):

      postgresql12-docs-12.12-150100.3.33.1

   - SUSE Linux Enterprise Server 15-SP1-LTSS (x86_64):

      libpq5-32bit-12.12-150100.3.33.1
      libpq5-32bit-debuginfo-12.12-150100.3.33.1

   - SUSE Linux Enterprise Server 15-SP1-BCL (x86_64):

      libecpg6-12.12-150100.3.33.1
      libecpg6-debuginfo-12.12-150100.3.33.1
      libpq5-12.12-150100.3.33.1
      libpq5-32bit-12.12-150100.3.33.1
      libpq5-32bit-debuginfo-12.12-150100.3.33.1
      libpq5-debuginfo-12.12-150100.3.33.1
      postgresql12-12.12-150100.3.33.1
      postgresql12-contrib-12.12-150100.3.33.1
      postgresql12-contrib-debuginfo-12.12-150100.3.33.1
      postgresql12-debuginfo-12.12-150100.3.33.1
      postgresql12-debugsource-12.12-150100.3.33.1
      postgresql12-devel-12.12-150100.3.33.1
      postgresql12-devel-debuginfo-12.12-150100.3.33.1
      postgresql12-plperl-12.12-150100.3.33.1
      postgresql12-plperl-debuginfo-12.12-150100.3.33.1
      postgresql12-plpython-12.12-150100.3.33.1
      postgresql12-plpython-debuginfo-12.12-150100.3.33.1
      postgresql12-pltcl-12.12-150100.3.33.1
      postgresql12-pltcl-debuginfo-12.12-150100.3.33.1
      postgresql12-server-12.12-150100.3.33.1
      postgresql12-server-debuginfo-12.12-150100.3.33.1
      postgresql12-server-devel-12.12-150100.3.33.1
      postgresql12-server-devel-debuginfo-12.12-150100.3.33.1

   - SUSE Linux Enterprise Server 15-SP1-BCL (noarch):

      postgresql12-docs-12.12-150100.3.33.1

   - SUSE Linux Enterprise High Performance Computing 15-SP1-LTSS (aarch64 x86_64):

      libecpg6-12.12-150100.3.33.1
      libecpg6-debuginfo-12.12-150100.3.33.1
      libpq5-12.12-150100.3.33.1
      libpq5-debuginfo-12.12-150100.3.33.1
      postgresql12-12.12-150100.3.33.1
      postgresql12-contrib-12.12-150100.3.33.1
      postgresql12-contrib-debuginfo-12.12-150100.3.33.1
      postgresql12-debuginfo-12.12-150100.3.33.1
      postgresql12-debugsource-12.12-150100.3.33.1
      postgresql12-devel-12.12-150100.3.33.1
      postgresql12-devel-debuginfo-12.12-150100.3.33.1
      postgresql12-plperl-12.12-150100.3.33.1
      postgresql12-plperl-debuginfo-12.12-150100.3.33.1
      postgresql12-plpython-12.12-150100.3.33.1
      postgresql12-plpython-debuginfo-12.12-150100.3.33.1
      postgresql12-pltcl-12.12-150100.3.33.1
      postgresql12-pltcl-debuginfo-12.12-150100.3.33.1
      postgresql12-server-12.12-150100.3.33.1
      postgresql12-server-debuginfo-12.12-150100.3.33.1
      postgresql12-server-devel-12.12-150100.3.33.1
      postgresql12-server-devel-debuginfo-12.12-150100.3.33.1

   - SUSE Linux Enterprise High Performance Computing 15-SP1-LTSS (noarch):

      postgresql12-docs-12.12-150100.3.33.1

   - SUSE Linux Enterprise High Performance Computing 15-SP1-LTSS (x86_64):

      libpq5-32bit-12.12-150100.3.33.1
      libpq5-32bit-debuginfo-12.12-150100.3.33.1

   - SUSE Linux Enterprise High Performance Computing 15-SP1-ESPOS (aarch64 x86_64):

      libecpg6-12.12-150100.3.33.1
      libecpg6-debuginfo-12.12-150100.3.33.1
      libpq5-12.12-150100.3.33.1
      libpq5-debuginfo-12.12-150100.3.33.1
      postgresql12-12.12-150100.3.33.1
      postgresql12-contrib-12.12-150100.3.33.1
      postgresql12-contrib-debuginfo-12.12-150100.3.33.1
      postgresql12-debuginfo-12.12-150100.3.33.1
      postgresql12-debugsource-12.12-150100.3.33.1
      postgresql12-devel-12.12-150100.3.33.1
      postgresql12-devel-debuginfo-12.12-150100.3.33.1
      postgresql12-plperl-12.12-150100.3.33.1
      postgresql12-plperl-debuginfo-12.12-150100.3.33.1
      postgresql12-plpython-12.12-150100.3.33.1
      postgresql12-plpython-debuginfo-12.12-150100.3.33.1
      postgresql12-pltcl-12.12-150100.3.33.1
      postgresql12-pltcl-debuginfo-12.12-150100.3.33.1
      postgresql12-server-12.12-150100.3.33.1
      postgresql12-server-debuginfo-12.12-150100.3.33.1
      postgresql12-server-devel-12.12-150100.3.33.1
      postgresql12-server-devel-debuginfo-12.12-150100.3.33.1

   - SUSE Linux Enterprise High Performance Computing 15-SP1-ESPOS (x86_64):

      libpq5-32bit-12.12-150100.3.33.1
      libpq5-32bit-debuginfo-12.12-150100.3.33.1

   - SUSE Linux Enterprise High Performance Computing 15-SP1-ESPOS (noarch):

      postgresql12-docs-12.12-150100.3.33.1

   - SUSE Enterprise Storage 6 (aarch64 x86_64):

      libecpg6-12.12-150100.3.33.1
      libecpg6-debuginfo-12.12-150100.3.33.1
      libpq5-12.12-150100.3.33.1
      libpq5-debuginfo-12.12-150100.3.33.1
      postgresql12-12.12-150100.3.33.1
      postgresql12-contrib-12.12-150100.3.33.1
      postgresql12-contrib-debuginfo-12.12-150100.3.33.1
      postgresql12-debuginfo-12.12-150100.3.33.1
      postgresql12-debugsource-12.12-150100.3.33.1
      postgresql12-devel-12.12-150100.3.33.1
      postgresql12-devel-debuginfo-12.12-150100.3.33.1
      postgresql12-plperl-12.12-150100.3.33.1
      postgresql12-plperl-debuginfo-12.12-150100.3.33.1
      postgresql12-plpython-12.12-150100.3.33.1
      postgresql12-plpython-debuginfo-12.12-150100.3.33.1
      postgresql12-pltcl-12.12-150100.3.33.1
      postgresql12-pltcl-debuginfo-12.12-150100.3.33.1
      postgresql12-server-12.12-150100.3.33.1
      postgresql12-server-debuginfo-12.12-150100.3.33.1
      postgresql12-server-devel-12.12-150100.3.33.1
      postgresql12-server-devel-debuginfo-12.12-150100.3.33.1

   - SUSE Enterprise Storage 6 (noarch):

      postgresql12-docs-12.12-150100.3.33.1

   - SUSE Enterprise Storage 6 (x86_64):

      libpq5-32bit-12.12-150100.3.33.1
      libpq5-32bit-debuginfo-12.12-150100.3.33.1

   - SUSE CaaS Platform 4.0 (x86_64):

      libecpg6-12.12-150100.3.33.1
      libecpg6-debuginfo-12.12-150100.3.33.1
      libpq5-12.12-150100.3.33.1
      libpq5-32bit-12.12-150100.3.33.1
      libpq5-32bit-debuginfo-12.12-150100.3.33.1
      libpq5-debuginfo-12.12-150100.3.33.1
      postgresql12-12.12-150100.3.33.1
      postgresql12-contrib-12.12-150100.3.33.1
      postgresql12-contrib-debuginfo-12.12-150100.3.33.1
      postgresql12-debuginfo-12.12-150100.3.33.1
      postgresql12-debugsource-12.12-150100.3.33.1
      postgresql12-devel-12.12-150100.3.33.1
      postgresql12-devel-debuginfo-12.12-150100.3.33.1
      postgresql12-plperl-12.12-150100.3.33.1
      postgresql12-plperl-debuginfo-12.12-150100.3.33.1
      postgresql12-plpython-12.12-150100.3.33.1
      postgresql12-plpython-debuginfo-12.12-150100.3.33.1
      postgresql12-pltcl-12.12-150100.3.33.1
      postgresql12-pltcl-debuginfo-12.12-150100.3.33.1
      postgresql12-server-12.12-150100.3.33.1
      postgresql12-server-debuginfo-12.12-150100.3.33.1
      postgresql12-server-devel-12.12-150100.3.33.1
      postgresql12-server-devel-debuginfo-12.12-150100.3.33.1

   - SUSE CaaS Platform 4.0 (noarch):

      postgresql12-docs-12.12-150100.3.33.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-2021-32027.html
   https://www.suse.com/security/cve/CVE-2021-32028.html
   https://www.suse.com/security/cve/CVE-2021-32029.html
   https://www.suse.com/security/cve/CVE-2021-3677.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/1179945
   https://bugzilla.suse.com/1183168
   https://bugzilla.suse.com/1185924
   https://bugzilla.suse.com/1185925
   https://bugzilla.suse.com/1185926
   https://bugzilla.suse.com/1185952
   https://bugzilla.suse.com/1187751
   https://bugzilla.suse.com/1189748
   https://bugzilla.suse.com/1190740
   https://bugzilla.suse.com/1192516
   https://bugzilla.suse.com/1195680
   https://bugzilla.suse.com/1198166
   https://bugzilla.suse.com/1199475
   https://bugzilla.suse.com/1202368

More information about the sle-updates mailing list