openSUSE Security Update : postgresql / postgresql13 (openSUSE-2021-337)

high Nessus Plugin ID 146831

Language:

New! Plugin Severity Now Using CVSS v3

The calculated severity for Plugins has been updated to use CVSS v3 by default. Plugins that do not have a CVSS v3 score will fall back to CVSS v2 for calculating severity. Severity display preferences can be toggled in the settings dropdown.

Synopsis

The remote openSUSE host is missing a security update.

Description

This update for postgresql, postgresql13 fixes the following issues :

This update ships postgresql13.

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

Initial packaging of PostgreSQL 13 :

- https://www.postgresql.org/about/news/2077/

- https://www.postgresql.org/docs/13/release-13.html

- bsc#1178961: %ghost the symlinks to pg_config and ecpg.

Changes in postgresql wrapper package :

- Bump major version to 13.

- We also transfer PostgreSQL 9.4.26 to the new package layout in SLE12-SP2 and newer. Reflect this in the conflict with postgresql94.

- Also conflict with PostgreSQL versions before 9.

- Conflicting with older versions is not limited to SLE.

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

Solution

Update the affected postgresql / postgresql13 packages.

See Also

https://bugzilla.opensuse.org/show_bug.cgi?id=1178666

https://bugzilla.opensuse.org/show_bug.cgi?id=1178667

https://bugzilla.opensuse.org/show_bug.cgi?id=1178668

https://bugzilla.opensuse.org/show_bug.cgi?id=1178961

https://www.postgresql.org/about/news/2077/

https://www.postgresql.org/about/news/2111/

https://www.postgresql.org/docs/13/release-13-1.html

https://www.postgresql.org/docs/13/release-13.html

Plugin Details

Severity: High

ID: 146831

File Name: openSUSE-2021-337.nasl

Version: 1.2

Type: local

Agent: unix

Published: 2/25/2021

Updated: 3/1/2021

Dependencies: ssh_get_info.nasl

Risk Information

CVSS Score Source: CVE-2020-25696

VPR

Risk Factor: High

Score: 7.4

CVSS v2

Risk Factor: High

Base Score: 7.6

Temporal Score: 5.6

Vector: AV:N/AC:H/Au:N/C:C/I:C/A:C

Temporal Vector: E:U/RL:OF/RC:C

CVSS v3

Risk Factor: High

Base Score: 7.5

Temporal Score: 6.5

Vector: CVSS:3.0/AV:N/AC:H/PR:N/UI:R/S:U/C:H/I:H/A:H

Temporal Vector: E:U/RL:O/RC:C

Vulnerability Information

CPE: p-cpe:/a:novell:opensuse:postgresql, p-cpe:/a:novell:opensuse:postgresql-contrib, p-cpe:/a:novell:opensuse:postgresql-devel, p-cpe:/a:novell:opensuse:postgresql-llvmjit, p-cpe:/a:novell:opensuse:postgresql-plperl, p-cpe:/a:novell:opensuse:postgresql-plpython, p-cpe:/a:novell:opensuse:postgresql-pltcl, p-cpe:/a:novell:opensuse:postgresql-server, p-cpe:/a:novell:opensuse:postgresql-server-devel, p-cpe:/a:novell:opensuse:postgresql-test, cpe:/o:novell:opensuse:15.2

Required KB Items: Host/local_checks_enabled, Host/SuSE/release, Host/SuSE/rpm-list

Exploit Ease: No known exploits are available

Patch Publication Date: 2/24/2021

Vulnerability Publication Date: 11/16/2020

Reference Information

CVE: CVE-2020-25694, CVE-2020-25695, CVE-2020-25696