Recommended update for postgresql

Announcement ID: SUSE-RU-2022:2706-1
Rating: moderate
References:
Affected Products:
  • Basesystem Module 15-SP4
  • Legacy Module 15-SP4
  • openSUSE Leap 15.4
  • Server Applications Module 15-SP4
  • SUSE Linux Enterprise Desktop 15 SP4
  • SUSE Linux Enterprise High Performance Computing 15 SP4
  • SUSE Linux Enterprise Micro 5.3
  • SUSE Linux Enterprise Micro 5.4
  • SUSE Linux Enterprise Real Time 15 SP4
  • SUSE Linux Enterprise Server 15 SP4
  • 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
  • SUSE Package Hub 15 15-SP4

An update that has one 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 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
  • Basesystem Module 15-SP4
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP4-2022-2706=1
  • Legacy Module 15-SP4
    zypper in -t patch SUSE-SLE-Module-Legacy-15-SP4-2022-2706=1
  • SUSE Package Hub 15 15-SP4
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP4-2022-2706=1
  • Server Applications Module 15-SP4
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP4-2022-2706=1

Package List:

  • openSUSE Leap 15.4 (noarch)
    • postgresql-devel-14-150400.4.3.88
    • postgresql-contrib-14-150400.4.3.88
    • postgresql-pltcl-14-150400.4.3.88
    • postgresql-14-150400.4.3.88
    • postgresql-docs-14-150400.4.3.88
    • postgresql-plperl-14-150400.4.3.88
    • postgresql-llvmjit-14-150400.4.3.88
    • postgresql-plpython-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
  • Basesystem Module 15-SP4 (noarch)
    • postgresql-14-150400.4.3.88
  • Legacy Module 15-SP4 (noarch)
    • postgresql-llvmjit-14-150400.4.3.88
  • SUSE Package Hub 15 15-SP4 (noarch)
    • postgresql-devel-14-150400.4.3.88
    • postgresql-contrib-14-150400.4.3.88
    • postgresql-pltcl-14-150400.4.3.88
    • postgresql-14-150400.4.3.88
    • postgresql-docs-14-150400.4.3.88
    • postgresql-llvmjit-devel-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-server-14-150400.4.3.88
    • postgresql-server-devel-14-150400.4.3.88
    • postgresql-test-14-150400.4.3.88
  • Server Applications Module 15-SP4 (noarch)
    • postgresql-devel-14-150400.4.3.88
    • postgresql-contrib-14-150400.4.3.88
    • postgresql-pltcl-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-server-14-150400.4.3.88
    • postgresql-server-devel-14-150400.4.3.88

References: