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