Recommended update for postgresql10

Announcement ID: SUSE-RU-2021:3317-1
Rating: moderate
References:
Affected Products:
  • Basesystem Module 15-SP2
  • Legacy Module 15-SP3
  • Server Applications Module 15-SP2
  • SUSE Linux Enterprise Desktop 15 SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP3
  • 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 15 SP3
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3
  • SUSE Manager Proxy 4.1
  • SUSE Manager Proxy 4.2
  • SUSE Manager Retail Branch Server 4.1
  • SUSE Manager Retail Branch Server 4.2
  • SUSE Manager Server 4.1
  • SUSE Manager Server 4.2

An update that has four fixes can now be installed.

Description:

This update for postgresql10 fixes the following issues:

  • Upgrade to version 10.18. (bsc#1190177)
  • A dump/restore is not required for those running 10.X.
  • if you are upgrading from a version older than 10.16 a reindexing of indexes after the upgrade may be advisable.
  • Allow PostgreSQL version 10 to build with ICU 69 and newer
  • Clarify error messages referring to 'non-negative' values
  • Fix incorrect log message when 'point-in-time' recovery stops at a 'ROLLBACK PREPARED' record
  • In 'contrib/postgres_fdw', avoid attempting catalog lookups after an error
    • Messages about data conversion errors will now mention the query's table and column aliases (if used) rather than the true underlying name of a foreign table or column.
  • Avoid problems when 'switching pg_receivewal' between compressed and non-compressed 'WAL' storage
  • Extend 'pg_upgrade' to detect and warn about extensions that should be upgraded.
  • Make 'pg_upgrade' carry forward the old installation's 'oldestXID' value.
    • This solves unwanted forced shutdowns happening soon after an upgrade in particular on installations using large values of 'autovacuum_freeze_max_age'.
  • Avoid 'invalid creation date in header' warnings observed when running 'pg_restore' on an archive file created in a different time zone.
  • In psql and other client programs, avoid overrunning the ends of strings when dealing with invalidly-encoded data.
  • Don't abort the process for an out-of-memory failure in libpq's printing functions
  • Fix uninitialized-variable bug that could cause 'PL/pgSQL' to act as though an 'INTO' clause specified 'STRICT', even though it didn't.
  • Fix latent crash in sorting code
  • Fix possible race condition when releasing BackgroundWorkerSlots
  • Solve a build issue fix build with 'llvm12' on s390x. (bsc#1185952)
  • Re-enable 'icu' for 'PostgreSQL 10'. (bsc#1179945)
  • Relax the dependency of 'postgresqlXX-server-devel' on 'llvm' and 'clang'. (bsc#1187751)

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-2021-3317=1
  • Legacy Module 15-SP3
    zypper in -t patch SUSE-SLE-Module-Legacy-15-SP3-2021-3317=1
  • Server Applications Module 15-SP2
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP2-2021-3317=1

Package List:

  • Basesystem Module 15-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql10-10.18-8.38.1
    • postgresql10-debuginfo-10.18-8.38.1
    • postgresql10-debugsource-10.18-8.38.1
  • Legacy Module 15-SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql10-devel-debuginfo-10.18-8.38.1
    • postgresql10-pltcl-10.18-8.38.1
    • postgresql10-devel-10.18-8.38.1
    • postgresql10-pltcl-debuginfo-10.18-8.38.1
    • postgresql10-contrib-10.18-8.38.1
    • postgresql10-server-debuginfo-10.18-8.38.1
    • postgresql10-10.18-8.38.1
    • postgresql10-contrib-debuginfo-10.18-8.38.1
    • postgresql10-debugsource-10.18-8.38.1
    • postgresql10-plperl-debuginfo-10.18-8.38.1
    • postgresql10-plpython-debuginfo-10.18-8.38.1
    • postgresql10-plpython-10.18-8.38.1
    • postgresql10-plperl-10.18-8.38.1
    • postgresql10-debuginfo-10.18-8.38.1
    • postgresql10-server-10.18-8.38.1
  • Server Applications Module 15-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql10-devel-debuginfo-10.18-8.38.1
    • postgresql10-pltcl-10.18-8.38.1
    • postgresql10-devel-10.18-8.38.1
    • postgresql10-pltcl-debuginfo-10.18-8.38.1
    • postgresql10-contrib-10.18-8.38.1
    • postgresql10-server-debuginfo-10.18-8.38.1
    • postgresql10-contrib-debuginfo-10.18-8.38.1
    • postgresql10-debugsource-10.18-8.38.1
    • postgresql10-plperl-debuginfo-10.18-8.38.1
    • postgresql10-plpython-debuginfo-10.18-8.38.1
    • postgresql10-plpython-10.18-8.38.1
    • postgresql10-plperl-10.18-8.38.1
    • postgresql10-debuginfo-10.18-8.38.1
    • postgresql10-server-10.18-8.38.1
  • Server Applications Module 15-SP2 (noarch)
    • postgresql10-docs-10.18-8.38.1

References: