Recommended update for PostgreSQL
SUSE Recommended Update: Recommended update for PostgreSQL
This update provides PostgreSQL 9.1.6, which includes fixes
for issues that could have caused data corruption.
* For the full list of changes, see
http://www.postgresql.org/docs/9.1/static/release.html
* Fix persistence marking of shared buffers during WAL
replay.
* Fix planner's assignment of executor parameters, and
fix executor's rescan logic for CTE plan nodes.
* Fix misbehavior when default_transaction_isolation is
set to serializable.
* Improve selectivity estimation for text search
queries involving prefixes, i.e. "word":* patterns.
* Improve page-splitting decisions in GiST indexes.
* Fix cascading privilege revoke to stop if privileges
are still held.
* Disallow extensions from containing the schema they
are assigned to.
* Improve error messages for Hot Standby
misconfiguration errors.
* Make configure probe for mbstowcs_l.
* Fix handling of SIGFPE when PL/Perl is in use.
* Prevent PL/Perl from crashing if a recursive PL/Perl
function is redefined while being executed.
* Work around possible misoptimization in PL/Perl.
* Fix bugs in "contrib/pg_trgm"'s LIKE pattern analysis
code.
* Remove unnecessary dependency on pg_config from
pg_upgrade.
Users who upgrade from a previous 9.1 release should run
VACUUM and/or and/or index rebuilds after applying this
update. See also:
http://wiki.postgresql.org/wiki/20120924updaterelease
| Announcement ID: | SUSE-RU-2012:1365-1 |
| Rating: | important |
| References: | #782251 |
| Affected Products: |
An update that has one recommended fix can now be installed.
Description:
This update provides PostgreSQL 9.1.6, which includes fixes
for issues that could have caused data corruption.
* For the full list of changes, see
http://www.postgresql.org/docs/9.1/static/release.html
* Fix persistence marking of shared buffers during WAL
replay.
* Fix planner's assignment of executor parameters, and
fix executor's rescan logic for CTE plan nodes.
* Fix misbehavior when default_transaction_isolation is
set to serializable.
* Improve selectivity estimation for text search
queries involving prefixes, i.e. "word":* patterns.
* Improve page-splitting decisions in GiST indexes.
* Fix cascading privilege revoke to stop if privileges
are still held.
* Disallow extensions from containing the schema they
are assigned to.
* Improve error messages for Hot Standby
misconfiguration errors.
* Make configure probe for mbstowcs_l.
* Fix handling of SIGFPE when PL/Perl is in use.
* Prevent PL/Perl from crashing if a recursive PL/Perl
function is redefined while being executed.
* Work around possible misoptimization in PL/Perl.
* Fix bugs in "contrib/pg_trgm"'s LIKE pattern analysis
code.
* Remove unnecessary dependency on pg_config from
pg_upgrade.
Users who upgrade from a previous 9.1 release should run
VACUUM and/or and/or index rebuilds after applying this
update. See also:
http://wiki.postgresql.org/wiki/20120924updaterelease
Patch Instructions:
To install this SUSE Recommended Update use YaST online_update.
Alternatively you can run the command listed for your product:
- SUSE Linux Enterprise Software Development Kit 11 SP2:
zypper in -t patch sdksp2-postgresql-201209-6892 - SUSE Linux Enterprise Server 11 SP2 for VMware:
zypper in -t patch slessp2-postgresql-201209-6892 - SUSE Linux Enterprise Server 11 SP2:
zypper in -t patch slessp2-postgresql-201209-6892 - SUSE Linux Enterprise Desktop 11 SP2:
zypper in -t patch sledsp2-postgresql-201209-6892
To bring your system up-to-date, use "zypper patch".
Package List:
- SUSE Linux Enterprise Software Development Kit 11 SP2 (i586 ia64 ppc64 s390x x86_64):
- postgresql91-devel-9.1.6-0.4.1
- SUSE Linux Enterprise Server 11 SP2 for VMware (i586 x86_64):
- libecpg6-9.1.6-0.4.1
- libpq5-9.1.6-0.4.1
- postgresql91-9.1.6-0.4.1
- postgresql91-contrib-9.1.6-0.4.1
- postgresql91-docs-9.1.6-0.4.1
- postgresql91-server-9.1.6-0.4.1
- SUSE Linux Enterprise Server 11 SP2 for VMware (x86_64):
- libpq5-32bit-9.1.6-0.4.1
- SUSE Linux Enterprise Server 11 SP2 (i586 ia64 ppc64 s390x x86_64):
- libecpg6-9.1.6-0.4.1
- libpq5-9.1.6-0.4.1
- postgresql91-9.1.6-0.4.1
- postgresql91-contrib-9.1.6-0.4.1
- postgresql91-docs-9.1.6-0.4.1
- postgresql91-server-9.1.6-0.4.1
- SUSE Linux Enterprise Server 11 SP2 (ppc64 s390x x86_64):
- libpq5-32bit-9.1.6-0.4.1
- SUSE Linux Enterprise Server 11 SP2 (ia64):
- libpq5-x86-9.1.6-0.4.1
- SUSE Linux Enterprise Desktop 11 SP2 (i586 x86_64):
- libecpg6-9.1.6-0.4.1
- libpq5-9.1.6-0.4.1
- postgresql91-9.1.6-0.4.1
- SUSE Linux Enterprise Desktop 11 SP2 (x86_64):
- libpq5-32bit-9.1.6-0.4.1
References:
- https://bugzilla.novell.com/782251
- http://download.suse.com/patch/finder/?keywords=e21eb545afd1ed13932e4a18773cd494