Optional update for postgresql96
Announcement ID: | SUSE-OU-2017:1691-1 |
---|---|
Rating: | low |
References: | |
Affected Products: |
|
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