Security update for postgresql96

SUSE Security Update: Security update for postgresql96
Announcement ID: SUSE-SU-2018:1695-1
Rating: moderate
References: #1091610
Affected Products:
  • SUSE Linux Enterprise Software Development Kit 12-SP3
  • SUSE Linux Enterprise Server 12-SP3
  • SUSE Linux Enterprise Desktop 12-SP3

  • An update that fixes one vulnerability is now available.

    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 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:

    • 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 Desktop 12-SP3:
      zypper in -t patch SUSE-SLE-DESKTOP-12-SP3-2018-1138=1

    Package List:

    • 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):
      • libecpg6-9.6.9-3.19.1
      • libecpg6-debuginfo-9.6.9-3.19.1
      • libpq5-9.6.9-3.19.1
      • libpq5-debuginfo-9.6.9-3.19.1
      • postgresql96-9.6.9-3.19.1
      • postgresql96-contrib-9.6.9-3.19.1
      • postgresql96-contrib-debuginfo-9.6.9-3.19.1
      • postgresql96-debuginfo-9.6.9-3.19.1
      • postgresql96-debugsource-9.6.9-3.19.1
      • postgresql96-libs-debugsource-9.6.9-3.19.1
      • postgresql96-server-9.6.9-3.19.1
      • postgresql96-server-debuginfo-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 Server 12-SP3 (noarch):
      • postgresql96-docs-9.6.9-3.19.1
    • SUSE Linux Enterprise Desktop 12-SP3 (x86_64):
      • libecpg6-9.6.9-3.19.1
      • libecpg6-debuginfo-9.6.9-3.19.1
      • libpq5-32bit-9.6.9-3.19.1
      • libpq5-9.6.9-3.19.1
      • libpq5-debuginfo-32bit-9.6.9-3.19.1
      • libpq5-debuginfo-9.6.9-3.19.1
      • postgresql96-9.6.9-3.19.1
      • postgresql96-debuginfo-9.6.9-3.19.1
      • postgresql96-debugsource-9.6.9-3.19.1
      • postgresql96-libs-debugsource-9.6.9-3.19.1

    References: