PostgreSQL 9.4

Major features

Backend changes

WAL changes

Data types

Added:

SQL changes

General

  • views
    • check_option option added (commit 4cbe3ac3)
  • REPLICA IDENTITY
    • table-level parameter to control logical replication (initial commit 07cacba9)
  • WITH ORDINALITY syntax added (commit c62736cc)

Modified:

System catalogue changes

Tables

Modified:

Views

Added:

Modified:

System function changes

Added:

Modified:

Configuration changes

Added:

Modified:

Replication changes

Replication configuration changes

Added:

Foreign data wrapper changes

Server utilities

Modified:

  • initdb
    • now throws error for incorrect locale settings, instead of silently falling back to a default setting (commit 31a26323)
  • pg_xlogdump
    • --follow option added, making it possible to report a live log stream

Core utilities

Added:

Modified:

psql

No new features were added to psql in this release.

Contrib modules

Added:

Modified:

  • auto_explain
    • option auto_explain.log_trigger added, which logs trigger execution time (commit e2a0fc53)
  • file_fdw
    • force_null option added (commit 3b5e03dc)
  • pgcrypto
    • function gen_random_uuid() added (commit e6170126)
  • pgstattuple
    • functions converted to use regclass types as the argument (commit 1dc11866)
  • pg_upgrade
    • -u/--user options renamed to -U/--username for consistency with other utilties (commit 457d6cf0)
    • memory consumption significantly reduced (commit 2a2e40aa)
  • postgres_fdw
    • extended pushdown of VARCHAR columns through improved handling of collation-related decisions (commit 76f965ff)
  • uuid-ossp
    • support for BSD and e2fsprogs UUID libraries added (commit b8cc8f94)