09 February 2009, 16:34

PostgreSQL updates fix bugs

The developers of the open source database PostgreSQL have released updates to fix several bugs found in versions 7.4, 8.0, 8.1, 8.2 and 8.3. Users of the affected versions are advised to update as soon as possible. Only versions 8.2.12 and 8.3.6 of the Windows binaries are being released as 8.0 and 8.1 are no longer supported on Windows.

PostgreSQL 8.1.16 fixes a serious bug with Autovacuum, which will fail when XID rollover is required. The VACUUM function releases the unused disk space. Version 8.3.6 corrects a serious bug that can lead to data loss if CLUSTER with GiST indexes (such as full text indexes) are used.

All updates also include patches for several low-risk security holes and other minor fixes depending upon the version. The release notes contain a complete list of changes for each version. The new versions can be found on the PostgreSQL project website. As the updates are minor releases, users are not required to dump and reload their database in order to apply the update releases.

See also: