SUSE-RU-2012:1365-1: important: Recommended update for PostgreSQL

[sle-updates at lists.suse.com]

   SUSE Recommended Update: Recommended update for PostgreSQL
______________________________________________________________________________

Announcement ID:    SUSE-RU-2012:1365-1
Rating:             important
References:         #782251 
Affected Products:
                    SUSE Linux Enterprise Software Development Kit 11 SP2
                    SUSE Linux Enterprise Server 11 SP2 for VMware
                    SUSE Linux Enterprise Server 11 SP2
                    SUSE Linux Enterprise Desktop 11 SP2
______________________________________________________________________________

   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
   <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.novell.com/patch/finder/?keywords=e21eb545afd1ed13932e4a18773cd494