[ubuntu/precise-proposed] postgresql-9.1 9.1.6-0ubuntu12.04 (Accepted)
Martin Pitt
martin.pitt at ubuntu.com
Tue Sep 25 05:55:03 UTC 2012
postgresql-9.1 (9.1.6-0ubuntu12.04) precise-proposed; urgency=low
* New upstream bug fix release: (LP: #1055944)
- Fix persistence marking of shared buffers during WAL replay.
This mistake can result in buffers not being written out during
checkpoints, resulting in data corruption if the server later
crashes without ever having written those buffers. Corruption can
occur on any server following crash recovery, but it is
significantly more likely to occur on standby slave servers since
those perform much more WAL replay. There is a low probability of
corruption of btree and GIN indexes. There is a much higher
probability of corruption of table "visibility maps". Fortunately,
visibility maps are non-critical data in 9.1, so the worst
consequence of such corruption in 9.1 installations is transient
inefficiency of vacuuming. Table data proper cannot be corrupted by
this bug.
While no index corruption due to this bug is known to have occurred
in the field, as a precautionary measure it is recommended that
production installations "REINDEX" all btree and GIN indexes at a
convenient time after upgrading to 9.1.6.
Also, if you intend to do an in-place upgrade to 9.2.X, before
doing so it is recommended to perform a "VACUUM" of all tables
while having vacuum_freeze_table_age set to zero. This will ensure
that any lingering wrong data in the visibility maps is corrected
before 9.2.X can depend on it. vacuum_cost_delay can be adjusted to
reduce the performance impact of vacuuming, while causing it to
take longer to finish.
- See HISTORY/changelog.gz for the other bug fixes.
Date: Tue, 25 Sep 2012 07:21:13 +0200
Changed-By: Martin Pitt <martin.pitt at ubuntu.com>
Maintainer: Ubuntu Developers <ubuntu-devel-discuss at lists.ubuntu.com>
https://launchpad.net/ubuntu/precise/+source/postgresql-9.1/9.1.6-0ubuntu12.04
-------------- next part --------------
Format: 1.8
Date: Tue, 25 Sep 2012 07:21:13 +0200
Source: postgresql-9.1
Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-9.1 postgresql-9.1-dbg postgresql-client-9.1 postgresql-server-dev-9.1 postgresql-doc-9.1 postgresql-contrib-9.1 postgresql-plperl-9.1 postgresql-plpython-9.1 postgresql-plpython3-9.1 postgresql-pltcl-9.1
Architecture: source
Version: 9.1.6-0ubuntu12.04
Distribution: precise-proposed
Urgency: low
Maintainer: Ubuntu Developers <ubuntu-devel-discuss at lists.ubuntu.com>
Changed-By: Martin Pitt <martin.pitt at ubuntu.com>
Description:
libecpg-compat3 - older version of run-time library for ECPG programs
libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
libecpg6 - run-time library for ECPG programs
libpgtypes3 - shared library libpgtypes for PostgreSQL 9.1
libpq-dev - header files for libpq5 (PostgreSQL library)
libpq5 - PostgreSQL C client library
postgresql-9.1 - object-relational SQL database, version 9.1 server
postgresql-9.1-dbg - debug symbols for postgresql-9.1
postgresql-client-9.1 - front-end programs for PostgreSQL 9.1
postgresql-contrib-9.1 - additional facilities for PostgreSQL
postgresql-doc-9.1 - documentation for the PostgreSQL database management system
postgresql-plperl-9.1 - PL/Perl procedural language for PostgreSQL 9.1
postgresql-plpython-9.1 - PL/Python procedural language for PostgreSQL 9.1
postgresql-plpython3-9.1 - PL/Python 3 procedural language for PostgreSQL 9.1
postgresql-pltcl-9.1 - PL/Tcl procedural language for PostgreSQL 9.1
postgresql-server-dev-9.1 - development files for PostgreSQL 9.1 server-side programming
Launchpad-Bugs-Fixed: 1055944
Changes:
postgresql-9.1 (9.1.6-0ubuntu12.04) precise-proposed; urgency=low
.
* New upstream bug fix release: (LP: #1055944)
- Fix persistence marking of shared buffers during WAL replay.
This mistake can result in buffers not being written out during
checkpoints, resulting in data corruption if the server later
crashes without ever having written those buffers. Corruption can
occur on any server following crash recovery, but it is
significantly more likely to occur on standby slave servers since
those perform much more WAL replay. There is a low probability of
corruption of btree and GIN indexes. There is a much higher
probability of corruption of table "visibility maps". Fortunately,
visibility maps are non-critical data in 9.1, so the worst
consequence of such corruption in 9.1 installations is transient
inefficiency of vacuuming. Table data proper cannot be corrupted by
this bug.
While no index corruption due to this bug is known to have occurred
in the field, as a precautionary measure it is recommended that
production installations "REINDEX" all btree and GIN indexes at a
convenient time after upgrading to 9.1.6.
Also, if you intend to do an in-place upgrade to 9.2.X, before
doing so it is recommended to perform a "VACUUM" of all tables
while having vacuum_freeze_table_age set to zero. This will ensure
that any lingering wrong data in the visibility maps is corrected
before 9.2.X can depend on it. vacuum_cost_delay can be adjusted to
reduce the performance impact of vacuuming, while causing it to
take longer to finish.
- See HISTORY/changelog.gz for the other bug fixes.
Checksums-Sha1:
2721f520100a10dc9d7b245318362cb06beb85f2 3279 postgresql-9.1_9.1.6-0ubuntu12.04.dsc
a24b7c002463572ee7371f055e566b69e39cda3e 15621370 postgresql-9.1_9.1.6.orig.tar.bz2
2cc530b05d8ec35647236a10ffcf9c6e9672c508 36576 postgresql-9.1_9.1.6-0ubuntu12.04.debian.tar.gz
Checksums-Sha256:
8b027ce7375a02b3100b686cf482b4ab3645d628d00f759c22b17bf47fd54058 3279 postgresql-9.1_9.1.6-0ubuntu12.04.dsc
6e396aca621a95b9f5f7292a79ebe6ce892e36c7f7021814e1bd94bcfc6c31e7 15621370 postgresql-9.1_9.1.6.orig.tar.bz2
0ce9ae4eb7e042cd8e8bc25c975723bb1f5ccf097e5531ca8327258ba1837d03 36576 postgresql-9.1_9.1.6-0ubuntu12.04.debian.tar.gz
Files:
0bbea5679012050aca8e264e4d26bd9a 3279 database optional postgresql-9.1_9.1.6-0ubuntu12.04.dsc
000755f66c0de58bbd4cd2b89b45b8e2 15621370 database optional postgresql-9.1_9.1.6.orig.tar.bz2
a4416bfb6cf0f27aa453cb5c036fc625 36576 database optional postgresql-9.1_9.1.6-0ubuntu12.04.debian.tar.gz
Original-Maintainer: Martin Pitt <mpitt at debian.org>
More information about the Precise-changes
mailing list