Security update for postgresql, postgresql12, postgresql13

SUSE Security Update: Security update for postgresql, postgresql12, postgresql13
Announcement ID: SUSE-SU-2021:0217-1
Rating: important
References: #1178666 #1178667 #1178668 #1178961 #1179765
Cross-References:CVE-2020-25694 CVE-2020-25695 CVE-2020-25696
Affected Products:
  • SUSE OpenStack Cloud Crowbar 9
  • SUSE OpenStack Cloud Crowbar 8
  • SUSE OpenStack Cloud 9
  • SUSE OpenStack Cloud 8
  • SUSE OpenStack Cloud 7
  • SUSE Linux Enterprise Software Development Kit 12-SP5
  • SUSE Linux Enterprise Server for SAP 12-SP4
  • SUSE Linux Enterprise Server for SAP 12-SP3
  • SUSE Linux Enterprise Server for SAP 12-SP2
  • SUSE Linux Enterprise Server 12-SP5
  • SUSE Linux Enterprise Server 12-SP4-LTSS
  • SUSE Linux Enterprise Server 12-SP3-LTSS
  • SUSE Linux Enterprise Server 12-SP3-BCL
  • SUSE Linux Enterprise Server 12-SP2-LTSS
  • SUSE Linux Enterprise Server 12-SP2-BCL
  • SUSE Enterprise Storage 5
  • HPE Helion Openstack 8

An update that solves three vulnerabilities and has two fixes is now available.

Description:

This update for postgresql, postgresql12, postgresql13 fixes the following issues:
Initial packaging of PostgreSQL 13:

  • https://www.postgresql.org/about/news/2077/
  • https://www.postgresql.org/docs/13/release-13.html

Changes in postgresql:
  • Bump postgresql major version to 13.

Changes in postgresql12:
  • %ghost the symlinks to pg_config and ecpg. (bsc#1178961)
  • BuildRequire libpq5 and libecpg6 when not building them to avoid dangling symlinks in the devel package. (bsc#1179765)
  • Fix a DST problem in the test suite.

Changes in postgresql13:
  • Add postgresql-icu68.patch: fix build with ICU 68

  • %ghost the symlinks to pg_config and ecpg. (bsc#1178961)
  • BuildRequire libpq5 and libecpg6 when not building them to avoid dangling symlinks in the devel package. (bsc#1179765)

Upgrade to version 13.1:
  • 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/13/release-13-1.html

  • Fix a DST problem in the test suite.

Patch Instructions:

To install this SUSE Security 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 OpenStack Cloud Crowbar 9:
    zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-9-2021-217=1
  • SUSE OpenStack Cloud Crowbar 8:
    zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-8-2021-217=1
  • SUSE OpenStack Cloud 9:
    zypper in -t patch SUSE-OpenStack-Cloud-9-2021-217=1
  • SUSE OpenStack Cloud 8:
    zypper in -t patch SUSE-OpenStack-Cloud-8-2021-217=1
  • SUSE OpenStack Cloud 7:
    zypper in -t patch SUSE-OpenStack-Cloud-7-2021-217=1
  • SUSE Linux Enterprise Software Development Kit 12-SP5:
    zypper in -t patch SUSE-SLE-SDK-12-SP5-2021-217=1
  • SUSE Linux Enterprise Server for SAP 12-SP4:
    zypper in -t patch SUSE-SLE-SAP-12-SP4-2021-217=1
  • SUSE Linux Enterprise Server for SAP 12-SP3:
    zypper in -t patch SUSE-SLE-SAP-12-SP3-2021-217=1
  • SUSE Linux Enterprise Server for SAP 12-SP2:
    zypper in -t patch SUSE-SLE-SAP-12-SP2-2021-217=1
  • SUSE Linux Enterprise Server 12-SP5:
    zypper in -t patch SUSE-SLE-SERVER-12-SP5-2021-217=1
  • SUSE Linux Enterprise Server 12-SP4-LTSS:
    zypper in -t patch SUSE-SLE-SERVER-12-SP4-LTSS-2021-217=1
  • SUSE Linux Enterprise Server 12-SP3-LTSS:
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-2021-217=1
  • SUSE Linux Enterprise Server 12-SP3-BCL:
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-BCL-2021-217=1
  • SUSE Linux Enterprise Server 12-SP2-LTSS:
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-2021-217=1
  • SUSE Linux Enterprise Server 12-SP2-BCL:
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-BCL-2021-217=1
  • SUSE Enterprise Storage 5:
    zypper in -t patch SUSE-Storage-5-2021-217=1
  • HPE Helion Openstack 8:
    zypper in -t patch HPE-Helion-OpenStack-8-2021-217=1

Package List:

  • SUSE OpenStack Cloud Crowbar 9 (x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE OpenStack Cloud Crowbar 9 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE OpenStack Cloud Crowbar 8 (x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE OpenStack Cloud Crowbar 8 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE OpenStack Cloud 9 (x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE OpenStack Cloud 9 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE OpenStack Cloud 8 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE OpenStack Cloud 8 (x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE OpenStack Cloud 7 (s390x x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE OpenStack Cloud 7 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Linux Enterprise Software Development Kit 12-SP5 (aarch64 ppc64le s390x x86_64):
    • postgresql12-debugsource-12.5-3.12.3
    • postgresql12-devel-12.5-3.12.3
    • postgresql12-devel-debuginfo-12.5-3.12.3
    • postgresql13-debugsource-13.1-3.3.1
    • postgresql13-devel-13.1-3.3.1
    • postgresql13-devel-debuginfo-13.1-3.3.1
  • SUSE Linux Enterprise Software Development Kit 12-SP5 (ppc64le s390x x86_64):
    • postgresql12-server-devel-12.5-3.12.3
    • postgresql12-server-devel-debuginfo-12.5-3.12.3
    • postgresql13-server-devel-13.1-3.3.1
    • postgresql13-server-devel-debuginfo-13.1-3.3.1
  • SUSE Linux Enterprise Software Development Kit 12-SP5 (noarch):
    • postgresql-devel-13-4.7.1
    • postgresql-server-devel-13-4.7.1
  • SUSE Linux Enterprise Server for SAP 12-SP4 (ppc64le x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
  • SUSE Linux Enterprise Server for SAP 12-SP4 (x86_64):
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE Linux Enterprise Server for SAP 12-SP4 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Linux Enterprise Server for SAP 12-SP3 (ppc64le x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
  • SUSE Linux Enterprise Server for SAP 12-SP3 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Linux Enterprise Server for SAP 12-SP3 (x86_64):
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE Linux Enterprise Server for SAP 12-SP2 (ppc64le x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
  • SUSE Linux Enterprise Server for SAP 12-SP2 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Linux Enterprise Server for SAP 12-SP2 (x86_64):
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP5 (aarch64 ppc64le s390x x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
    • postgresql12-12.5-3.12.3
    • postgresql12-contrib-12.5-3.12.3
    • postgresql12-contrib-debuginfo-12.5-3.12.3
    • postgresql12-debuginfo-12.5-3.12.3
    • postgresql12-debugsource-12.5-3.12.3
    • postgresql12-plperl-12.5-3.12.3
    • postgresql12-plperl-debuginfo-12.5-3.12.3
    • postgresql12-plpython-12.5-3.12.3
    • postgresql12-plpython-debuginfo-12.5-3.12.3
    • postgresql12-pltcl-12.5-3.12.3
    • postgresql12-pltcl-debuginfo-12.5-3.12.3
    • postgresql12-server-12.5-3.12.3
    • postgresql12-server-debuginfo-12.5-3.12.3
  • SUSE Linux Enterprise Server 12-SP5 (aarch64 ppc64le s390x):
    • postgresql13-13.1-3.3.1
    • postgresql13-contrib-13.1-3.3.1
    • postgresql13-contrib-debuginfo-13.1-3.3.1
    • postgresql13-debuginfo-13.1-3.3.1
    • postgresql13-debugsource-13.1-3.3.1
    • postgresql13-plperl-13.1-3.3.1
    • postgresql13-plperl-debuginfo-13.1-3.3.1
    • postgresql13-plpython-13.1-3.3.1
    • postgresql13-plpython-debuginfo-13.1-3.3.1
    • postgresql13-pltcl-13.1-3.3.1
    • postgresql13-pltcl-debuginfo-13.1-3.3.1
    • postgresql13-server-13.1-3.3.1
    • postgresql13-server-debuginfo-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP5 (s390x x86_64):
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP5 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
    • postgresql12-docs-12.5-3.12.3
    • postgresql13-docs-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP4-LTSS (aarch64 ppc64le s390x x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP4-LTSS (s390x x86_64):
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP4-LTSS (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Linux Enterprise Server 12-SP3-LTSS (aarch64 ppc64le s390x x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP3-LTSS (s390x x86_64):
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP3-LTSS (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Linux Enterprise Server 12-SP3-BCL (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Linux Enterprise Server 12-SP3-BCL (x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP2-LTSS (ppc64le s390x x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP2-LTSS (s390x x86_64):
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP2-LTSS (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Linux Enterprise Server 12-SP2-BCL (x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • SUSE Linux Enterprise Server 12-SP2-BCL (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Enterprise Storage 5 (aarch64 x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
  • SUSE Enterprise Storage 5 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • SUSE Enterprise Storage 5 (x86_64):
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1
  • HPE Helion Openstack 8 (noarch):
    • postgresql-13-4.7.1
    • postgresql-contrib-13-4.7.1
    • postgresql-docs-13-4.7.1
    • postgresql-plperl-13-4.7.1
    • postgresql-plpython-13-4.7.1
    • postgresql-pltcl-13-4.7.1
    • postgresql-server-13-4.7.1
  • HPE Helion Openstack 8 (x86_64):
    • libecpg6-13.1-3.3.1
    • libecpg6-debuginfo-13.1-3.3.1
    • libpq5-13.1-3.3.1
    • libpq5-32bit-13.1-3.3.1
    • libpq5-debuginfo-13.1-3.3.1
    • libpq5-debuginfo-32bit-13.1-3.3.1

References: