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

high Nessus Plugin ID 146831

Language:

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

Type: local

Agent: unix

Published: 2/25/2021

Updated: 5/10/2022

Supported Sensors: Frictionless Assessment Agent, Frictionless Assessment AWS, Frictionless Assessment Azure, Nessus Agent, Nessus

Risk Information

VPR

Risk Factor: Medium

Score: 5.9

CVSS v2

Risk Factor: High

Base Score: 7.6

Temporal Score: 5.6

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

CVSS Score Source: CVE-2020-25696

CVSS v3

Risk Factor: High

Base Score: 8.8

Temporal Score: 7.7

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

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

CVSS Score Source: CVE-2020-25695

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