Quick and dirty install notes to get PostgreSql 9.4 on Ubuntu 14.04 (trusty)

I’m pretty sure PostgreSql 9.4 is already in Ubuntu 14.10 (utopic) but I’m sticking with “trusty” for now but would like the latest and greatest PostgreSQL.

This post will be similar to an earlier post on PostgreSql and Ubuntu which can be found here. The difference is that I want to pull PostgreSql directly from the repository at PostgreSql.org

Become root
sudo -s

Make sure “trusty” is up to date. Reboot if you have to or if you get a new kernel
aptitude update
aptitude dist-upgrade

Add the postgresql.org repository to your apt configuration
echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list

Get the postgresql.org signature key
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

Run aptitude update again so it pulls info from postgresql.org
aptitude update

Install PostgreSql-9.4
aptitude install --with-recommends postgresql-9.4 postgresql-contrib-9.4

If you are running the desktop version of Ubuntu and want the GUI grap pgadmin3, too.
aptitude install --with-recommends pgadmin3

Now you have PostgreSql 9.4 on the Long Term Stable (LTS) version of Ubuntu!