SUSE-RU-2021:3317-1: moderate: Recommended update for postgresql10

[sle-updates at lists.suse.com]

   SUSE Recommended Update: Recommended update for postgresql10
______________________________________________________________________________

Announcement ID:    SUSE-RU-2021:3317-1
Rating:             moderate
References:         #1179945 #1185952 #1187751 #1190177 
Affected Products:
                    SUSE Linux Enterprise Module for Server Applications 15-SP2
                    SUSE Linux Enterprise Module for Legacy Software 15-SP3
                    SUSE Linux Enterprise Module for Basesystem 15-SP2
______________________________________________________________________________

   An update that has four recommended 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 Recommended Update use the SUSE recommended installation methods
   like YaST online_update or "zypper patch".

   Alternatively you can run the command listed for your product:

   - SUSE Linux Enterprise Module for Server Applications 15-SP2:

      zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP2-2021-3317=1

   - SUSE Linux Enterprise Module for Legacy Software 15-SP3:

      zypper in -t patch SUSE-SLE-Module-Legacy-15-SP3-2021-3317=1

   - SUSE Linux Enterprise Module for Basesystem 15-SP2:

      zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP2-2021-3317=1



Package List:

   - SUSE Linux Enterprise Module for Server Applications 15-SP2 (aarch64 ppc64le s390x x86_64):

      postgresql10-contrib-10.18-8.38.1
      postgresql10-contrib-debuginfo-10.18-8.38.1
      postgresql10-debuginfo-10.18-8.38.1
      postgresql10-debugsource-10.18-8.38.1
      postgresql10-devel-10.18-8.38.1
      postgresql10-devel-debuginfo-10.18-8.38.1
      postgresql10-plperl-10.18-8.38.1
      postgresql10-plperl-debuginfo-10.18-8.38.1
      postgresql10-plpython-10.18-8.38.1
      postgresql10-plpython-debuginfo-10.18-8.38.1
      postgresql10-pltcl-10.18-8.38.1
      postgresql10-pltcl-debuginfo-10.18-8.38.1
      postgresql10-server-10.18-8.38.1
      postgresql10-server-debuginfo-10.18-8.38.1

   - SUSE Linux Enterprise Module for Server Applications 15-SP2 (noarch):

      postgresql10-docs-10.18-8.38.1

   - SUSE Linux Enterprise Module for Legacy Software 15-SP3 (aarch64 ppc64le s390x x86_64):

      postgresql10-10.18-8.38.1
      postgresql10-contrib-10.18-8.38.1
      postgresql10-contrib-debuginfo-10.18-8.38.1
      postgresql10-debuginfo-10.18-8.38.1
      postgresql10-debugsource-10.18-8.38.1
      postgresql10-devel-10.18-8.38.1
      postgresql10-devel-debuginfo-10.18-8.38.1
      postgresql10-plperl-10.18-8.38.1
      postgresql10-plperl-debuginfo-10.18-8.38.1
      postgresql10-plpython-10.18-8.38.1
      postgresql10-plpython-debuginfo-10.18-8.38.1
      postgresql10-pltcl-10.18-8.38.1
      postgresql10-pltcl-debuginfo-10.18-8.38.1
      postgresql10-server-10.18-8.38.1
      postgresql10-server-debuginfo-10.18-8.38.1

   - SUSE Linux Enterprise Module for Basesystem 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


References:

   https://bugzilla.suse.com/1179945
   https://bugzilla.suse.com/1185952
   https://bugzilla.suse.com/1187751
   https://bugzilla.suse.com/1190177