openSUSE Recommended Update: postgres: bugfix update to version 9.1.7 ______________________________________________________________________________ Announcement ID: openSUSE-RU-2013:0125-1 Rating: low References: #794766 Affected Products: openSUSE 12.2 openSUSE 12.1 ______________________________________________________________________________ An update that has one recommended fix can now be installed. Description: This release of postgresql 9.1.7 fixes a significant page ordering issue with Hot Standby which could cause index corruption on the standby under some circumstances. In addition, this update patches timing issues with checkpoint and transaction ID wraparound which could cause data corruption in some cases. This update also fixes multiple issues with CREATE INDEX CONCURRENTLY and DROP INDEX CONCURRENTLY, which can cause those commands to fail or produce corrupt indexes. Users who use this feature may want to REINDEX or recreate affected indexes (bnc#794766) Patch Instructions: To install this openSUSE Recommended Update use YaST online_update. Alternatively you can run the command listed for your product: - openSUSE 12.2: zypper in -t patch openSUSE-2013-34 - openSUSE 12.1: zypper in -t patch openSUSE-2013-34 To bring your system up-to-date, use "zypper patch". Package List: - openSUSE 12.2 (i586 x86_64): libecpg6-9.1.7-12.1 libecpg6-debuginfo-9.1.7-12.1 libpq5-9.1.7-12.1 libpq5-debuginfo-9.1.7-12.1 postgresql91-9.1.7-12.1 postgresql91-contrib-9.1.7-12.1 postgresql91-contrib-debuginfo-9.1.7-12.1 postgresql91-debuginfo-9.1.7-12.1 postgresql91-debugsource-9.1.7-12.1 postgresql91-devel-9.1.7-12.1 postgresql91-devel-debuginfo-9.1.7-12.1 postgresql91-libs-debugsource-9.1.7-12.1 postgresql91-plperl-9.1.7-12.1 postgresql91-plperl-debuginfo-9.1.7-12.1 postgresql91-plpython-9.1.7-12.1 postgresql91-plpython-debuginfo-9.1.7-12.1 postgresql91-pltcl-9.1.7-12.1 postgresql91-pltcl-debuginfo-9.1.7-12.1 postgresql91-server-9.1.7-12.1 postgresql91-server-debuginfo-9.1.7-12.1 - openSUSE 12.2 (x86_64): libecpg6-32bit-9.1.7-12.1 libecpg6-debuginfo-32bit-9.1.7-12.1 libpq5-32bit-9.1.7-12.1 libpq5-debuginfo-32bit-9.1.7-12.1 postgresql91-devel-32bit-9.1.7-12.1 postgresql91-devel-debuginfo-32bit-9.1.7-12.1 - openSUSE 12.2 (noarch): postgresql91-docs-9.1.7-12.1 - openSUSE 12.1 (i586 x86_64): libecpg6-9.1.7-17.1 libecpg6-debuginfo-9.1.7-17.1 libpq5-9.1.7-17.1 libpq5-debuginfo-9.1.7-17.1 postgresql91-9.1.7-17.1 postgresql91-contrib-9.1.7-17.1 postgresql91-contrib-debuginfo-9.1.7-17.1 postgresql91-debuginfo-9.1.7-17.1 postgresql91-debugsource-9.1.7-17.1 postgresql91-devel-9.1.7-17.1 postgresql91-devel-debuginfo-9.1.7-17.1 postgresql91-libs-debugsource-9.1.7-17.1 postgresql91-plperl-9.1.7-17.1 postgresql91-plperl-debuginfo-9.1.7-17.1 postgresql91-plpython-9.1.7-17.1 postgresql91-plpython-debuginfo-9.1.7-17.1 postgresql91-pltcl-9.1.7-17.1 postgresql91-pltcl-debuginfo-9.1.7-17.1 postgresql91-server-9.1.7-17.1 postgresql91-server-debuginfo-9.1.7-17.1 - openSUSE 12.1 (x86_64): libecpg6-32bit-9.1.7-17.1 libecpg6-debuginfo-32bit-9.1.7-17.1 libpq5-32bit-9.1.7-17.1 libpq5-debuginfo-32bit-9.1.7-17.1 postgresql91-devel-32bit-9.1.7-17.1 postgresql91-devel-debuginfo-32bit-9.1.7-17.1 - openSUSE 12.1 (noarch): postgresql91-docs-9.1.7-17.1 - openSUSE 12.1 (ia64): libecpg6-debuginfo-x86-9.1.7-17.1 libecpg6-x86-9.1.7-17.1 libpq5-debuginfo-x86-9.1.7-17.1 libpq5-x86-9.1.7-17.1 postgresql91-devel-debuginfo-x86-9.1.7-17.1 References: https://bugzilla.novell.com/794766