Add REPLICATION privilege for ROLEs.  This makes it possible for replication
to be performed by a non-superuser account.

Support unlogged tables.  The contents of an unlogged table are WAL-logged;
thus, they are not available on standby servers and are truncated whenever
the database system enters recovery.  Indexes on unlogged tables are
also unlogged.  Unlogged GiST indexes are not currently supported.

Support RIGHT and FULL OUTER JOIN in hash joins.

Allow casting a table's row type to the table's supertype if it's a typed
table.  This is analogous to the existing facility that allows casting a
row type to a supertable's row type.

Foreign tables.

Implement remaining fields of information_schema.sequences view.

Add a "conflicts" column to pg_stat_database, and a new view
pg_stat_database conflicts.

New system view pg_stat_replication.

Fix GIN to support null keys, empty and null items, and full index scans.

Teach GIN to combine duplicate keys even across different quals.

Server support for streaming base backups.  New client, pg_basebackup.

Many PL/python improvements and clenaups, including explicit
subtransactions, better error reporting, custom SPI exceptions,
and quoting functions.

Log replication connections only when log_connections is on.

Avoid detoast in texteq/textne/byteaeq/byteane for unequal-length strings.

Add a new psql command \dL to list languages.

New contrib module pg_test_fsync, based on the old src/tools/test_fsync

Allow the wal_buffers setting to be auto-tuned to a reasonable value.

Add 'directory' format to pg_dump.

sepgsql, an SE-Linux integration for PostgreSQL.

ALTER TABLE ADD UNIQUE/PRIMARY KEY USING INDEX

Try to compact the fsync request queue when it overflows, instead of doing
an fsync per block.

Log restartpoints in the same fashion as checkpoints.

Implement genuine serializable isolation level.

If an autovacuum worker, other than one performing an anti-wraparound vacuum,
is unable to obtain a lock on the target related, skip it, to avoid pinning
down a worker.  The next cycle will try again.

ALTER TABLE .. ADD FOREIGN KEY .. NOT VALID and ALTER TABLE .. VALIDATE
CONSTRAINT.

Recovery control functions.  Change behavior to pause at recovery target,
if there is one.

Named restore points.

Per-column collation support.

Extensions.

Track time of last statistics reset on databases and bgwriter.

Send status updates from streaming replication clients back to the master.

Teach ALTER TABLE .. SET DATA TYPE to avoid some table rewrites.

Hot standby feedback.

Convert PostgreSQL arrays to Perl arrays on PL/perl input arguments.

Add transaction-level advisory locks.

Make ecpg accept dynamic cursor names even in WHERE CURRENT OF clauses.

Set psql client encoding from locale by default

Support for foreign tables and foreign data wrappers.  file_fdw.

Add ENCODING option to COPY TO/FROM.

Allow binary I/O of type "void".

Fix pageinspect's heap_page_item function to return infomasks as 32 bit values.

Rearrange snapshot handling to make rule expansion more consistent.

Change pg_last_xlog_receive_location() not to move backwards.

Add KNNGIST support to contrib/btree_gist.

Support data-modifying CTEs.