Release 8.4

Release Date

2009-07-01

After many years of development, PostgreSQL™ has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards. The major areas of enhancement are:

The above items are explained in more detail in the sections below.

A dump/restore using pg_dump is required for those wishing to migrate data from any previous release.

Observe the following incompatibilities:

Below you will find a detailed account of the changes between PostgreSQL™ 8.4 and the previous major release.