Security update for postgresql96

Announcement ID: SUSE-SU-2018:1695-1
Rating: moderate
References:
Cross-References:
CVSS scores:
  • CVE-2018-1115 ( NVD ): 9.1 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:H/A:H
  • CVE-2018-1115 ( NVD ): 9.1 CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:H/A:H
Affected Products:
  • SUSE Linux Enterprise Desktop 12 SP3
  • SUSE Linux Enterprise High Performance Computing 12 SP3
  • SUSE Linux Enterprise Server 12 SP3
  • SUSE Linux Enterprise Server for SAP Applications 12 SP3
  • SUSE Linux Enterprise Software Development Kit 12 SP3

An update that solves one vulnerability can now be installed.

Description:

PostgreSQL was updated to 9.6.9 fixing bugs and security issues:

Release notes:

  • https://www.postgresql.org/about/news/1851/
  • https://www.postgresql.org/docs/current/static/release-9-6-9.html

A dump/restore is not required for those running 9.6.X. However, if you use the adminpack extension, you should update it as per the first changelog entry below. Also, if the function marking mistakes mentioned in the second and third changelog entries below affect you, you will want to take steps to correct your database catalogs.

Security issue fixed:

  • CVE-2018-1115: Remove public execute privilege from contrib/adminpack's pg_logfile_rotate() function pg_logfile_rotate() is a deprecated wrapper for the core function pg_rotate_logfile(). When that function was changed to rely on SQL privileges for access control rather than a hard-coded superuser check, pg_logfile_rotate() should have been updated as well, but the need for this was missed. Hence, if adminpack is installed, any user could request a logfile rotation, creating a minor security issue. After installing this update, administrators should update adminpack by performing ALTER EXTENSION adminpack UPDATE in each database in which adminpack is installed. (bsc#1091610)

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 SP3
    zypper in -t patch SUSE-SLE-DESKTOP-12-SP3-2018-1138=1
  • SUSE Linux Enterprise Software Development Kit 12 SP3
    zypper in -t patch SUSE-SLE-SDK-12-SP3-2018-1138=1
  • SUSE Linux Enterprise Server 12 SP3
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-2018-1138=1
  • SUSE Linux Enterprise High Performance Computing 12 SP3
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-2018-1138=1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP3
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-2018-1138=1

Package List:

  • SUSE Linux Enterprise Desktop 12 SP3 (x86_64)
    • postgresql96-9.6.9-3.19.1
    • postgresql96-debugsource-9.6.9-3.19.1
    • libpq5-debuginfo-9.6.9-3.19.1
    • libecpg6-9.6.9-3.19.1
    • libpq5-32bit-9.6.9-3.19.1
    • libpq5-debuginfo-32bit-9.6.9-3.19.1
    • libecpg6-debuginfo-9.6.9-3.19.1
    • postgresql96-libs-debugsource-9.6.9-3.19.1
    • postgresql96-debuginfo-9.6.9-3.19.1
    • libpq5-9.6.9-3.19.1
  • SUSE Linux Enterprise Software Development Kit 12 SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql96-devel-9.6.9-3.19.1
    • postgresql96-devel-debuginfo-9.6.9-3.19.1
    • postgresql96-libs-debugsource-9.6.9-3.19.1
  • SUSE Linux Enterprise Server 12 SP3 (aarch64 ppc64le s390x x86_64)
    • postgresql96-contrib-debuginfo-9.6.9-3.19.1
    • postgresql96-9.6.9-3.19.1
    • postgresql96-debugsource-9.6.9-3.19.1
    • libpq5-debuginfo-9.6.9-3.19.1
    • libecpg6-9.6.9-3.19.1
    • libecpg6-debuginfo-9.6.9-3.19.1
    • postgresql96-server-debuginfo-9.6.9-3.19.1
    • postgresql96-libs-debugsource-9.6.9-3.19.1
    • postgresql96-debuginfo-9.6.9-3.19.1
    • postgresql96-server-9.6.9-3.19.1
    • postgresql96-contrib-9.6.9-3.19.1
    • libpq5-9.6.9-3.19.1
  • SUSE Linux Enterprise Server 12 SP3 (noarch)
    • postgresql96-docs-9.6.9-3.19.1
  • SUSE Linux Enterprise Server 12 SP3 (s390x x86_64)
    • libpq5-32bit-9.6.9-3.19.1
    • libpq5-debuginfo-32bit-9.6.9-3.19.1
  • SUSE Linux Enterprise High Performance Computing 12 SP3 (aarch64 x86_64)
    • postgresql96-contrib-debuginfo-9.6.9-3.19.1
    • postgresql96-9.6.9-3.19.1
    • postgresql96-debugsource-9.6.9-3.19.1
    • libpq5-debuginfo-9.6.9-3.19.1
    • libecpg6-9.6.9-3.19.1
    • libecpg6-debuginfo-9.6.9-3.19.1
    • postgresql96-server-debuginfo-9.6.9-3.19.1
    • postgresql96-libs-debugsource-9.6.9-3.19.1
    • postgresql96-debuginfo-9.6.9-3.19.1
    • postgresql96-server-9.6.9-3.19.1
    • postgresql96-contrib-9.6.9-3.19.1
    • libpq5-9.6.9-3.19.1
  • SUSE Linux Enterprise High Performance Computing 12 SP3 (noarch)
    • postgresql96-docs-9.6.9-3.19.1
  • SUSE Linux Enterprise High Performance Computing 12 SP3 (x86_64)
    • libpq5-32bit-9.6.9-3.19.1
    • libpq5-debuginfo-32bit-9.6.9-3.19.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP3 (ppc64le x86_64)
    • postgresql96-contrib-debuginfo-9.6.9-3.19.1
    • postgresql96-9.6.9-3.19.1
    • postgresql96-debugsource-9.6.9-3.19.1
    • libpq5-debuginfo-9.6.9-3.19.1
    • libecpg6-9.6.9-3.19.1
    • libecpg6-debuginfo-9.6.9-3.19.1
    • postgresql96-server-debuginfo-9.6.9-3.19.1
    • postgresql96-libs-debugsource-9.6.9-3.19.1
    • postgresql96-debuginfo-9.6.9-3.19.1
    • postgresql96-server-9.6.9-3.19.1
    • postgresql96-contrib-9.6.9-3.19.1
    • libpq5-9.6.9-3.19.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP3 (noarch)
    • postgresql96-docs-9.6.9-3.19.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP3 (x86_64)
    • libpq5-32bit-9.6.9-3.19.1
    • libpq5-debuginfo-32bit-9.6.9-3.19.1

References: