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

[sle-updates at lists.suse.com]

   SUSE Recommended Update: Recommended update for postgresql
______________________________________________________________________________

Announcement ID:    SUSE-RU-2022:1458-1
Rating:             moderate
References:         #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 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
______________________________________________________________________________

   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.3:

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

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

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

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

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

   - SUSE Linux Enterprise Module for Basesystem 15-SP3:

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



Package List:

   - openSUSE Leap 15.3 (noarch):

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

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

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

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

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

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

      postgresql-14-150300.10.9.12


References:

   https://bugzilla.suse.com/1195680