SUSE Security Update: Security update for postgresql10
______________________________________________________________________________

Announcement ID:    SUSE-SU-2020:3464-1
Rating:             important
References:         #1178666 #1178667 #1178668 
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 fixes three vulnerabilities is now available.

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.
     * https://www.postgresql.org/about/news/2111/
     * https://www.postgresql.org/docs/10/release-10-15.html


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-2020-3464=1

   - SUSE OpenStack Cloud Crowbar 8:

      zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-8-2020-3464=1

   - SUSE OpenStack Cloud 9:

      zypper in -t patch SUSE-OpenStack-Cloud-9-2020-3464=1

   - SUSE OpenStack Cloud 8:

      zypper in -t patch SUSE-OpenStack-Cloud-8-2020-3464=1

   - SUSE OpenStack Cloud 7:

      zypper in -t patch SUSE-OpenStack-Cloud-7-2020-3464=1

   - SUSE Linux Enterprise Software Development Kit 12-SP5:

      zypper in -t patch SUSE-SLE-SDK-12-SP5-2020-3464=1

   - SUSE Linux Enterprise Server for SAP 12-SP4:

      zypper in -t patch SUSE-SLE-SAP-12-SP4-2020-3464=1

   - SUSE Linux Enterprise Server for SAP 12-SP3:

      zypper in -t patch SUSE-SLE-SAP-12-SP3-2020-3464=1

   - SUSE Linux Enterprise Server for SAP 12-SP2:

      zypper in -t patch SUSE-SLE-SAP-12-SP2-2020-3464=1

   - SUSE Linux Enterprise Server 12-SP5:

      zypper in -t patch SUSE-SLE-SERVER-12-SP5-2020-3464=1

   - SUSE Linux Enterprise Server 12-SP4-LTSS:

      zypper in -t patch SUSE-SLE-SERVER-12-SP4-LTSS-2020-3464=1

   - SUSE Linux Enterprise Server 12-SP3-LTSS:

      zypper in -t patch SUSE-SLE-SERVER-12-SP3-2020-3464=1

   - SUSE Linux Enterprise Server 12-SP3-BCL:

      zypper in -t patch SUSE-SLE-SERVER-12-SP3-BCL-2020-3464=1

   - SUSE Linux Enterprise Server 12-SP2-LTSS:

      zypper in -t patch SUSE-SLE-SERVER-12-SP2-2020-3464=1

   - SUSE Linux Enterprise Server 12-SP2-BCL:

      zypper in -t patch SUSE-SLE-SERVER-12-SP2-BCL-2020-3464=1

   - SUSE Enterprise Storage 5:

      zypper in -t patch SUSE-Storage-5-2020-3464=1

   - HPE Helion Openstack 8:

      zypper in -t patch HPE-Helion-OpenStack-8-2020-3464=1



Package List:

   - SUSE OpenStack Cloud Crowbar 9 (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE OpenStack Cloud Crowbar 9 (x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE OpenStack Cloud Crowbar 8 (x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE OpenStack Cloud Crowbar 8 (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE OpenStack Cloud 9 (x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE OpenStack Cloud 9 (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE OpenStack Cloud 8 (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE OpenStack Cloud 8 (x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE OpenStack Cloud 7 (s390x x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE OpenStack Cloud 7 (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Linux Enterprise Software Development Kit 12-SP5 (aarch64 ppc64le s390x x86_64):

      postgresql10-debugsource-10.15-4.9.1
      postgresql10-devel-10.15-4.9.1
      postgresql10-devel-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server for SAP 12-SP4 (ppc64le x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server for SAP 12-SP4 (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Linux Enterprise Server for SAP 12-SP3 (ppc64le x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server for SAP 12-SP3 (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Linux Enterprise Server for SAP 12-SP2 (ppc64le x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server for SAP 12-SP2 (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP5 (aarch64 ppc64le s390x x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP5 (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP4-LTSS (aarch64 ppc64le s390x x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP4-LTSS (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP3-LTSS (aarch64 ppc64le s390x x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP3-LTSS (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP3-BCL (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP3-BCL (x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP2-LTSS (ppc64le s390x x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP2-LTSS (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP2-BCL (x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Linux Enterprise Server 12-SP2-BCL (noarch):

      postgresql10-docs-10.15-4.9.1

   - SUSE Enterprise Storage 5 (aarch64 x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.1

   - SUSE Enterprise Storage 5 (noarch):

      postgresql10-docs-10.15-4.9.1

   - HPE Helion Openstack 8 (noarch):

      postgresql10-docs-10.15-4.9.1

   - HPE Helion Openstack 8 (x86_64):

      postgresql10-10.15-4.9.1
      postgresql10-contrib-10.15-4.9.1
      postgresql10-contrib-debuginfo-10.15-4.9.1
      postgresql10-debuginfo-10.15-4.9.1
      postgresql10-debugsource-10.15-4.9.1
      postgresql10-plperl-10.15-4.9.1
      postgresql10-plperl-debuginfo-10.15-4.9.1
      postgresql10-plpython-10.15-4.9.1
      postgresql10-plpython-debuginfo-10.15-4.9.1
      postgresql10-pltcl-10.15-4.9.1
      postgresql10-pltcl-debuginfo-10.15-4.9.1
      postgresql10-server-10.15-4.9.1
      postgresql10-server-debuginfo-10.15-4.9.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/1178666
   https://bugzilla.suse.com/1178667
   https://bugzilla.suse.com/1178668