Recommended update for postgresql12

Announcement ID: SUSE-RU-2022:1457-1
Rating: moderate
References:
Affected Products:
  • Legacy Module 15-SP3
  • openSUSE Leap 15.4
  • 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 SP2
  • SUSE Linux Enterprise Server 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 two 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 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
  • Legacy Module 15-SP3
    zypper in -t patch SUSE-SLE-Module-Legacy-15-SP3-2022-1457=1
  • SUSE Package Hub 15 15-SP3
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP3-2022-1457=1
  • SUSE Linux Enterprise Real Time 15 SP2
    zypper in -t patch SUSE-SLE-Product-RT-15-SP2-2022-1457=1

Package List:

  • openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64)
    • postgresql12-llvmjit-debuginfo-12.10-8.29.1
    • postgresql12-debuginfo-12.10-8.29.1
    • postgresql12-plperl-12.10-8.29.1
    • postgresql12-plpython-12.10-8.29.1
    • postgresql12-devel-debuginfo-12.10-8.29.1
    • postgresql12-devel-12.10-8.29.1
    • postgresql12-contrib-12.10-8.29.1
    • postgresql12-server-devel-debuginfo-12.10-8.29.1
    • postgresql12-plperl-debuginfo-12.10-8.29.1
    • postgresql12-debugsource-12.10-8.29.1
    • postgresql12-contrib-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-test-12.10-8.29.1
    • postgresql12-llvmjit-12.10-8.29.1
    • postgresql12-pltcl-12.10-8.29.1
    • postgresql12-12.10-8.29.1
    • postgresql12-plpython-debuginfo-12.10-8.29.1
    • postgresql12-pltcl-debuginfo-12.10-8.29.1
  • openSUSE Leap 15.4 (noarch)
    • postgresql12-docs-12.10-8.29.1
  • Legacy Module 15-SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql12-plperl-12.10-8.29.1
    • postgresql12-debuginfo-12.10-8.29.1
    • postgresql12-plpython-12.10-8.29.1
    • postgresql12-devel-debuginfo-12.10-8.29.1
    • postgresql12-devel-12.10-8.29.1
    • postgresql12-contrib-12.10-8.29.1
    • postgresql12-server-devel-debuginfo-12.10-8.29.1
    • postgresql12-plperl-debuginfo-12.10-8.29.1
    • postgresql12-debugsource-12.10-8.29.1
    • postgresql12-contrib-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-pltcl-12.10-8.29.1
    • postgresql12-12.10-8.29.1
    • postgresql12-plpython-debuginfo-12.10-8.29.1
    • postgresql12-pltcl-debuginfo-12.10-8.29.1
  • Legacy Module 15-SP3 (noarch)
    • postgresql12-docs-12.10-8.29.1
  • SUSE Package Hub 15 15-SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql12-llvmjit-debuginfo-12.10-8.29.1
    • postgresql12-llvmjit-12.10-8.29.1
    • postgresql12-test-12.10-8.29.1
  • SUSE Linux Enterprise Real Time 15 SP2 (x86_64)
    • postgresql12-plperl-12.10-8.29.1
    • postgresql12-debuginfo-12.10-8.29.1
    • postgresql12-plpython-12.10-8.29.1
    • postgresql12-devel-debuginfo-12.10-8.29.1
    • postgresql12-devel-12.10-8.29.1
    • postgresql12-contrib-12.10-8.29.1
    • postgresql12-server-devel-debuginfo-12.10-8.29.1
    • postgresql12-plperl-debuginfo-12.10-8.29.1
    • postgresql12-debugsource-12.10-8.29.1
    • postgresql12-contrib-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-pltcl-12.10-8.29.1
    • postgresql12-12.10-8.29.1
    • postgresql12-plpython-debuginfo-12.10-8.29.1
    • postgresql12-pltcl-debuginfo-12.10-8.29.1
  • SUSE Linux Enterprise Real Time 15 SP2 (noarch)
    • postgresql12-docs-12.10-8.29.1

References: