Release Notes: There are several major new features in this release, including synchronous replication and other replication features, per-column collations, unlogged tables, extensions, K-Nearest-Neighbor indexing, Serializable Snapshot Isolation, Writeable Common Table Expressions, SE-Postgres (Military-grade security), the PostgreSQL Extension Network, and SQL/MED (Management of External Data), with foreign data wrappers for Oracle, MySQL, CouchDB, Redis, CSV, Twitter, and more. There have also been improvements in performance and database administration, and several SQL and PL/PgSQL features.
Release Notes: This is a bugfix release that fixes issues with pg_upgrade, non-hot-standby recovery, deadlock issues with catalog cache initialization, updates to time zone data files, and several other minor bugs.
Release Notes: Built-in replication based on log shipping. Easier database object permissions management. pg_upgrade to support in-place upgrades. Multiple performance enhancements for specific types of queries. Full support for 64-bit Windows.
Release Notes: This is a security release, plus 48 minor bugfixes.
Release Notes: This is a bugfix release.
Release Notes: Parallel Database Restore, speeding up recovery from backup up to 8 times. Per-Column Permissions, allowing more granular control of sensitive data. Per-database Collation Support, making PostgreSQL more useful in multi-lingual environments. In-place Upgrades through pg_migrator (beta), enabling upgrades from 8.3 to 8.4 without extensive downtime. New Query Monitoring Tools, giving administrators more insight into query activity. Greatly reduced VACUUM overhead through the Visibility Map. New monitoring tools for current queries, query load, and deadlocks.
Release Notes: This release prevents error recursion crashes when encoding conversion fails, disallows CREATE CONVERSION with the wrong encodings for the specified conversion function, and fixes xpath() to not modify the path expression unless necessary, and to make a saner attempt at it when necessary.
Release Notes: pg_get_ruledef() now parenthesizes negative constants. ALTER AGGREGATE ... OWNER TO was made to update pg_shdepend.
Release Notes: A privilege escalation exploit in SECURITY DEFINER functions was patched.
Release Notes: The server has been changed to reject invalidly-encoded multi-byte characters in all cases. This release rejects unsafe uses of \' in string literals. libpq's string-escaping routines have been modified to be aware of encoding considerations and standard_conforming_strings.