Er zijn updates verschenen voor versies 8.2, 8.3, 8.4 en 9.0 van PostgreSQL. Dit populaire 'opensource relational database management system' draait op een groot aantal besturingssystemen en is daardoor uitstekend inzetbaar in diverse omgevingen. De updates bevatten een groot aantal bugfixes, waaronder een fix voor een ernstig probleem met de pg_upgrade utility. Upgraden wordt dan ook aangeraden. Dit is de aankondiging van deze uitgave:
PostgreSQL pg_upgrade bugfix 2011-04-18 release
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.
- fix build issues on HP-UX and Itanium
- update time zone files for recent time zone changes
- change SQLSTATE for Hot Standby warnings
- prevent bgwriter hang during recovery
- prevent recursive composite type creation
- disallow dropping tables whose triggers are still pending
- allow use of "replication" as a user name
- prevent a crash during GEQO planning
- improve join plans for tables with missing statistics
- fix error with SELECT FOR UPDATE in a subselect
- close PL/python array slice memory leak
- allow SSL connections for users with no home directory
- allow building PostgreSQL 9.0 with 64-bit MinGW
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 thanone 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.
PostgreSQL screenshot, klik op de afbeelding voor een grotere versie.
:fill(white):strip_exif()/i/1395573402.jpeg?f=thumbmedium)
/u/102469/crop60633f8b439f1_cropped.png?f=community){kind=small}