The PostgreSQL Global Development Group today released bug fix updates for all active branches of the PostgreSQL database system, including versions 9.0.4, 8.4.8, 8.3.15 and 8.2.21. This update contains a critical fix to the pg_upgrade utility which prevents significant downtime issues. Do not use pg_upgrade without installing this update first.
The issue with pg_upgrade and the fix are detailed on the PostgreSQL wiki: http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix. Users who have already used pg_upgrade should run the database repair script given on that page on their databases as soon as possible.
In addition to pg_upgrade, the following fixes are included in the update. Not all fixes affect all versions.
See the release notes for each version at http://www.postgresql.org/docs/current/static/release.html for a full list of changes with details.
As with other minor releases, users are not required to dump and reload their database in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users skipping more than
one update may need to check the release notes for extra, post-update steps. Users who have previously used pg_upgrade or pg_migrator to upgrade their databases need to run the script detailed on the wiki page.
Download new versions now:
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.