PostgreSQL updates fix bugs

The PostgreSQL developers have announced the release of version 9.1.2 of their open source relational database, a maintenance update that includes fixes for 52 bugs found in PostgreSQL 9.1. Bug fix updates have also been released for the 9.0.x, 8.4.x, 8.3.x and 8.2.x branches of PostgreSQL.

Among the corrected problems are some that could potentially cause crashes and data corruption, including an issue that occurred with certain UPDATE and INSERT calls when another statement was simultaneously modifying the same lines. Another bug affected the creation of tables from another table and the ability to copy data records between tables with columns that were stored using TOAST, resulting in corrupted target data. Most of the bugs can be fixed simply by installing the updates, but in some cases, further steps will be required.

The developers also note that 8.2.23 will be the last update for PostgreSQL 8.2 as it has now reached its end of life (EOL); those currently using the 8.2.x branch are advised to upgrade to 8.3 or later to continue receiving updates.

Further information about the updates, including a full list of changes, can be found in the 9.1.2, 9.0.6, 8.4.10, 8.3.17 and 8.2.23 release notes. The PostgreSQL updates are available to download from the project's site. The source code is made available under the terms of the PostgreSQL License, described as a liberal open source licence, similar to the BSD or MIT licences.

See also:

• PostgreSQL 9.1 with synchronous replication, a report from The H.

(crve)