Optional update for postgresql96

SUSE Optional Update: Optional update for postgresql96
Announcement ID: SUSE-OU-2017:1691-1
Rating: low
References: #1038474
Affected Products:
  • SUSE Linux Enterprise Server for SAP 12-SP1
  • SUSE Linux Enterprise Server for SAP 12
  • SUSE Linux Enterprise Server for Raspberry Pi 12-SP2
  • SUSE Linux Enterprise Server 12-SP2
  • SUSE Linux Enterprise Server 12-SP1-LTSS
  • SUSE Linux Enterprise Server 12-LTSS
    		•

    An update that has one optional fix can now be installed.

    Description:


    This update delivers PostgreSQL 9.6.3 to the SUSE Linux Enterprise 12
    codebase.

    Major enhancements in PostgreSQL 9.6 include:

    - Parallel execution of sequential scans, joins and aggregates
    - Avoid scanning pages unnecessarily during vacuum freeze operations
    - Synchronous replication now allows multiple standby servers for
    increased reliability
    - Full-text search can now search for phrases (multiple adjacent words)
    - postgres_fdw now supports remote joins, sorts, UPDATEs, and DELETEs
    - Substantial performance improvements, especially in the area of
    scalability on multi-CPU-socket servers.

    Version 9.6 contains a number of changes that may affect compatibility
    with previous releases. Please refer to
    https://www.postgresql.org/docs/9.6/static/release-9-6.html for a
    comprehensive list of changes.

    The existing client libraries libecpg6 and libpq5 are now taken from the
    postgresql96 build instead
    of the postgresql94 build.

    Patch Instructions:

    To install this SUSE Optional Update use YaST online_update.
    Alternatively you can run the command listed for your product:

    • SUSE Linux Enterprise Server for SAP 12-SP1:
      zypper in -t patch SUSE-SLE-SAP-12-SP1-2017-1042=1
    • SUSE Linux Enterprise Server for SAP 12:
      zypper in -t patch SUSE-SLE-SAP-12-2017-1042=1
    • SUSE Linux Enterprise Server for Raspberry Pi 12-SP2:
      zypper in -t patch SUSE-SLE-RPI-12-SP2-2017-1042=1
    • SUSE Linux Enterprise Server 12-SP2:
      zypper in -t patch SUSE-SLE-SERVER-12-SP2-2017-1042=1
    • SUSE Linux Enterprise Server 12-SP1-LTSS:
      zypper in -t patch SUSE-SLE-SERVER-12-SP1-2017-1042=1
    • SUSE Linux Enterprise Server 12-LTSS:
      zypper in -t patch SUSE-SLE-SERVER-12-2017-1042=1

    To bring your system up-to-date, use "zypper patch".

    Package List:

    • SUSE Linux Enterprise Server for SAP 12-SP1 (ppc64le x86_64):
      • libecpg6-9.6.3-2.1
      • libecpg6-debuginfo-9.6.3-2.1
      • libpq5-9.6.3-2.1
      • libpq5-debuginfo-9.6.3-2.1
      • postgresql96-9.6.3-2.4
      • postgresql96-contrib-9.6.3-2.4
      • postgresql96-contrib-debuginfo-9.6.3-2.4
      • postgresql96-debuginfo-9.6.3-2.4
      • postgresql96-debugsource-9.6.3-2.4
      • postgresql96-libs-debugsource-9.6.3-2.1
      • postgresql96-server-9.6.3-2.4
      • postgresql96-server-debuginfo-9.6.3-2.4
    • SUSE Linux Enterprise Server for SAP 12-SP1 (noarch):
      • postgresql-init-9.6-17.17.1
      • postgresql96-docs-9.6.3-2.4
    • SUSE Linux Enterprise Server for SAP 12-SP1 (x86_64):
      • libpq5-32bit-9.6.3-2.1
      • libpq5-debuginfo-32bit-9.6.3-2.1
    • SUSE Linux Enterprise Server for SAP 12 (x86_64):
      • libecpg6-9.6.3-2.1
      • libecpg6-debuginfo-9.6.3-2.1
      • libpq5-32bit-9.6.3-2.1
      • libpq5-9.6.3-2.1
      • libpq5-debuginfo-32bit-9.6.3-2.1
      • libpq5-debuginfo-9.6.3-2.1
      • postgresql96-9.6.3-2.4
      • postgresql96-contrib-9.6.3-2.4
      • postgresql96-contrib-debuginfo-9.6.3-2.4
      • postgresql96-debuginfo-9.6.3-2.4
      • postgresql96-debugsource-9.6.3-2.4
      • postgresql96-libs-debugsource-9.6.3-2.1
      • postgresql96-server-9.6.3-2.4
      • postgresql96-server-debuginfo-9.6.3-2.4
    • SUSE Linux Enterprise Server for SAP 12 (noarch):
      • postgresql-init-9.6-17.17.1
      • postgresql96-docs-9.6.3-2.4
    • SUSE Linux Enterprise Server for Raspberry Pi 12-SP2 (aarch64):
      • libecpg6-9.6.3-2.1
      • libecpg6-debuginfo-9.6.3-2.1
      • libpq5-9.6.3-2.1
      • libpq5-debuginfo-9.6.3-2.1
      • postgresql96-9.6.3-2.4
      • postgresql96-contrib-9.6.3-2.4
      • postgresql96-contrib-debuginfo-9.6.3-2.4
      • postgresql96-debuginfo-9.6.3-2.4
      • postgresql96-debugsource-9.6.3-2.4
      • postgresql96-libs-debugsource-9.6.3-2.1
      • postgresql96-server-9.6.3-2.4
      • postgresql96-server-debuginfo-9.6.3-2.4
    • SUSE Linux Enterprise Server for Raspberry Pi 12-SP2 (noarch):
      • postgresql-init-9.6-17.17.1
      • postgresql96-docs-9.6.3-2.4
    • SUSE Linux Enterprise Server 12-SP2 (aarch64 ppc64le x86_64):
      • libecpg6-9.6.3-2.1
      • libecpg6-debuginfo-9.6.3-2.1
      • libpq5-9.6.3-2.1
      • libpq5-debuginfo-9.6.3-2.1
      • postgresql96-9.6.3-2.4
      • postgresql96-contrib-9.6.3-2.4
      • postgresql96-contrib-debuginfo-9.6.3-2.4
      • postgresql96-debuginfo-9.6.3-2.4
      • postgresql96-debugsource-9.6.3-2.4
      • postgresql96-libs-debugsource-9.6.3-2.1
      • postgresql96-server-9.6.3-2.4
      • postgresql96-server-debuginfo-9.6.3-2.4
    • SUSE Linux Enterprise Server 12-SP2 (noarch):
      • postgresql-init-9.6-17.17.1
      • postgresql96-docs-9.6.3-2.4
    • SUSE Linux Enterprise Server 12-SP2 (x86_64):
      • libpq5-32bit-9.6.3-2.1
      • libpq5-debuginfo-32bit-9.6.3-2.1
    • SUSE Linux Enterprise Server 12-SP1-LTSS (ppc64le s390x x86_64):
      • libecpg6-9.6.3-2.1
      • libecpg6-debuginfo-9.6.3-2.1
      • libpq5-9.6.3-2.1
      • libpq5-debuginfo-9.6.3-2.1
      • postgresql96-9.6.3-2.4
      • postgresql96-contrib-9.6.3-2.4
      • postgresql96-contrib-debuginfo-9.6.3-2.4
      • postgresql96-debuginfo-9.6.3-2.4
      • postgresql96-debugsource-9.6.3-2.4
      • postgresql96-libs-debugsource-9.6.3-2.1
      • postgresql96-server-9.6.3-2.4
      • postgresql96-server-debuginfo-9.6.3-2.4
    • SUSE Linux Enterprise Server 12-SP1-LTSS (s390x x86_64):
      • libpq5-32bit-9.6.3-2.1
      • libpq5-debuginfo-32bit-9.6.3-2.1
    • SUSE Linux Enterprise Server 12-SP1-LTSS (noarch):
      • postgresql-init-9.6-17.17.1
      • postgresql96-docs-9.6.3-2.4
    • SUSE Linux Enterprise Server 12-LTSS (ppc64le s390x x86_64):
      • libecpg6-9.6.3-2.1
      • libecpg6-debuginfo-9.6.3-2.1
      • libpq5-9.6.3-2.1
      • libpq5-debuginfo-9.6.3-2.1
      • postgresql96-9.6.3-2.4
      • postgresql96-contrib-9.6.3-2.4
      • postgresql96-contrib-debuginfo-9.6.3-2.4
      • postgresql96-debuginfo-9.6.3-2.4
      • postgresql96-debugsource-9.6.3-2.4
      • postgresql96-libs-debugsource-9.6.3-2.1
      • postgresql96-server-9.6.3-2.4
      • postgresql96-server-debuginfo-9.6.3-2.4
    • SUSE Linux Enterprise Server 12-LTSS (s390x x86_64):
      • libpq5-32bit-9.6.3-2.1
      • libpq5-debuginfo-32bit-9.6.3-2.1
    • SUSE Linux Enterprise Server 12-LTSS (noarch):
      • postgresql-init-9.6-17.17.1
      • postgresql96-docs-9.6.3-2.4

    References: