Recommended update for postgresql13

Announcement ID: SUSE-RU-2022:1463-1
Rating: moderate
References:
Affected Products:
  • Basesystem Module 15-SP3
  • openSUSE Leap 15.4
  • 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 SP2
  • 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 two fixes can now be installed.

Description:

This update for postgresql13 fixes the following issues:

  • Upgrade to 14.2: (bsc#1195680)
  • https://www.postgresql.org/docs/14/release-14-2.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-1463=1
  • Basesystem Module 15-SP3
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP3-2022-1463=1
  • SUSE Package Hub 15 15-SP3
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP3-2022-1463=1
  • Server Applications Module 15-SP3
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP3-2022-1463=1
  • SUSE Linux Enterprise Real Time 15 SP2
    zypper in -t patch SUSE-SLE-Product-RT-15-SP2-2022-1463=1

Package List:

  • openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64)
    • libpq5-debuginfo-14.2-5.9.2
    • postgresql14-debugsource-14.2-5.9.2
    • postgresql14-plpython-14.2-5.9.2
    • postgresql14-llvmjit-14.2-5.9.2
    • postgresql14-devel-14.2-5.9.2
    • postgresql14-plperl-14.2-5.9.2
    • postgresql14-debuginfo-14.2-5.9.2
    • libpq5-14.2-5.9.2
    • libecpg6-14.2-5.9.2
    • postgresql14-server-devel-debuginfo-14.2-5.9.2
    • libecpg6-debuginfo-14.2-5.9.2
    • postgresql14-plpython-debuginfo-14.2-5.9.2
    • postgresql14-server-devel-14.2-5.9.2
    • postgresql14-plperl-debuginfo-14.2-5.9.2
    • postgresql14-contrib-debuginfo-14.2-5.9.2
    • postgresql14-pltcl-debuginfo-14.2-5.9.2
    • postgresql14-14.2-5.9.2
    • postgresql14-pltcl-14.2-5.9.2
    • postgresql14-server-14.2-5.9.2
    • postgresql14-server-debuginfo-14.2-5.9.2
    • postgresql14-test-14.2-5.9.2
    • postgresql14-devel-debuginfo-14.2-5.9.2
    • postgresql14-contrib-14.2-5.9.2
    • postgresql14-llvmjit-debuginfo-14.2-5.9.2
  • openSUSE Leap 15.4 (x86_64)
    • libpq5-32bit-debuginfo-14.2-5.9.2
    • libecpg6-32bit-debuginfo-14.2-5.9.2
    • libpq5-32bit-14.2-5.9.2
    • libecpg6-32bit-14.2-5.9.2
  • openSUSE Leap 15.4 (noarch)
    • postgresql14-docs-14.2-5.9.2
  • Basesystem Module 15-SP3 (aarch64 ppc64le s390x x86_64)
    • libpq5-debuginfo-14.2-5.9.2
    • libpq5-14.2-5.9.2
    • postgresql14-debugsource-14.2-5.9.2
    • postgresql14-14.2-5.9.2
    • postgresql14-debuginfo-14.2-5.9.2
  • SUSE Package Hub 15 15-SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql14-llvmjit-14.2-5.9.2
    • postgresql14-llvmjit-debuginfo-14.2-5.9.2
  • SUSE Package Hub 15 15-SP3 (x86_64)
    • postgresql14-test-14.2-5.9.2
  • Server Applications Module 15-SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql14-server-devel-14.2-5.9.2
    • libecpg6-14.2-5.9.2
    • postgresql14-server-14.2-5.9.2
    • postgresql14-debugsource-14.2-5.9.2
    • postgresql14-plperl-14.2-5.9.2
    • libecpg6-debuginfo-14.2-5.9.2
    • postgresql14-plperl-debuginfo-14.2-5.9.2
    • postgresql14-contrib-debuginfo-14.2-5.9.2
    • postgresql14-plpython-14.2-5.9.2
    • postgresql14-plpython-debuginfo-14.2-5.9.2
    • postgresql14-pltcl-debuginfo-14.2-5.9.2
    • postgresql14-server-debuginfo-14.2-5.9.2
    • postgresql14-devel-14.2-5.9.2
    • postgresql14-server-devel-debuginfo-14.2-5.9.2
    • postgresql14-pltcl-14.2-5.9.2
    • postgresql14-devel-debuginfo-14.2-5.9.2
    • postgresql14-contrib-14.2-5.9.2
    • postgresql14-debuginfo-14.2-5.9.2
  • Server Applications Module 15-SP3 (noarch)
    • postgresql14-docs-14.2-5.9.2
  • SUSE Linux Enterprise Real Time 15 SP2 (x86_64)
    • libpq5-debuginfo-14.2-5.9.2
    • libpq5-32bit-14.2-5.9.2
    • postgresql14-debugsource-14.2-5.9.2
    • postgresql14-plpython-14.2-5.9.2
    • libpq5-32bit-debuginfo-14.2-5.9.2
    • postgresql14-devel-14.2-5.9.2
    • postgresql14-plperl-14.2-5.9.2
    • postgresql14-debuginfo-14.2-5.9.2
    • libpq5-14.2-5.9.2
    • libecpg6-14.2-5.9.2
    • postgresql14-server-devel-debuginfo-14.2-5.9.2
    • libecpg6-debuginfo-14.2-5.9.2
    • postgresql14-plpython-debuginfo-14.2-5.9.2
    • postgresql14-server-devel-14.2-5.9.2
    • postgresql14-plperl-debuginfo-14.2-5.9.2
    • postgresql14-contrib-debuginfo-14.2-5.9.2
    • postgresql14-pltcl-debuginfo-14.2-5.9.2
    • postgresql14-14.2-5.9.2
    • postgresql14-pltcl-14.2-5.9.2
    • postgresql14-server-14.2-5.9.2
    • postgresql14-server-debuginfo-14.2-5.9.2
    • postgresql14-devel-debuginfo-14.2-5.9.2
    • postgresql14-contrib-14.2-5.9.2
  • SUSE Linux Enterprise Real Time 15 SP2 (noarch)
    • postgresql14-docs-14.2-5.9.2

References: