Security update for postgresql10

Announcement ID:	SUSE-SU-2020:3455-1
Rating:	important
References:	bsc#1178666 bsc#1178667 bsc#1178668
Cross-References:	CVE-2020-25694 CVE-2020-25695 CVE-2020-25696
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:	SUSE Linux Enterprise High Performance Computing 15 SUSE Linux Enterprise High Performance Computing 15 LTSS 15 SUSE Linux Enterprise Server 15 SUSE Linux Enterprise Server 15 LTSS 15 SUSE Linux Enterprise Server ESPOS 15 SUSE Linux Enterprise Server for SAP Applications 15

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:

• SUSE Linux Enterprise Server ESPOS 15
  zypper in -t patch SUSE-SLE-Product-HPC-15-2020-3455=1
• SUSE Linux Enterprise High Performance Computing 15 LTSS 15
  zypper in -t patch SUSE-SLE-Product-HPC-15-2020-3455=1
• SUSE Linux Enterprise Server 15 LTSS 15
  zypper in -t patch SUSE-SLE-Product-SLES-15-2020-3455=1
• SUSE Linux Enterprise Server for SAP Applications 15
  zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-2020-3455=1

Package List:

• SUSE Linux Enterprise Server ESPOS 15 (aarch64 x86_64)
  • postgresql10-debugsource-10.15-4.28.1
  • postgresql10-devel-debuginfo-10.15-4.28.1
  • postgresql10-plpython-debuginfo-10.15-4.28.1
  • postgresql10-server-10.15-4.28.1
  • libecpg6-debuginfo-10.15-4.28.1
  • postgresql10-server-debuginfo-10.15-4.28.1
  • postgresql10-plperl-debuginfo-10.15-4.28.1
  • libpq5-debuginfo-10.15-4.28.1
  • postgresql10-devel-10.15-4.28.1
  • postgresql10-debuginfo-10.15-4.28.1
  • postgresql10-plperl-10.15-4.28.1
  • postgresql10-pltcl-10.15-4.28.1
  • libpq5-10.15-4.28.1
  • postgresql10-10.15-4.28.1
  • postgresql10-contrib-debuginfo-10.15-4.28.1
  • postgresql10-plpython-10.15-4.28.1
  • libecpg6-10.15-4.28.1
  • postgresql10-pltcl-debuginfo-10.15-4.28.1
  • postgresql10-contrib-10.15-4.28.1
• SUSE Linux Enterprise Server ESPOS 15 (noarch)
  • postgresql10-docs-10.15-4.28.1
• SUSE Linux Enterprise Server ESPOS 15 (x86_64)
  • libpq5-32bit-debuginfo-10.15-4.28.1
  • libpq5-32bit-10.15-4.28.1
• SUSE Linux Enterprise High Performance Computing 15 LTSS 15 (aarch64 x86_64)
  • postgresql10-debugsource-10.15-4.28.1
  • postgresql10-devel-debuginfo-10.15-4.28.1
  • postgresql10-plpython-debuginfo-10.15-4.28.1
  • postgresql10-server-10.15-4.28.1
  • libecpg6-debuginfo-10.15-4.28.1
  • postgresql10-server-debuginfo-10.15-4.28.1
  • postgresql10-plperl-debuginfo-10.15-4.28.1
  • libpq5-debuginfo-10.15-4.28.1
  • postgresql10-devel-10.15-4.28.1
  • postgresql10-debuginfo-10.15-4.28.1
  • postgresql10-plperl-10.15-4.28.1
  • postgresql10-pltcl-10.15-4.28.1
  • libpq5-10.15-4.28.1
  • postgresql10-10.15-4.28.1
  • postgresql10-contrib-debuginfo-10.15-4.28.1
  • postgresql10-plpython-10.15-4.28.1
  • libecpg6-10.15-4.28.1
  • postgresql10-pltcl-debuginfo-10.15-4.28.1
  • postgresql10-contrib-10.15-4.28.1
• SUSE Linux Enterprise High Performance Computing 15 LTSS 15 (noarch)
  • postgresql10-docs-10.15-4.28.1
• SUSE Linux Enterprise High Performance Computing 15 LTSS 15 (x86_64)
  • libpq5-32bit-debuginfo-10.15-4.28.1
  • libpq5-32bit-10.15-4.28.1
• SUSE Linux Enterprise Server 15 LTSS 15 (aarch64 ppc64le s390x x86_64)
  • postgresql10-debugsource-10.15-4.28.1
  • postgresql10-devel-debuginfo-10.15-4.28.1
  • postgresql10-plpython-debuginfo-10.15-4.28.1
  • postgresql10-server-10.15-4.28.1
  • libecpg6-debuginfo-10.15-4.28.1
  • postgresql10-server-debuginfo-10.15-4.28.1
  • postgresql10-plperl-debuginfo-10.15-4.28.1
  • libpq5-debuginfo-10.15-4.28.1
  • postgresql10-devel-10.15-4.28.1
  • postgresql10-debuginfo-10.15-4.28.1
  • postgresql10-plperl-10.15-4.28.1
  • postgresql10-pltcl-10.15-4.28.1
  • libpq5-10.15-4.28.1
  • postgresql10-10.15-4.28.1
  • postgresql10-contrib-debuginfo-10.15-4.28.1
  • postgresql10-plpython-10.15-4.28.1
  • libecpg6-10.15-4.28.1
  • postgresql10-pltcl-debuginfo-10.15-4.28.1
  • postgresql10-contrib-10.15-4.28.1
• SUSE Linux Enterprise Server 15 LTSS 15 (noarch)
  • postgresql10-docs-10.15-4.28.1
• SUSE Linux Enterprise Server 15 LTSS 15 (x86_64)
  • libpq5-32bit-debuginfo-10.15-4.28.1
  • libpq5-32bit-10.15-4.28.1
• SUSE Linux Enterprise Server for SAP Applications 15 (ppc64le x86_64)
  • postgresql10-debugsource-10.15-4.28.1
  • postgresql10-devel-debuginfo-10.15-4.28.1
  • postgresql10-plpython-debuginfo-10.15-4.28.1
  • postgresql10-server-10.15-4.28.1
  • libecpg6-debuginfo-10.15-4.28.1
  • postgresql10-server-debuginfo-10.15-4.28.1
  • postgresql10-plperl-debuginfo-10.15-4.28.1
  • libpq5-debuginfo-10.15-4.28.1
  • postgresql10-devel-10.15-4.28.1
  • postgresql10-debuginfo-10.15-4.28.1
  • postgresql10-plperl-10.15-4.28.1
  • postgresql10-pltcl-10.15-4.28.1
  • libpq5-10.15-4.28.1
  • postgresql10-10.15-4.28.1
  • postgresql10-contrib-debuginfo-10.15-4.28.1
  • postgresql10-plpython-10.15-4.28.1
  • libecpg6-10.15-4.28.1
  • postgresql10-pltcl-debuginfo-10.15-4.28.1
  • postgresql10-contrib-10.15-4.28.1
• SUSE Linux Enterprise Server for SAP Applications 15 (noarch)
  • postgresql10-docs-10.15-4.28.1
• SUSE Linux Enterprise Server for SAP Applications 15 (x86_64)
  • libpq5-32bit-debuginfo-10.15-4.28.1
  • libpq5-32bit-10.15-4.28.1

References:

• https://www.suse.com/security/cve/CVE-2020-25694.html
• https://www.suse.com/security/cve/CVE-2020-25695.html
• https://www.suse.com/security/cve/CVE-2020-25696.html
• https://bugzilla.suse.com/show_bug.cgi?id=1178666
• https://bugzilla.suse.com/show_bug.cgi?id=1178667
• https://bugzilla.suse.com/show_bug.cgi?id=1178668