SUSE-RU-2022:1463-1: moderate: Recommended update for postgresql13

[sle-updates at lists.suse.com]

   SUSE Recommended Update: Recommended update for postgresql13
______________________________________________________________________________

Announcement ID:    SUSE-RU-2022:1463-1
Rating:             moderate
References:         #1190740 #1195680 
Affected Products:
                    SUSE Linux Enterprise Desktop 15-SP3
                    SUSE Linux Enterprise High Performance Computing 15-SP3
                    SUSE Linux Enterprise Module for Basesystem 15-SP3
                    SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3
                    SUSE Linux Enterprise Module for Server Applications 15-SP3
                    SUSE Linux Enterprise Realtime Extension 15-SP2
                    SUSE Linux Enterprise Server 15-SP3
                    SUSE Linux Enterprise Server for SAP Applications 15-SP3
                    SUSE Manager Proxy 4.2
                    SUSE Manager Server 4.2
                    openSUSE Leap 15.3
                    openSUSE Leap 15.4
______________________________________________________________________________

   An update that has two recommended fixes can now be
   installed.

Description:

   This update for postgresql13 fixes the following issues:

   - Upgrade to 14.2: (bsc#1195680)
     * https://www.postgresql.org/docs/14/release-14-2.html
     * Reindexing might be needed after applying this upgrade, so please read
       the release notes carefully.
   - Add constraints file with 12GB of memory for s390x as a workaround.
     (bsc#1190740)
   - Add a llvmjit-devel subpackage to pull in the right versions
     of clang and llvm for building extensions.
   - Fix some mistakes in the interdependencies between the implementation
     packages and their noarch counterpart.
   - Update the BuildIgnore section.


Patch Instructions:

   To install this SUSE Recommended Update use the SUSE recommended installation methods
   like YaST online_update or "zypper patch".

   Alternatively you can run the command listed for your product:

   - openSUSE Leap 15.4:

      zypper in -t patch openSUSE-SLE-15.4-2022-1463=1

   - openSUSE Leap 15.3:

      zypper in -t patch openSUSE-SLE-15.3-2022-1463=1

   - SUSE Linux Enterprise Realtime Extension 15-SP2:

      zypper in -t patch SUSE-SLE-Product-RT-15-SP2-2022-1463=1

   - SUSE Linux Enterprise Module for Server Applications 15-SP3:

      zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP3-2022-1463=1

   - SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3:

      zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP3-2022-1463=1

   - SUSE Linux Enterprise Module for Basesystem 15-SP3:

      zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP3-2022-1463=1



Package List:

   - openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64):

      libecpg6-14.2-5.9.2
      libecpg6-debuginfo-14.2-5.9.2
      libpq5-14.2-5.9.2
      libpq5-debuginfo-14.2-5.9.2
      postgresql14-14.2-5.9.2
      postgresql14-contrib-14.2-5.9.2
      postgresql14-contrib-debuginfo-14.2-5.9.2
      postgresql14-debuginfo-14.2-5.9.2
      postgresql14-debugsource-14.2-5.9.1
      postgresql14-debugsource-14.2-5.9.2
      postgresql14-devel-14.2-5.9.2
      postgresql14-devel-debuginfo-14.2-5.9.2
      postgresql14-llvmjit-14.2-5.9.2
      postgresql14-llvmjit-debuginfo-14.2-5.9.2
      postgresql14-plperl-14.2-5.9.2
      postgresql14-plperl-debuginfo-14.2-5.9.2
      postgresql14-plpython-14.2-5.9.2
      postgresql14-plpython-debuginfo-14.2-5.9.2
      postgresql14-pltcl-14.2-5.9.2
      postgresql14-pltcl-debuginfo-14.2-5.9.2
      postgresql14-server-14.2-5.9.2
      postgresql14-server-debuginfo-14.2-5.9.2
      postgresql14-server-devel-14.2-5.9.2
      postgresql14-server-devel-debuginfo-14.2-5.9.2
      postgresql14-test-14.2-5.9.2

   - openSUSE Leap 15.4 (noarch):

      postgresql14-docs-14.2-5.9.2

   - openSUSE Leap 15.4 (x86_64):

      libecpg6-32bit-14.2-5.9.2
      libecpg6-32bit-debuginfo-14.2-5.9.2
      libpq5-32bit-14.2-5.9.2
      libpq5-32bit-debuginfo-14.2-5.9.2

   - openSUSE Leap 15.3 (aarch64 ppc64le s390x x86_64):

      libecpg6-14.2-5.9.2
      libecpg6-debuginfo-14.2-5.9.2
      libpq5-14.2-5.9.2
      libpq5-debuginfo-14.2-5.9.2
      postgresql14-14.2-5.9.2
      postgresql14-contrib-14.2-5.9.2
      postgresql14-contrib-debuginfo-14.2-5.9.2
      postgresql14-debuginfo-14.2-5.9.2
      postgresql14-debugsource-14.2-5.9.1
      postgresql14-debugsource-14.2-5.9.2
      postgresql14-devel-14.2-5.9.2
      postgresql14-devel-debuginfo-14.2-5.9.2
      postgresql14-devel-mini-14.2-5.9.1
      postgresql14-devel-mini-debuginfo-14.2-5.9.1
      postgresql14-llvmjit-14.2-5.9.2
      postgresql14-llvmjit-debuginfo-14.2-5.9.2
      postgresql14-plperl-14.2-5.9.2
      postgresql14-plperl-debuginfo-14.2-5.9.2
      postgresql14-plpython-14.2-5.9.2
      postgresql14-plpython-debuginfo-14.2-5.9.2
      postgresql14-pltcl-14.2-5.9.2
      postgresql14-pltcl-debuginfo-14.2-5.9.2
      postgresql14-server-14.2-5.9.2
      postgresql14-server-debuginfo-14.2-5.9.2
      postgresql14-server-devel-14.2-5.9.2
      postgresql14-server-devel-debuginfo-14.2-5.9.2
      postgresql14-test-14.2-5.9.2

   - openSUSE Leap 15.3 (noarch):

      postgresql14-docs-14.2-5.9.2

   - openSUSE Leap 15.3 (x86_64):

      libecpg6-32bit-14.2-5.9.2
      libecpg6-32bit-debuginfo-14.2-5.9.2
      libpq5-32bit-14.2-5.9.2
      libpq5-32bit-debuginfo-14.2-5.9.2

   - SUSE Linux Enterprise Realtime Extension 15-SP2 (x86_64):

      libecpg6-14.2-5.9.2
      libecpg6-debuginfo-14.2-5.9.2
      libpq5-14.2-5.9.2
      libpq5-32bit-14.2-5.9.2
      libpq5-32bit-debuginfo-14.2-5.9.2
      libpq5-debuginfo-14.2-5.9.2
      postgresql14-14.2-5.9.2
      postgresql14-contrib-14.2-5.9.2
      postgresql14-contrib-debuginfo-14.2-5.9.2
      postgresql14-debuginfo-14.2-5.9.2
      postgresql14-debugsource-14.2-5.9.1
      postgresql14-debugsource-14.2-5.9.2
      postgresql14-devel-14.2-5.9.2
      postgresql14-devel-debuginfo-14.2-5.9.2
      postgresql14-plperl-14.2-5.9.2
      postgresql14-plperl-debuginfo-14.2-5.9.2
      postgresql14-plpython-14.2-5.9.2
      postgresql14-plpython-debuginfo-14.2-5.9.2
      postgresql14-pltcl-14.2-5.9.2
      postgresql14-pltcl-debuginfo-14.2-5.9.2
      postgresql14-server-14.2-5.9.2
      postgresql14-server-debuginfo-14.2-5.9.2
      postgresql14-server-devel-14.2-5.9.2
      postgresql14-server-devel-debuginfo-14.2-5.9.2

   - SUSE Linux Enterprise Realtime Extension 15-SP2 (noarch):

      postgresql14-docs-14.2-5.9.2

   - SUSE Linux Enterprise Module for Server Applications 15-SP3 (aarch64 ppc64le s390x x86_64):

      libecpg6-14.2-5.9.2
      libecpg6-debuginfo-14.2-5.9.2
      postgresql14-contrib-14.2-5.9.2
      postgresql14-contrib-debuginfo-14.2-5.9.2
      postgresql14-debuginfo-14.2-5.9.2
      postgresql14-debugsource-14.2-5.9.1
      postgresql14-debugsource-14.2-5.9.2
      postgresql14-devel-14.2-5.9.2
      postgresql14-devel-debuginfo-14.2-5.9.2
      postgresql14-plperl-14.2-5.9.2
      postgresql14-plperl-debuginfo-14.2-5.9.2
      postgresql14-plpython-14.2-5.9.2
      postgresql14-plpython-debuginfo-14.2-5.9.2
      postgresql14-pltcl-14.2-5.9.2
      postgresql14-pltcl-debuginfo-14.2-5.9.2
      postgresql14-server-14.2-5.9.2
      postgresql14-server-debuginfo-14.2-5.9.2
      postgresql14-server-devel-14.2-5.9.2
      postgresql14-server-devel-debuginfo-14.2-5.9.2

   - SUSE Linux Enterprise Module for Server Applications 15-SP3 (noarch):

      postgresql14-docs-14.2-5.9.2

   - SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 (aarch64 ppc64le s390x x86_64):

      postgresql14-llvmjit-14.2-5.9.2
      postgresql14-llvmjit-debuginfo-14.2-5.9.2

   - SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 (x86_64):

      postgresql14-test-14.2-5.9.2

   - SUSE Linux Enterprise Module for Basesystem 15-SP3 (aarch64 ppc64le s390x x86_64):

      libpq5-14.2-5.9.2
      libpq5-debuginfo-14.2-5.9.2
      postgresql14-14.2-5.9.2
      postgresql14-debuginfo-14.2-5.9.2
      postgresql14-debugsource-14.2-5.9.1
      postgresql14-debugsource-14.2-5.9.2


References:

   https://bugzilla.suse.com/1190740
   https://bugzilla.suse.com/1195680