Security update for postgresql12

Announcement ID:	SUSE-SU-2020:3630-1
Rating:	important
References:	bsc#1175193 bsc#1175194 bsc#1178666 bsc#1178667 bsc#1178668
Cross-References:	CVE-2020-14349 CVE-2020-14350 CVE-2020-25694 CVE-2020-25695 CVE-2020-25696
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:

• https://www.suse.com/security/cve/CVE-2020-14349.html
• https://www.suse.com/security/cve/CVE-2020-14350.html
• 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=1175193
• https://bugzilla.suse.com/show_bug.cgi?id=1175194
• 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