Recommended update for postgresql10

Announcement ID: SUSE-RU-2022:0889-1
Rating: moderate
References:
Affected Products:
  • Legacy Module 15-SP3
  • SUSE Linux Enterprise High Performance Computing 15 SP3
  • 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

An update that has two fixes can now be installed.

Description:

This update for postgresql10 fixes the following issues:

Upgrade to version 10.20 (bsc#1195680):

  • Reindexing might be needed after applying this upgrade, so please read the release notes carefully https://www.postgresql.org/docs/10/release-10-20.html
  • 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

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:

  • Legacy Module 15-SP3
    zypper in -t patch SUSE-SLE-Module-Legacy-15-SP3-2022-889=1
  • SUSE Linux Enterprise Real Time 15 SP2
    zypper in -t patch SUSE-SLE-Product-RT-15-SP2-2022-889=1

Package List:

  • Legacy Module 15-SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql10-plpython-debuginfo-10.20-8.44.1
    • postgresql10-server-10.20-8.44.1
    • postgresql10-10.20-8.44.1
    • postgresql10-plpython-10.20-8.44.1
    • postgresql10-devel-10.20-8.44.1
    • postgresql10-contrib-10.20-8.44.1
    • postgresql10-contrib-debuginfo-10.20-8.44.1
    • postgresql10-debugsource-10.20-8.44.1
    • postgresql10-plperl-10.20-8.44.1
    • postgresql10-pltcl-10.20-8.44.1
    • postgresql10-devel-debuginfo-10.20-8.44.1
    • postgresql10-pltcl-debuginfo-10.20-8.44.1
    • postgresql10-server-debuginfo-10.20-8.44.1
    • postgresql10-debuginfo-10.20-8.44.1
    • postgresql10-plperl-debuginfo-10.20-8.44.1
  • SUSE Linux Enterprise Real Time 15 SP2 (x86_64)
    • postgresql10-plpython-debuginfo-10.20-8.44.1
    • postgresql10-server-10.20-8.44.1
    • postgresql10-10.20-8.44.1
    • postgresql10-plpython-10.20-8.44.1
    • postgresql10-devel-10.20-8.44.1
    • postgresql10-contrib-10.20-8.44.1
    • postgresql10-contrib-debuginfo-10.20-8.44.1
    • postgresql10-debugsource-10.20-8.44.1
    • postgresql10-plperl-10.20-8.44.1
    • postgresql10-pltcl-10.20-8.44.1
    • postgresql10-devel-debuginfo-10.20-8.44.1
    • postgresql10-pltcl-debuginfo-10.20-8.44.1
    • postgresql10-server-debuginfo-10.20-8.44.1
    • postgresql10-debuginfo-10.20-8.44.1
    • postgresql10-plperl-debuginfo-10.20-8.44.1
  • SUSE Linux Enterprise Real Time 15 SP2 (noarch)
    • postgresql10-docs-10.20-8.44.1

References: