Recommended update for postgresql, postgresql12

Announcement ID: SUSE-RU-2020:2006-1
Rating: moderate
References:
Affected Products:
  • Basesystem Module 15-SP2
  • Server Applications Module 15-SP2
  • SUSE Linux Enterprise Desktop 15 SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP2
  • SUSE Linux Enterprise Real Time 15 SP2
  • SUSE Linux Enterprise Server 15 SP2
  • SUSE Linux Enterprise Server 15 SP2 Business Critical Linux 15-SP2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
  • SUSE Manager Proxy 4.1
  • SUSE Manager Retail Branch Server 4.1
  • SUSE Manager Server 4.1
  • SUSE Package Hub 15 15-SP2

An update that has two fixes can now be installed.

Description:

This update for postgresql, postgresql12 fixes the following issues:

Postgresql12 was updated to 12.3 (bsc#1171924).

  • https://www.postgresql.org/about/news/2038/

  • https://www.postgresql.org/docs/12/release-12-3.html

  • Let postgresqlXX conflict with postgresql-noarch < 12.0.1 to get a clean and complete cutover to the new packaging schema.

Also changed in the postgresql wrapper package:

  • Bump version to 12.0.1, so that the binary packages also have a cut-point to conflict with.

  • Conflict with versions of the binary packages prior to the May 2020 update, because we changed the package layout at that point and need a clean cutover.

  • Bump package version to 12, but leave default at 10 for SLE-15 and SLE-15-SP1.

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:

  • Basesystem Module 15-SP2
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP2-2020-2006=1
  • SUSE Package Hub 15 15-SP2
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP2-2020-2006=1
  • Server Applications Module 15-SP2
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP2-2020-2006=1

Package List:

  • Basesystem Module 15-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql12-debugsource-12.3-8.3.3
    • libpq5-12.3-8.3.3
    • postgresql12-debuginfo-12.3-8.3.3
    • libpq5-debuginfo-12.3-8.3.3
    • postgresql12-12.3-8.3.3
  • Basesystem Module 15-SP2 (noarch)
    • postgresql-12.0.1-4.3.2
  • Basesystem Module 15-SP2 (x86_64)
    • libpq5-32bit-12.3-8.3.3
    • libpq5-32bit-debuginfo-12.3-8.3.3
  • SUSE Package Hub 15 15-SP2 (noarch)
    • postgresql-test-12.0.1-4.3.2
  • Server Applications Module 15-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql12-debugsource-12.3-8.3.3
    • postgresql12-devel-12.3-8.3.3
    • postgresql12-plpython-12.3-8.3.3
    • postgresql12-plperl-debuginfo-12.3-8.3.3
    • postgresql12-pltcl-12.3-8.3.3
    • postgresql12-pltcl-debuginfo-12.3-8.3.3
    • libecpg6-debuginfo-12.3-8.3.3
    • postgresql12-devel-debuginfo-12.3-8.3.3
    • postgresql12-server-devel-12.3-8.3.3
    • postgresql12-server-devel-debuginfo-12.3-8.3.3
    • postgresql12-server-12.3-8.3.3
    • postgresql12-debuginfo-12.3-8.3.3
    • libecpg6-12.3-8.3.3
    • postgresql12-contrib-12.3-8.3.3
    • postgresql12-server-debuginfo-12.3-8.3.3
    • postgresql12-contrib-debuginfo-12.3-8.3.3
    • postgresql12-plperl-12.3-8.3.3
    • postgresql12-plpython-debuginfo-12.3-8.3.3
  • Server Applications Module 15-SP2 (noarch)
    • postgresql-server-devel-12.0.1-4.3.2
    • postgresql-plpython-12.0.1-4.3.2
    • postgresql-pltcl-12.0.1-4.3.2
    • postgresql12-docs-12.3-8.3.3
    • postgresql-plperl-12.0.1-4.3.2
    • postgresql-contrib-12.0.1-4.3.2
    • postgresql-docs-12.0.1-4.3.2
    • postgresql-server-12.0.1-4.3.2
    • postgresql-devel-12.0.1-4.3.2

References: