A postgresql10 security update has been released for openSUSE Leap 15.2.

opensuse-security-announce: openSUSE-SU-2020:2019-1: important: Security update for postgresql10

openSUSE Security Update: Security update for postgresql10
______________________________________________________________________________

Announcement ID: openSUSE-SU-2020:2019-1
Rating: important
References: #1178666 #1178667 #1178668
Cross-References: CVE-2020-25694 CVE-2020-25695 CVE-2020-25696

Affected Products:
openSUSE Leap 15.2
______________________________________________________________________________

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.
* 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

This update was imported from the SUSE:SLE-15-SP1:Update update project.

Patch Instructions:

To install this openSUSE 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:

- openSUSE Leap 15.2:

zypper in -t patch openSUSE-2020-2019=1


Package List:

- openSUSE Leap 15.2 (i586 x86_64):

postgresql10-10.15-lp152.2.9.1
postgresql10-contrib-10.15-lp152.2.9.1
postgresql10-contrib-debuginfo-10.15-lp152.2.9.1
postgresql10-debuginfo-10.15-lp152.2.9.1
postgresql10-debugsource-10.15-lp152.2.9.1
postgresql10-devel-10.15-lp152.2.9.1
postgresql10-devel-debuginfo-10.15-lp152.2.9.1
postgresql10-plperl-10.15-lp152.2.9.1
postgresql10-plperl-debuginfo-10.15-lp152.2.9.1
postgresql10-plpython-10.15-lp152.2.9.1
postgresql10-plpython-debuginfo-10.15-lp152.2.9.1
postgresql10-pltcl-10.15-lp152.2.9.1
postgresql10-pltcl-debuginfo-10.15-lp152.2.9.1
postgresql10-server-10.15-lp152.2.9.1
postgresql10-server-debuginfo-10.15-lp152.2.9.1
postgresql10-test-10.15-lp152.2.9.1

- openSUSE Leap 15.2 (noarch):

postgresql10-docs-10.15-lp152.2.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