SUSE Recommended Update: Recommended update for postgresql12 ______________________________________________________________________________ Announcement ID: SUSE-RU-2022:1457-1 Rating: moderate References: #1190740 #1195680 Affected Products: SUSE Linux Enterprise High Performance Computing SUSE Linux Enterprise High Performance Computing 15-SP3 SUSE Linux Enterprise Module for Legacy Software 15-SP3 SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 SUSE Linux Enterprise Realtime Extension 15-SP2 SUSE Linux Enterprise Server SUSE Linux Enterprise Server 15-SP3 SUSE Linux Enterprise Server for SAP Applications SUSE Linux Enterprise Server for SAP Applications 15-SP3 SUSE Manager Proxy 4.2 SUSE Manager Server 4.2 openSUSE Leap 15.3 openSUSE Leap 15.4 ______________________________________________________________________________ An update that has two recommended fixes can now be installed. Description: This update for postgresql12 fixes the following issues: - Upgrade to 12.10: (bsc#1195680) * https://www.postgresql.org/docs/12/release-12-10.html * Reindexing might be needed after applying this upgrade, so please read the release notes carefully. - Add constraints file with 12GB of memory for s390x as a workaround. (bsc#1190740) - Add a llvmjit-devel subpackage to pull in the right versions of clang and llvm for building extensions. - Fix some mistakes in the interdependencies between the implementation packages and their noarch counterpart. - Update the BuildIgnore section. 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-1457=1 - openSUSE Leap 15.3: zypper in -t patch openSUSE-SLE-15.3-2022-1457=1 - SUSE Linux Enterprise Realtime Extension 15-SP2: zypper in -t patch SUSE-SLE-Product-RT-15-SP2-2022-1457=1 - SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3: zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP3-2022-1457=1 - SUSE Linux Enterprise Module for Legacy Software 15-SP3: zypper in -t patch SUSE-SLE-Module-Legacy-15-SP3-2022-1457=1 Package List: - openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64): postgresql12-12.10-8.29.1 postgresql12-contrib-12.10-8.29.1 postgresql12-contrib-debuginfo-12.10-8.29.1 postgresql12-debuginfo-12.10-8.29.1 postgresql12-debugsource-12.10-8.29.1 postgresql12-devel-12.10-8.29.1 postgresql12-devel-debuginfo-12.10-8.29.1 postgresql12-llvmjit-12.10-8.29.1 postgresql12-llvmjit-debuginfo-12.10-8.29.1 postgresql12-plperl-12.10-8.29.1 postgresql12-plperl-debuginfo-12.10-8.29.1 postgresql12-plpython-12.10-8.29.1 postgresql12-plpython-debuginfo-12.10-8.29.1 postgresql12-pltcl-12.10-8.29.1 postgresql12-pltcl-debuginfo-12.10-8.29.1 postgresql12-server-12.10-8.29.1 postgresql12-server-debuginfo-12.10-8.29.1 postgresql12-server-devel-12.10-8.29.1 postgresql12-server-devel-debuginfo-12.10-8.29.1 postgresql12-test-12.10-8.29.1 - openSUSE Leap 15.4 (noarch): postgresql12-docs-12.10-8.29.1 - openSUSE Leap 15.3 (aarch64 ppc64le s390x x86_64): postgresql12-12.10-8.29.1 postgresql12-contrib-12.10-8.29.1 postgresql12-contrib-debuginfo-12.10-8.29.1 postgresql12-debuginfo-12.10-8.29.1 postgresql12-debugsource-12.10-8.29.1 postgresql12-devel-12.10-8.29.1 postgresql12-devel-debuginfo-12.10-8.29.1 postgresql12-llvmjit-12.10-8.29.1 postgresql12-llvmjit-debuginfo-12.10-8.29.1 postgresql12-plperl-12.10-8.29.1 postgresql12-plperl-debuginfo-12.10-8.29.1 postgresql12-plpython-12.10-8.29.1 postgresql12-plpython-debuginfo-12.10-8.29.1 postgresql12-pltcl-12.10-8.29.1 postgresql12-pltcl-debuginfo-12.10-8.29.1 postgresql12-server-12.10-8.29.1 postgresql12-server-debuginfo-12.10-8.29.1 postgresql12-server-devel-12.10-8.29.1 postgresql12-server-devel-debuginfo-12.10-8.29.1 postgresql12-test-12.10-8.29.1 - openSUSE Leap 15.3 (noarch): postgresql12-docs-12.10-8.29.1 - SUSE Linux Enterprise Realtime Extension 15-SP2 (x86_64): postgresql12-12.10-8.29.1 postgresql12-contrib-12.10-8.29.1 postgresql12-contrib-debuginfo-12.10-8.29.1 postgresql12-debuginfo-12.10-8.29.1 postgresql12-debugsource-12.10-8.29.1 postgresql12-devel-12.10-8.29.1 postgresql12-devel-debuginfo-12.10-8.29.1 postgresql12-plperl-12.10-8.29.1 postgresql12-plperl-debuginfo-12.10-8.29.1 postgresql12-plpython-12.10-8.29.1 postgresql12-plpython-debuginfo-12.10-8.29.1 postgresql12-pltcl-12.10-8.29.1 postgresql12-pltcl-debuginfo-12.10-8.29.1 postgresql12-server-12.10-8.29.1 postgresql12-server-debuginfo-12.10-8.29.1 postgresql12-server-devel-12.10-8.29.1 postgresql12-server-devel-debuginfo-12.10-8.29.1 - SUSE Linux Enterprise Realtime Extension 15-SP2 (noarch): postgresql12-docs-12.10-8.29.1 - SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 (aarch64 ppc64le s390x x86_64): postgresql12-llvmjit-12.10-8.29.1 postgresql12-llvmjit-debuginfo-12.10-8.29.1 postgresql12-test-12.10-8.29.1 - SUSE Linux Enterprise Module for Legacy Software 15-SP3 (aarch64 ppc64le s390x x86_64): postgresql12-12.10-8.29.1 postgresql12-contrib-12.10-8.29.1 postgresql12-contrib-debuginfo-12.10-8.29.1 postgresql12-debuginfo-12.10-8.29.1 postgresql12-debugsource-12.10-8.29.1 postgresql12-devel-12.10-8.29.1 postgresql12-devel-debuginfo-12.10-8.29.1 postgresql12-plperl-12.10-8.29.1 postgresql12-plperl-debuginfo-12.10-8.29.1 postgresql12-plpython-12.10-8.29.1 postgresql12-plpython-debuginfo-12.10-8.29.1 postgresql12-pltcl-12.10-8.29.1 postgresql12-pltcl-debuginfo-12.10-8.29.1 postgresql12-server-12.10-8.29.1 postgresql12-server-debuginfo-12.10-8.29.1 postgresql12-server-devel-12.10-8.29.1 postgresql12-server-devel-debuginfo-12.10-8.29.1 - SUSE Linux Enterprise Module for Legacy Software 15-SP3 (noarch): postgresql12-docs-12.10-8.29.1 References: https://bugzilla.suse.com/1190740 https://bugzilla.suse.com/1195680