[ubuntu/precise-proposed] postgresql-8.4 8.4.19-0ubuntu0.12.04 (Accepted)

[Martin Pitt]

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 <martin.pitt at ubuntu.com>
Maintainer: Ubuntu Developers <ubuntu-devel-discuss at lists.ubuntu.com>
https://launchpad.net/ubuntu/precise/+source/postgresql-8.4/8.4.19-0ubuntu0.12.04
-------------- next part --------------
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 <ubuntu-devel-discuss at lists.ubuntu.com>
Changed-By: Martin Pitt <martin.pitt at ubuntu.com>
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 <mpitt at debian.org>