Postgres released version 9.1 beta 1 today! This is a preview of 9.1, predicted to be available in the next 2-3 months, not a bugfix release for earlier versions of Postgres.
PostgreSQL 9.1 contains a huge volume of new features, possibly more any single release of PostgreSQL before. These features also include several innovations which PostgreSQL is the first database system to have. The most anticipated features in this version include:
- Synchronous Replication
- Per-column collations for multilingual databases
- Unlogged Fast Tables
- K-Nearest-Neighbor Indexing
- Serializable Snapshot Isolation
- Writeable Common Table Expressions
- SE-Linux Integration
- SQL/MED attached tables
The PostgreSQL project now depends on you to test 9.1beta1 in order have a rapid and bug-free 9.1 release. If you are able to help with testing version 9.1, please see the Beta Testing HOWTO
If you’d like to grab a copy of the latest from git, here is a quick set of instructions to compile 9.1beta1 from the git repo:
git checkout REL9_1_BETA1 ./configure --prefix=/opt/pg9.1beta1 make sudo make install
And then to create a database:
/opt/pg9.1beta1/bin/initdb -D mytestdb /opt/pg9.1beta1/bin/pg_ctl -D mytestdb start
For a preview of features coming this fall, check out Depesz’s blog.