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