Optional update for postgresql96

Announcement ID: SUSE-OU-2017:1691-1
Rating: low
References:
Affected Products:
  • SUSE Linux Enterprise High Performance Computing 12 SP2
  • SUSE Linux Enterprise Server 12
  • SUSE Linux Enterprise Server 12 LTSS 12
  • SUSE Linux Enterprise Server 12 SP1
  • SUSE Linux Enterprise Server 12 SP1 LTSS 12-SP1
  • SUSE Linux Enterprise Server 12 SP2
  • SUSE Linux Enterprise Server for SAP Applications 12
  • SUSE Linux Enterprise Server for SAP Applications 12 SP1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2
  • SUSE Linux Enterprise Server for the Raspberry Pi 12-SP2

An update that has one 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 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 Server for the Raspberry Pi 12-SP2
    zypper in -t patch SUSE-SLE-RPI-12-SP2-2017-1042=1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP1
    zypper in -t patch SUSE-SLE-SAP-12-SP1-2017-1042=1
  • SUSE Linux Enterprise Server for SAP Applications 12
    zypper in -t patch SUSE-SLE-SAP-12-2017-1042=1
  • SUSE Linux Enterprise Server 12 LTSS 12
    zypper in -t patch SUSE-SLE-SERVER-12-2017-1042=1
  • SUSE Linux Enterprise Server 12 SP1 LTSS 12-SP1
    zypper in -t patch SUSE-SLE-SERVER-12-SP1-2017-1042=1
  • SUSE Linux Enterprise High Performance Computing 12 SP2
    zypper in -t patch SUSE-SLE-SERVER-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 for SAP Applications 12 SP2
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-2017-1042=1

Package List:

  • SUSE Linux Enterprise Server for the Raspberry Pi 12-SP2 (aarch64)
    • postgresql96-debuginfo-9.6.3-2.4
    • postgresql96-contrib-debuginfo-9.6.3-2.4
    • postgresql96-9.6.3-2.4
    • postgresql96-libs-debugsource-9.6.3-2.1
    • libpq5-9.6.3-2.1
    • postgresql96-debugsource-9.6.3-2.4
    • postgresql96-server-debuginfo-9.6.3-2.4
    • libecpg6-9.6.3-2.1
    • postgresql96-contrib-9.6.3-2.4
    • libecpg6-debuginfo-9.6.3-2.1
    • postgresql96-server-9.6.3-2.4
    • libpq5-debuginfo-9.6.3-2.1
  • SUSE Linux Enterprise Server for the Raspberry Pi 12-SP2 (noarch)
    • postgresql-init-9.6-17.17.1
    • postgresql96-docs-9.6.3-2.4
  • SUSE Linux Enterprise Server for SAP Applications 12 SP1 (ppc64le x86_64)
    • postgresql96-debuginfo-9.6.3-2.4
    • postgresql96-contrib-debuginfo-9.6.3-2.4
    • postgresql96-9.6.3-2.4
    • postgresql96-libs-debugsource-9.6.3-2.1
    • libpq5-9.6.3-2.1
    • postgresql96-debugsource-9.6.3-2.4
    • postgresql96-contrib-9.6.3-2.4
    • libecpg6-9.6.3-2.1
    • postgresql96-server-debuginfo-9.6.3-2.4
    • libecpg6-debuginfo-9.6.3-2.1
    • postgresql96-server-9.6.3-2.4
    • libpq5-debuginfo-9.6.3-2.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP1 (noarch)
    • postgresql-init-9.6-17.17.1
    • postgresql96-docs-9.6.3-2.4
  • SUSE Linux Enterprise Server for SAP Applications 12 SP1 (x86_64)
    • libpq5-debuginfo-32bit-9.6.3-2.1
    • libpq5-32bit-9.6.3-2.1
  • SUSE Linux Enterprise Server for SAP Applications 12 (x86_64)
    • postgresql96-debuginfo-9.6.3-2.4
    • postgresql96-contrib-debuginfo-9.6.3-2.4
    • postgresql96-9.6.3-2.4
    • postgresql96-libs-debugsource-9.6.3-2.1
    • libpq5-debuginfo-32bit-9.6.3-2.1
    • libpq5-9.6.3-2.1
    • postgresql96-debugsource-9.6.3-2.4
    • postgresql96-contrib-9.6.3-2.4
    • libecpg6-9.6.3-2.1
    • postgresql96-server-debuginfo-9.6.3-2.4
    • libpq5-32bit-9.6.3-2.1
    • libecpg6-debuginfo-9.6.3-2.1
    • postgresql96-server-9.6.3-2.4
    • libpq5-debuginfo-9.6.3-2.1
  • SUSE Linux Enterprise Server for SAP Applications 12 (noarch)
    • postgresql-init-9.6-17.17.1
    • postgresql96-docs-9.6.3-2.4
  • SUSE Linux Enterprise Server 12 LTSS 12 (ppc64le s390x x86_64)
    • postgresql96-debuginfo-9.6.3-2.4
    • postgresql96-contrib-debuginfo-9.6.3-2.4
    • postgresql96-9.6.3-2.4
    • postgresql96-libs-debugsource-9.6.3-2.1
    • libpq5-9.6.3-2.1
    • postgresql96-debugsource-9.6.3-2.4
    • postgresql96-contrib-9.6.3-2.4
    • libecpg6-9.6.3-2.1
    • postgresql96-server-debuginfo-9.6.3-2.4
    • libecpg6-debuginfo-9.6.3-2.1
    • postgresql96-server-9.6.3-2.4
    • libpq5-debuginfo-9.6.3-2.1
  • SUSE Linux Enterprise Server 12 LTSS 12 (noarch)
    • postgresql-init-9.6-17.17.1
    • postgresql96-docs-9.6.3-2.4
  • SUSE Linux Enterprise Server 12 LTSS 12 (s390x x86_64)
    • libpq5-debuginfo-32bit-9.6.3-2.1
    • libpq5-32bit-9.6.3-2.1
  • SUSE Linux Enterprise Server 12 SP1 LTSS 12-SP1 (ppc64le s390x x86_64)
    • postgresql96-debuginfo-9.6.3-2.4
    • postgresql96-contrib-debuginfo-9.6.3-2.4
    • postgresql96-9.6.3-2.4
    • postgresql96-libs-debugsource-9.6.3-2.1
    • libpq5-9.6.3-2.1
    • postgresql96-debugsource-9.6.3-2.4
    • postgresql96-contrib-9.6.3-2.4
    • libecpg6-9.6.3-2.1
    • postgresql96-server-debuginfo-9.6.3-2.4
    • libecpg6-debuginfo-9.6.3-2.1
    • postgresql96-server-9.6.3-2.4
    • libpq5-debuginfo-9.6.3-2.1
  • SUSE Linux Enterprise Server 12 SP1 LTSS 12-SP1 (noarch)
    • postgresql-init-9.6-17.17.1
    • postgresql96-docs-9.6.3-2.4
  • SUSE Linux Enterprise Server 12 SP1 LTSS 12-SP1 (s390x x86_64)
    • libpq5-debuginfo-32bit-9.6.3-2.1
    • libpq5-32bit-9.6.3-2.1
  • SUSE Linux Enterprise High Performance Computing 12 SP2 (aarch64 x86_64)
    • postgresql96-debuginfo-9.6.3-2.4
    • postgresql96-contrib-debuginfo-9.6.3-2.4
    • postgresql96-9.6.3-2.4
    • postgresql96-libs-debugsource-9.6.3-2.1
    • libpq5-9.6.3-2.1
    • postgresql96-debugsource-9.6.3-2.4
    • postgresql96-contrib-9.6.3-2.4
    • libecpg6-9.6.3-2.1
    • postgresql96-server-debuginfo-9.6.3-2.4
    • libecpg6-debuginfo-9.6.3-2.1
    • postgresql96-server-9.6.3-2.4
    • libpq5-debuginfo-9.6.3-2.1
  • SUSE Linux Enterprise High Performance Computing 12 SP2 (noarch)
    • postgresql-init-9.6-17.17.1
    • postgresql96-docs-9.6.3-2.4
  • SUSE Linux Enterprise High Performance Computing 12 SP2 (x86_64)
    • libpq5-debuginfo-32bit-9.6.3-2.1
    • libpq5-32bit-9.6.3-2.1
  • SUSE Linux Enterprise Server 12 SP2 (aarch64 ppc64le s390x x86_64)
    • postgresql96-debuginfo-9.6.3-2.4
    • postgresql96-contrib-debuginfo-9.6.3-2.4
    • postgresql96-9.6.3-2.4
    • postgresql96-libs-debugsource-9.6.3-2.1
    • libpq5-9.6.3-2.1
    • postgresql96-debugsource-9.6.3-2.4
    • postgresql96-contrib-9.6.3-2.4
    • libecpg6-9.6.3-2.1
    • postgresql96-server-debuginfo-9.6.3-2.4
    • libecpg6-debuginfo-9.6.3-2.1
    • postgresql96-server-9.6.3-2.4
    • libpq5-debuginfo-9.6.3-2.1
  • 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 (s390x x86_64)
    • libpq5-debuginfo-32bit-9.6.3-2.1
    • libpq5-32bit-9.6.3-2.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2 (ppc64le x86_64)
    • postgresql96-debuginfo-9.6.3-2.4
    • postgresql96-contrib-debuginfo-9.6.3-2.4
    • postgresql96-9.6.3-2.4
    • postgresql96-libs-debugsource-9.6.3-2.1
    • libpq5-9.6.3-2.1
    • postgresql96-debugsource-9.6.3-2.4
    • postgresql96-contrib-9.6.3-2.4
    • libecpg6-9.6.3-2.1
    • postgresql96-server-debuginfo-9.6.3-2.4
    • libecpg6-debuginfo-9.6.3-2.1
    • postgresql96-server-9.6.3-2.4
    • libpq5-debuginfo-9.6.3-2.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2 (noarch)
    • postgresql-init-9.6-17.17.1
    • postgresql96-docs-9.6.3-2.4
  • SUSE Linux Enterprise Server for SAP Applications 12 SP2 (x86_64)
    • libpq5-debuginfo-32bit-9.6.3-2.1
    • libpq5-32bit-9.6.3-2.1

References: