Security update for postgresql12

Announcement ID: SUSE-SU-2020:3630-1
Rating: important
References:
Cross-References:
CVSS scores:
  • CVE-2020-14349 ( SUSE ): 7.8 CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
  • CVE-2020-14349 ( NVD ): 7.1 CVSS:3.1/AV:N/AC:H/PR:L/UI:R/S:U/C:H/I:H/A:H
  • CVE-2020-14350 ( SUSE ): 7.3 CVSS:3.1/AV:L/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
  • CVE-2020-14350 ( NVD ): 7.3 CVSS:3.1/AV:L/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
  • 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:
  • HPE Helion OpenStack 8
  • SUSE Enterprise Storage 5
  • SUSE Linux Enterprise High Performance Computing 12 SP2
  • SUSE Linux Enterprise High Performance Computing 12 SP3
  • SUSE Linux Enterprise High Performance Computing 12 SP4
  • SUSE Linux Enterprise High Performance Computing 12 SP5
  • SUSE Linux Enterprise Point of Service Image Server 12 12-SP2
  • SUSE Linux Enterprise Server 12 SP2
  • SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2
  • SUSE Linux Enterprise Server 12 SP2 ESPOS 12-SP2
  • SUSE Linux Enterprise Server 12 SP2 LTSS 12-SP2
  • SUSE Linux Enterprise Server 12 SP3
  • SUSE Linux Enterprise Server 12 SP3 BCL 12-SP3
  • SUSE Linux Enterprise Server 12 SP3 ESPOS 12-SP3
  • SUSE Linux Enterprise Server 12 SP3 LTSS 12-SP3
  • SUSE Linux Enterprise Server 12 SP4
  • SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4
  • SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4
  • SUSE Linux Enterprise Server 12 SP5
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2
  • SUSE Linux Enterprise Server for SAP Applications 12 SP3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP4
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5
  • SUSE Linux Enterprise Software Development Kit 12 SP5
  • SUSE OpenStack Cloud 7
  • SUSE OpenStack Cloud 8
  • SUSE OpenStack Cloud 9
  • SUSE OpenStack Cloud Crowbar 8
  • SUSE OpenStack Cloud Crowbar 9

An update that solves five vulnerabilities can now be installed.

Description:

This update for postgresql12 fixes the following issues:

Upgrade to version 12.5:

  • 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. (obsoletes postgresql-timetz.patch)
  • https://www.postgresql.org/about/news/2111/
  • https://www.postgresql.org/docs/12/release-12-5.html

The previous postgresql12 update already addressed:

Update to 12.4:

  • CVE-2020-14349, bsc#1175193: Set a secure search_path in logical replication walsenders and apply workers
  • CVE-2020-14350, bsc#1175194: Make contrib modules' installation scripts more secure.

  • https://www.postgresql.org/docs/12/release-12-4.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:

  • HPE Helion OpenStack 8
    zypper in -t patch HPE-Helion-OpenStack-8-2020-3630=1
  • SUSE OpenStack Cloud 7
    zypper in -t patch SUSE-OpenStack-Cloud-7-2020-3630=1
  • SUSE OpenStack Cloud 8
    zypper in -t patch SUSE-OpenStack-Cloud-8-2020-3630=1
  • SUSE OpenStack Cloud 9
    zypper in -t patch SUSE-OpenStack-Cloud-9-2020-3630=1
  • SUSE OpenStack Cloud Crowbar 8
    zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-8-2020-3630=1
  • SUSE OpenStack Cloud Crowbar 9
    zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-9-2020-3630=1
  • SUSE Linux Enterprise Point of Service Image Server 12 12-SP2
    zypper in -t patch SUSE-SLE-POS-12-SP2-CLIENT-2020-3630=1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2
    zypper in -t patch SUSE-SLE-SAP-12-SP2-2020-3630=1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP3
    zypper in -t patch SUSE-SLE-SAP-12-SP3-2020-3630=1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP4
    zypper in -t patch SUSE-SLE-SAP-12-SP4-2020-3630=1
  • SUSE Linux Enterprise Software Development Kit 12 SP5
    zypper in -t patch SUSE-SLE-SDK-12-SP5-2020-3630=1
  • SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-BCL-2020-3630=1
  • SUSE Linux Enterprise Server 12 SP2 ESPOS 12-SP2
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-ESPOS-2020-3630=1
  • SUSE Linux Enterprise Server 12 SP2 LTSS 12-SP2
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-2020-3630=1
  • SUSE Linux Enterprise Server 12 SP3 BCL 12-SP3
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-BCL-2020-3630=1
  • SUSE Linux Enterprise Server 12 SP3 ESPOS 12-SP3
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-ESPOS-2020-3630=1
  • SUSE Linux Enterprise Server 12 SP3 LTSS 12-SP3
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-2020-3630=1
  • SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4
    zypper in -t patch SUSE-SLE-SERVER-12-SP4-ESPOS-2020-3630=1
  • SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4
    zypper in -t patch SUSE-SLE-SERVER-12-SP4-LTSS-2020-3630=1
  • SUSE Linux Enterprise High Performance Computing 12 SP5
    zypper in -t patch SUSE-SLE-SERVER-12-SP5-2020-3630=1
  • SUSE Linux Enterprise Server 12 SP5
    zypper in -t patch SUSE-SLE-SERVER-12-SP5-2020-3630=1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5
    zypper in -t patch SUSE-SLE-SERVER-12-SP5-2020-3630=1
  • SUSE Enterprise Storage 5
    zypper in -t patch SUSE-Storage-5-2020-3630=1

Package List:

  • HPE Helion OpenStack 8 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE OpenStack Cloud 7 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE OpenStack Cloud 8 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE OpenStack Cloud 9 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE OpenStack Cloud Crowbar 8 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE OpenStack Cloud Crowbar 9 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Point of Service Image Server 12 12-SP2 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2 (ppc64le x86_64)
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2 (x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP3 (ppc64le x86_64)
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP3 (x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP4 (ppc64le x86_64)
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP4 (x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Software Development Kit 12 SP5 (aarch64 ppc64le s390x x86_64)
    • postgresql12-devel-debuginfo-12.5-3.9.3
    • postgresql12-devel-12.5-3.9.3
    • postgresql12-debugsource-12.5-3.9.3
  • SUSE Linux Enterprise Software Development Kit 12 SP5 (ppc64le s390x x86_64)
    • postgresql12-server-devel-12.5-3.9.3
    • postgresql12-server-devel-debuginfo-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP2 ESPOS 12-SP2 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP2 LTSS 12-SP2 (ppc64le s390x x86_64)
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP2 LTSS 12-SP2 (s390x x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP3 BCL 12-SP3 (x86_64)
    • libpq5-12.5-3.9.3
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP3 ESPOS 12-SP3 (aarch64 x86_64)
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP3 ESPOS 12-SP3 (x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP3 LTSS 12-SP3 (aarch64 ppc64le s390x x86_64)
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP3 LTSS 12-SP3 (s390x x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 (aarch64 x86_64)
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 (x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 (aarch64 ppc64le s390x x86_64)
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 (s390x x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise High Performance Computing 12 SP5 (aarch64 x86_64)
    • postgresql12-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • postgresql12-plpython-12.5-3.9.3
    • postgresql12-server-debuginfo-12.5-3.9.3
    • postgresql12-contrib-12.5-3.9.3
    • postgresql12-pltcl-debuginfo-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • postgresql12-server-12.5-3.9.3
    • postgresql12-plperl-debuginfo-12.5-3.9.3
    • postgresql12-plpython-debuginfo-12.5-3.9.3
    • postgresql12-contrib-debuginfo-12.5-3.9.3
    • postgresql12-pltcl-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • postgresql12-debuginfo-12.5-3.9.3
    • postgresql12-plperl-12.5-3.9.3
    • postgresql12-debugsource-12.5-3.9.3
  • SUSE Linux Enterprise High Performance Computing 12 SP5 (noarch)
    • postgresql12-docs-12.5-3.9.3
  • SUSE Linux Enterprise High Performance Computing 12 SP5 (x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP5 (aarch64 ppc64le s390x x86_64)
    • postgresql12-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • postgresql12-plpython-12.5-3.9.3
    • postgresql12-server-debuginfo-12.5-3.9.3
    • postgresql12-contrib-12.5-3.9.3
    • postgresql12-pltcl-debuginfo-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • postgresql12-server-12.5-3.9.3
    • postgresql12-plperl-debuginfo-12.5-3.9.3
    • postgresql12-plpython-debuginfo-12.5-3.9.3
    • postgresql12-contrib-debuginfo-12.5-3.9.3
    • postgresql12-pltcl-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • postgresql12-debuginfo-12.5-3.9.3
    • postgresql12-plperl-12.5-3.9.3
    • postgresql12-debugsource-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP5 (noarch)
    • postgresql12-docs-12.5-3.9.3
  • SUSE Linux Enterprise Server 12 SP5 (s390x x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5 (ppc64le x86_64)
    • postgresql12-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • postgresql12-plpython-12.5-3.9.3
    • postgresql12-server-debuginfo-12.5-3.9.3
    • postgresql12-contrib-12.5-3.9.3
    • postgresql12-pltcl-debuginfo-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
    • postgresql12-server-12.5-3.9.3
    • postgresql12-plperl-debuginfo-12.5-3.9.3
    • postgresql12-plpython-debuginfo-12.5-3.9.3
    • postgresql12-contrib-debuginfo-12.5-3.9.3
    • postgresql12-pltcl-12.5-3.9.3
    • libpq5-debuginfo-12.5-3.9.3
    • postgresql12-debuginfo-12.5-3.9.3
    • postgresql12-plperl-12.5-3.9.3
    • postgresql12-debugsource-12.5-3.9.3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5 (noarch)
    • postgresql12-docs-12.5-3.9.3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5 (x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3
  • SUSE Enterprise Storage 5 (aarch64 x86_64)
    • libpq5-debuginfo-12.5-3.9.3
    • libpq5-12.5-3.9.3
    • libecpg6-12.5-3.9.3
    • libecpg6-debuginfo-12.5-3.9.3
  • SUSE Enterprise Storage 5 (x86_64)
    • libpq5-debuginfo-32bit-12.5-3.9.3
    • libpq5-32bit-12.5-3.9.3

References: