PostgreSql 9.4 on Ubuntu 14.04 (trusty)

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!

One thought on “PostgreSql 9.4 on Ubuntu 14.04 (trusty)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s