Bug 7770

Summary:	[Update Request]Update postgresql packages to fix several potential data corruption issues [mga1]
Product:	Mageia	Reporter:	claire robinson <eeeemail>
Component:	RPM Packages	Assignee:	QA Team <qa-bugs>
Status:	RESOLVED FIXED	QA Contact:
Severity:	normal
Priority:	High	CC:	davidwhodgins, ed_rus099, fundawang, sysadmin-bugs, tmb
Version:	1	Keywords:	validated_update
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:	MGA1-64-OK MGA1-32-OK
Source RPM:		CVE:
Status comment:
Bug Depends on:
Bug Blocks:	7854

Description claire robinson 2012-10-11 18:35:56 CEST

The PostgreSQL Global Development Group has released an update to all current
versions of the PostgreSQL database system, including 9.2.1, 9.1.6, 9.0.10,
8.4.14 and 8.3.21. This update fixes critical issues for major versions 9.1 and
9.2, and users running those versions should apply it as soon as possible.
Users of versions 8.3, 8.4 and 9.0 should plan to update at the next scheduled
downtime.

The update fixes two potential data corruption issues present in the PostgreSQL
9.1 and 9.2 for any server which has crashed, been shutdown with "immediate",
or was failed over to a standby. First, the PostgreSQL development team has
discovered a chance of corruption of BTREE and GIN indexes for databases.
Second, there is a significant chance of corruption of the visibility map. This
update fixes both issues.




This update is for Mageia 1 ONLY. See bug 7583 for Mageia 2 packages.

SRPMS:
postgresql8.4-8.4.14-1.mga1
postgresql9.0-9.0.10-1.mga1

claire robinson 2012-10-11 18:37:36 CEST

CC: (none) => ed_rus099, fundawang

Comment 1 Samuel Verschelde 2012-10-18 22:58:16 CEST

testing postgresql9.0 ok MGA1, 32 bits. Using it on Mageia App Db's database goes well.

Samuel Verschelde 2012-10-18 22:59:21 CEST

Priority: Normal => High

Comment 2 Thomas Backlund 2012-10-21 01:57:26 CEST

Testing postgresql9.0 ok MGA1, 64 bits.
Using it on alamut since ~5 days wich carries db for wiki, bugs, and other stuff . No problem so far.

CC: (none) => tmb

Thomas Backlund 2012-10-21 01:58:00 CEST

Blocks: (none) => 7854

Comment 3 Dave Hodgins 2012-10-22 21:52:48 CEST

Testing complete for postgresql8.4 and 9.0 on Mageia 1 i586.

Could someone from the sysadmin team push the srpms
postgresql8.4-8.4.14-1.mga1
postgresql9.0-9.0.10-1.mga1
from Mageia 1 Core Updates Testing to Core Updates.

Advisory: This update fixes two potential data corruption issues present
in the PostgreSQL server which has crashed, been shutdown with "immediate",
or was failed over to a standby. First, the PostgreSQL development team has
discovered a chance of corruption of BTREE and GIN indexes for databases.
Second, there is a significant chance of corruption of the visibility map.
This update fixes both issues

https://bugs.mageia.org/show_bug.cgi?id=7770

Keywords: (none) => validated_update
CC: (none) => davidwhodgins, sysadmin-bugs
Whiteboard: (none) => MGA1-64-OK MGA1-32-OK

Comment 4 Thomas Backlund 2012-10-23 00:18:33 CEST

Update pushed:
https://wiki.mageia.org/en/Support/Advisories/MGAA-2012-0212

Status: NEW => RESOLVED
Resolution: (none) => FIXED