The PostgreSQL 9.0 release is out. It has a lot of new stuff, including hot standby support, streaming replication, better permissions management, and a lot more. See the release notes for more information.