Skip site navigation (1) Skip section navigation (2)

PostgreSQL pg_upgrade bugfix 2011-04-18 release

From: Selena Deckelmann <selena(at)postgresql(dot)org>
To: pgsql-announce(at)postgresql(dot)org
Subject: PostgreSQL pg_upgrade bugfix 2011-04-18 release
Date: 2011-04-18 15:16:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
The PostgreSQL Global Development Group today released bugfix 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

The issue with pg_upgrade and the fix are detailed on the PostgreSQL
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 version 9.0 with 64-bit MinGW

See the release notes for each version at 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:

- Main download page:
- Source code:
- Binary packages:
- One-click installer, including Windows packages:

pgsql-announce by date

Next:From: Pavel GolubDate: 2011-04-19 10:20:02
Subject: MicroOLAP Database Designer for PostgreSQL 1.8.0 Beta 2 available
Previous:From: David FetterDate: 2011-04-18 01:54:25
Subject: == PostgreSQL Weekly News - April 17 2011 ==

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group