Security update for postgresql10

Announcement ID: SUSE-SU-2020:3476-1
Rating: important
References:
Cross-References:
CVSS scores:
  • CVE-2020-25694 ( SUSE ): 6.5 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
  • CVE-2020-25694 ( NVD ): 8.1 CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H
  • CVE-2020-25695 ( SUSE ): 7.8 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
  • CVE-2020-25695 ( NVD ): 8.8 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
  • CVE-2020-25696 ( SUSE ): 8.0 CVSS:3.1/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
  • CVE-2020-25696 ( NVD ): 7.5 CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:U/C:H/I:H/A:H
Affected Products:
  • Basesystem Module 15-SP2
  • Basesystem Module 15-SP1
  • Server Applications Module 15-SP2
  • Server Applications Module 15-SP1
  • SUSE Linux Enterprise Desktop 15 SP1
  • SUSE Linux Enterprise Desktop 15 SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP1
  • SUSE Linux Enterprise High Performance Computing 15 SP2
  • SUSE Linux Enterprise Real Time 15 SP1
  • SUSE Linux Enterprise Real Time 15 SP2
  • SUSE Linux Enterprise Server 15 SP1
  • SUSE Linux Enterprise Server 15 SP1 Business Critical Linux 15-SP1
  • 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 SP1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
  • SUSE Manager Proxy 4.0
  • SUSE Manager Proxy 4.1
  • SUSE Manager Retail Branch Server 4.0
  • SUSE Manager Retail Branch Server 4.1
  • SUSE Manager Server 4.0
  • SUSE Manager Server 4.1

An update that solves three vulnerabilities can now be installed.

Description:

This update for postgresql10 fixes the following issues:

  • Upgrade to version 10.15:
  • CVE-2020-25695, bsc#1178666: Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries.
  • CVE-2020-25694, bsc#1178667: a) Fix usage of complex connection-string parameters in pg_dump, pg_restore, clusterdb, reindexdb, and vacuumdb. b) When psql's \connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used.
  • CVE-2020-25696, bsc#1178668: Prevent psql's \gset command from modifying specially-treated variables.
  • Fix recently-added timetz test case so it works when the USA is not observing daylight savings time.
  • https://www.postgresql.org/about/news/2111/
  • https://www.postgresql.org/docs/10/release-10-15.html

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-SP1
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP1-2020-3476=1
  • Basesystem Module 15-SP2
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP2-2020-3476=1
  • Server Applications Module 15-SP1
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP1-2020-3476=1
  • Server Applications Module 15-SP2
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP2-2020-3476=1

Package List:

  • Basesystem Module 15-SP1 (aarch64 ppc64le s390x x86_64)
    • postgresql10-debugsource-10.15-8.22.1
    • postgresql10-debuginfo-10.15-8.22.1
    • postgresql10-10.15-8.22.1
  • Basesystem Module 15-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql10-debugsource-10.15-8.22.1
    • postgresql10-debuginfo-10.15-8.22.1
    • postgresql10-10.15-8.22.1
  • Server Applications Module 15-SP1 (aarch64 ppc64le s390x x86_64)
    • postgresql10-debugsource-10.15-8.22.1
    • postgresql10-server-debuginfo-10.15-8.22.1
    • postgresql10-plpython-10.15-8.22.1
    • postgresql10-devel-debuginfo-10.15-8.22.1
    • postgresql10-pltcl-debuginfo-10.15-8.22.1
    • postgresql10-plperl-10.15-8.22.1
    • postgresql10-contrib-10.15-8.22.1
    • postgresql10-devel-10.15-8.22.1
    • postgresql10-plperl-debuginfo-10.15-8.22.1
    • postgresql10-server-10.15-8.22.1
    • postgresql10-pltcl-10.15-8.22.1
    • postgresql10-plpython-debuginfo-10.15-8.22.1
    • postgresql10-debuginfo-10.15-8.22.1
    • postgresql10-contrib-debuginfo-10.15-8.22.1
  • Server Applications Module 15-SP1 (noarch)
    • postgresql10-docs-10.15-8.22.1
  • Server Applications Module 15-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql10-debugsource-10.15-8.22.1
    • postgresql10-server-debuginfo-10.15-8.22.1
    • postgresql10-plpython-10.15-8.22.1
    • postgresql10-devel-debuginfo-10.15-8.22.1
    • postgresql10-pltcl-debuginfo-10.15-8.22.1
    • postgresql10-plperl-10.15-8.22.1
    • postgresql10-contrib-10.15-8.22.1
    • postgresql10-devel-10.15-8.22.1
    • postgresql10-plperl-debuginfo-10.15-8.22.1
    • postgresql10-server-10.15-8.22.1
    • postgresql10-pltcl-10.15-8.22.1
    • postgresql10-plpython-debuginfo-10.15-8.22.1
    • postgresql10-debuginfo-10.15-8.22.1
    • postgresql10-contrib-debuginfo-10.15-8.22.1
  • Server Applications Module 15-SP2 (noarch)
    • postgresql10-docs-10.15-8.22.1

References: