Recommended update for postgresql

Announcement ID: SUSE-RU-2022:1458-1
Rating: moderate
References:
Affected Products:
  • Basesystem Module 15-SP3
  • openSUSE Leap 15.3
  • Server Applications Module 15-SP3
  • SUSE Linux Enterprise Desktop 15 SP3
  • SUSE Linux Enterprise High Performance Computing 15 SP3
  • SUSE Linux Enterprise Micro 5.1
  • SUSE Linux Enterprise Micro 5.2
  • SUSE Linux Enterprise Real Time 15 SP3
  • SUSE Linux Enterprise Server 15 SP3
  • SUSE Linux Enterprise Server 15 SP3 Business Critical Linux 15-SP3
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3
  • SUSE Manager Proxy 4.2
  • SUSE Manager Retail Branch Server 4.2
  • SUSE Manager Server 4.2
  • SUSE Package Hub 15 15-SP3

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.3
    zypper in -t patch SUSE-2022-1458=1
  • Basesystem Module 15-SP3
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP3-2022-1458=1
  • SUSE Package Hub 15 15-SP3
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP3-2022-1458=1
  • Server Applications Module 15-SP3
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP3-2022-1458=1

Package List:

  • openSUSE Leap 15.3 (noarch)
    • postgresql-test-14-150300.10.9.12
    • postgresql-docs-14-150300.10.9.12
    • postgresql-llvmjit-devel-14-150300.10.9.12
    • postgresql-llvmjit-14-150300.10.9.12
    • postgresql-devel-14-150300.10.9.12
    • postgresql-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-plperl-14-150300.10.9.12
    • postgresql-contrib-14-150300.10.9.12
  • Basesystem Module 15-SP3 (noarch)
    • postgresql-14-150300.10.9.12
  • SUSE Package Hub 15 15-SP3 (noarch)
    • postgresql-test-14-150300.10.9.12
    • postgresql-docs-14-150300.10.9.12
    • postgresql-llvmjit-14-150300.10.9.12
    • postgresql-devel-14-150300.10.9.12
    • postgresql-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-plperl-14-150300.10.9.12
    • postgresql-contrib-14-150300.10.9.12
  • Server Applications Module 15-SP3 (noarch)
    • postgresql-docs-14-150300.10.9.12
    • postgresql-devel-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-plperl-14-150300.10.9.12
    • postgresql-contrib-14-150300.10.9.12

References: