Security update for postgresql94

Announcement ID: SUSE-SU-2017:1690-1
Rating: moderate
References:
Cross-References:
CVSS scores:
  • CVE-2017-7484 ( NVD ): 7.5 CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N
  • CVE-2017-7485 ( NVD ): 5.9 CVSS:3.0/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:H/A:N
  • CVE-2017-7486 ( NVD ): 7.5 CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N
Affected Products:
  • SUSE Linux Enterprise Desktop 12 SP2
  • SUSE Linux Enterprise High Performance Computing 12 SP2
  • SUSE Linux Enterprise Server 12 SP2
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2
  • SUSE Linux Enterprise Server for the Raspberry Pi 12-SP2
  • SUSE Linux Enterprise Software Development Kit 12 12-SP2

An update that solves three vulnerabilities can now be installed.

Description:

This update for postgresql94 to 9.4.12 fixes the following issues:

Upstream changelogs:

  • https://www.postgresql.org/docs/9.4/static/release-9-4-12.html
  • https://www.postgresql.org/docs/9.4/static/release-9-4-11.html
  • https://www.postgresql.org/docs/9.4/static/release-9-4-10.html

Security issues fixed:

  • CVE-2017-7486: Restrict visibility of pg_user_mappings.umoptions, to protect passwords stored as user mapping options. (bsc#1037624)

Please note that manual action is needed to fix this in existing databases See the upstream release notes for details. * CVE-2017-7485: recognize PGREQUIRESSL variable again. (bsc#1038293) * CVE-2017-7484: Prevent exposure of statistical information via leaky operators. (bsc#1037603)

Changes in version 9.4.12:

  • Build corruption with CREATE INDEX CONCURRENTLY
  • Fixes for visibility and write-ahead-log stability

Changes in version 9.4.10:

  • Fix WAL-logging of truncation of relation free space maps and visibility maps
  • Fix incorrect creation of GIN index WAL records on big-endian machines
  • Fix SELECT FOR UPDATE/SHARE to correctly lock tuples that have been updated by a subsequently-aborted transaction
  • Fix EvalPlanQual rechecks involving CTE scans
  • Fix improper repetition of previous results from hashed aggregation in a subquery

The libraries libpq and libecpg are now supplied by postgresql 9.6.

Patch Instructions:

To install this SUSE 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 Linux Enterprise Desktop 12 SP2
    zypper in -t patch SUSE-SLE-DESKTOP-12-SP2-2017-1039=1
  • SUSE Linux Enterprise Server for the Raspberry Pi 12-SP2
    zypper in -t patch SUSE-SLE-RPI-12-SP2-2017-1039=1
  • SUSE Linux Enterprise Software Development Kit 12 12-SP2
    zypper in -t patch SUSE-SLE-SDK-12-SP2-2017-1039=1
  • SUSE Linux Enterprise High Performance Computing 12 SP2
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-2017-1039=1
  • SUSE Linux Enterprise Server 12 SP2
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-2017-1039=1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-2017-1039=1

Package List:

  • SUSE Linux Enterprise Desktop 12 SP2 (x86_64)
    • postgresql94-debuginfo-9.4.12-20.1
    • postgresql94-debugsource-9.4.12-20.1
    • postgresql94-9.4.12-20.1
  • SUSE Linux Enterprise Server for the Raspberry Pi 12-SP2 (aarch64)
    • postgresql94-server-debuginfo-9.4.12-20.1
    • postgresql94-contrib-9.4.12-20.1
    • postgresql94-debuginfo-9.4.12-20.1
    • postgresql94-contrib-debuginfo-9.4.12-20.1
    • postgresql94-debugsource-9.4.12-20.1
    • postgresql94-9.4.12-20.1
    • postgresql94-server-9.4.12-20.1
  • SUSE Linux Enterprise Server for the Raspberry Pi 12-SP2 (noarch)
    • postgresql94-docs-9.4.12-20.1
  • SUSE Linux Enterprise Software Development Kit 12 12-SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql94-libs-debugsource-9.4.12-20.1
    • postgresql94-devel-9.4.12-20.1
    • postgresql94-devel-debuginfo-9.4.12-20.1
  • SUSE Linux Enterprise High Performance Computing 12 SP2 (aarch64 x86_64)
    • postgresql94-server-debuginfo-9.4.12-20.1
    • postgresql94-contrib-9.4.12-20.1
    • postgresql94-debuginfo-9.4.12-20.1
    • postgresql94-contrib-debuginfo-9.4.12-20.1
    • postgresql94-debugsource-9.4.12-20.1
    • postgresql94-9.4.12-20.1
    • postgresql94-server-9.4.12-20.1
  • SUSE Linux Enterprise High Performance Computing 12 SP2 (noarch)
    • postgresql94-docs-9.4.12-20.1
  • SUSE Linux Enterprise Server 12 SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql94-server-debuginfo-9.4.12-20.1
    • postgresql94-contrib-9.4.12-20.1
    • postgresql94-debuginfo-9.4.12-20.1
    • postgresql94-contrib-debuginfo-9.4.12-20.1
    • postgresql94-debugsource-9.4.12-20.1
    • postgresql94-9.4.12-20.1
    • postgresql94-server-9.4.12-20.1
  • SUSE Linux Enterprise Server 12 SP2 (noarch)
    • postgresql94-docs-9.4.12-20.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2 (ppc64le x86_64)
    • postgresql94-server-debuginfo-9.4.12-20.1
    • postgresql94-contrib-9.4.12-20.1
    • postgresql94-debuginfo-9.4.12-20.1
    • postgresql94-contrib-debuginfo-9.4.12-20.1
    • postgresql94-debugsource-9.4.12-20.1
    • postgresql94-9.4.12-20.1
    • postgresql94-server-9.4.12-20.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2 (noarch)
    • postgresql94-docs-9.4.12-20.1

References: