SUSE-RU-2022:2706-1: moderate: Recommended update for postgresql

[sle-updates at lists.suse.com]

   SUSE Recommended Update: Recommended update for postgresql
______________________________________________________________________________

Announcement ID:    SUSE-RU-2022:2706-1
Rating:             moderate
References:         #1195680 
Affected Products:
                    SUSE Linux Enterprise Desktop 15-SP4
                    SUSE Linux Enterprise High Performance Computing
                    SUSE Linux Enterprise High Performance Computing 15-SP4
                    SUSE Linux Enterprise Module for Basesystem 15-SP4
                    SUSE Linux Enterprise Module for Legacy Software 15-SP4
                    SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP4
                    SUSE Linux Enterprise Module for Server Applications 15-SP4
                    SUSE Linux Enterprise Server
                    SUSE Linux Enterprise Server 15-SP4
                    SUSE Linux Enterprise Server for SAP Applications
                    SUSE Linux Enterprise Server for SAP Applications 15-SP4
                    SUSE Manager Proxy 4.3
                    SUSE Manager Retail Branch Server 4.3
                    SUSE Manager Server 4.3
                    openSUSE Leap 15.4
______________________________________________________________________________

   An update that has one recommended fix can now be installed.

Description:

   This update for postgresql fixes the following issues:

   - Fix the pg_server_requires macro on older rpm versions (SLE-12)
   - Avoid a dependency on awk in postgresql-script.
   - Move the dependency of llvmjit-devel on clang and llvm to the
     implementation packages where we can depend on the correct versions.
   - Fix postgresql_has_llvm usage
   - First round of changes to make it easier to build extensions for
     - add postgresql-llvmjit-devel subpackage: This package will pull in
       clang and llvm if the distro has a recent enough version, otherwise it
       will just pull postgresql-server-devel.
     - add postgresql macros to the postgresql-server-devel package those
       cover all the variables from pg_config and some macros to remove
       repitition from the spec files
   - Bump version to 14. (bsc#1195680)


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-2706=1

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

      zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP4-2022-2706=1

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

      zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP4-2022-2706=1

   - SUSE Linux Enterprise Module for Legacy Software 15-SP4:

      zypper in -t patch SUSE-SLE-Module-Legacy-15-SP4-2022-2706=1

   - SUSE Linux Enterprise Module for Basesystem 15-SP4:

      zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP4-2022-2706=1



Package List:

   - openSUSE Leap 15.4 (noarch):

      postgresql-14-150400.4.3.88
      postgresql-contrib-14-150400.4.3.88
      postgresql-devel-14-150400.4.3.88
      postgresql-docs-14-150400.4.3.88
      postgresql-llvmjit-14-150400.4.3.88
      postgresql-plperl-14-150400.4.3.88
      postgresql-plpython-14-150400.4.3.88
      postgresql-pltcl-14-150400.4.3.88
      postgresql-server-14-150400.4.3.88
      postgresql-server-devel-14-150400.4.3.88
      postgresql-test-14-150400.4.3.88

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

      postgresql-contrib-14-150400.4.3.88
      postgresql-devel-14-150400.4.3.88
      postgresql-docs-14-150400.4.3.88
      postgresql-plperl-14-150400.4.3.88
      postgresql-plpython-14-150400.4.3.88
      postgresql-pltcl-14-150400.4.3.88
      postgresql-server-14-150400.4.3.88
      postgresql-server-devel-14-150400.4.3.88

   - SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP4 (noarch):

      postgresql-14-150400.4.3.88
      postgresql-contrib-14-150400.4.3.88
      postgresql-devel-14-150400.4.3.88
      postgresql-docs-14-150400.4.3.88
      postgresql-llvmjit-14-150400.4.3.88
      postgresql-llvmjit-devel-14-150400.4.3.88
      postgresql-plperl-14-150400.4.3.88
      postgresql-plpython-14-150400.4.3.88
      postgresql-pltcl-14-150400.4.3.88
      postgresql-server-14-150400.4.3.88
      postgresql-server-devel-14-150400.4.3.88
      postgresql-test-14-150400.4.3.88

   - SUSE Linux Enterprise Module for Legacy Software 15-SP4 (noarch):

      postgresql-llvmjit-14-150400.4.3.88

   - SUSE Linux Enterprise Module for Basesystem 15-SP4 (noarch):

      postgresql-14-150400.4.3.88


References:

   https://bugzilla.suse.com/1195680