postgresql-8.4 (8.4.19-0ubuntu0.12.04) precise-proposed; urgency=low
* New upstream bug fix release (LP: #1257211)
- Fix "VACUUM"'s tests to see whether it can update relfrozenxid.
In some cases "VACUUM" (either manual or autovacuum) could
incorrectly advance a table's relfrozenxid value, allowing tuples
to escape freezing, causing those rows to become invisible once
2^31 transactions have elapsed. The probability of data loss is
fairly low since multiple incorrect advancements would need to
happen before actual loss occurs, but it's not zero. Users
upgrading from release 8.4.8 or earlier are not affected, but all
later versions contain the bug.
The issue can be ameliorated by, after upgrading, vacuuming all
tables in all databases while having vacuum_freeze_table_age set to
zero. This will fix any latent corruption but will not be able to
fix all pre-existing data errors. However, an installation can be
presumed safe after performing this vacuuming if it has executed
fewer than 2^31 update transactions in its lifetime (check this
with SELECT txid_current() < 2^31).
- See HISTORY/changelog.gz for details about bug fixes.
Date: Tue, 03 Dec 2013 10:44:58 +0100
Changed-By: Martin Pitt <[email protected]>
Maintainer: Ubuntu Developers <[email protected]>
https://launchpad.net/ubuntu/precise/+source/postgresql-8.4/8.4.19-0ubuntu0.12.04
Format: 1.8
Date: Tue, 03 Dec 2013 10:44:58 +0100
Source: postgresql-8.4
Binary: postgresql-8.4 postgresql-client-8.4 postgresql-server-dev-8.4
postgresql-doc-8.4 postgresql-contrib-8.4 postgresql-plperl-8.4
postgresql-plpython-8.4 postgresql-pltcl-8.4
Architecture: source
Version: 8.4.19-0ubuntu0.12.04
Distribution: precise-proposed
Urgency: low
Maintainer: Ubuntu Developers <[email protected]>
Changed-By: Martin Pitt <[email protected]>
Description:
postgresql-8.4 - object-relational SQL database, version 8.4 server
postgresql-client-8.4 - front-end programs for PostgreSQL 8.4
postgresql-contrib-8.4 - additional facilities for PostgreSQL
postgresql-doc-8.4 - documentation for the PostgreSQL database management
system
postgresql-plperl-8.4 - PL/Perl procedural language for PostgreSQL 8.4
postgresql-plpython-8.4 - PL/Python procedural language for PostgreSQL 8.4
postgresql-pltcl-8.4 - PL/Tcl procedural language for PostgreSQL 8.4
postgresql-server-dev-8.4 - development files for PostgreSQL 8.4 server-side
programming
Launchpad-Bugs-Fixed: 1257211
Changes:
postgresql-8.4 (8.4.19-0ubuntu0.12.04) precise-proposed; urgency=low
.
* New upstream bug fix release (LP: #1257211)
- Fix "VACUUM"'s tests to see whether it can update relfrozenxid.
In some cases "VACUUM" (either manual or autovacuum) could
incorrectly advance a table's relfrozenxid value, allowing tuples
to escape freezing, causing those rows to become invisible once
2^31 transactions have elapsed. The probability of data loss is
fairly low since multiple incorrect advancements would need to
happen before actual loss occurs, but it's not zero. Users
upgrading from release 8.4.8 or earlier are not affected, but all
later versions contain the bug.
The issue can be ameliorated by, after upgrading, vacuuming all
tables in all databases while having vacuum_freeze_table_age set to
zero. This will fix any latent corruption but will not be able to
fix all pre-existing data errors. However, an installation can be
presumed safe after performing this vacuuming if it has executed
fewer than 2^31 update transactions in its lifetime (check this
with SELECT txid_current() < 2^31).
- See HISTORY/changelog.gz for details about bug fixes.
Checksums-Sha1:
0be760c65c4ae23be715e485d37db75c98a6b436 2808
postgresql-8.4_8.4.19-0ubuntu0.12.04.dsc
1a48ce09f236e889b3794b347afa5a04ef5b8679 18624056
postgresql-8.4_8.4.19.orig.tar.gz
b7ea6c0994d59105779f4d7540d970ad515023f5 49868
postgresql-8.4_8.4.19-0ubuntu0.12.04.diff.gz
Checksums-Sha256:
cebaae41277737f553c2454211ca56be912cee315dd3fd324434331321087006 2808
postgresql-8.4_8.4.19-0ubuntu0.12.04.dsc
39aebaac437ecfbcc37d67d8ab73f56e395e12a1be378b25b857e33dbf7ce657 18624056
postgresql-8.4_8.4.19.orig.tar.gz
e45d4dee2de6be3df2bd5b800498883fd301be80a23119fbd6d978fa4b5d490f 49868
postgresql-8.4_8.4.19-0ubuntu0.12.04.diff.gz
Files:
fe8a0eb4744e92fbb52106bf0e9c782a 2808 database optional
postgresql-8.4_8.4.19-0ubuntu0.12.04.dsc
7fc3587b209a0b032462b1ae440f03aa 18624056 database optional
postgresql-8.4_8.4.19.orig.tar.gz
09369d6e6d64e8a0a7f650ce7b1d5f51 49868 database optional
postgresql-8.4_8.4.19-0ubuntu0.12.04.diff.gz
Original-Maintainer: Martin Pitt <[email protected]>
--
Precise-changes mailing list
[email protected]
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/precise-changes
