see http://www.postgresql.org/about/news/1415/ for further information about the new features.
To install it in ubuntu you could use Martin Pitt’s ppa under https://launchpad.net/~pitti/+archive/postgresql
sudo apt-add-repository ppa:pitti/postgresql sudo apt-get update sudo apt-get dist-upgrade sudo apt-get install postgresql-9.2 postgresql-client-9.2
WARNING: This won’t upgrade your 9.1 if you’ve already installed that. Of course you could get rid of your database with apt-get remove. But you’ll have to migrate your data manually!
NOTICE: To avoid autostart of postgre just make
sudo update-rc.d -f postgresql remove