Upgrade to PostgreSQL 9.4 in Ubuntu 14.04
June 21, 2015
PostgreSQL 9.4 includes many great features. The main one we’ve been leveraging is the jsonb field type. Currently the latest LTS version of Ubuntu (14.04), includes postgresql-9.3. Here is how to upgrade to PostgreSQL 9.4, including how to upgrade existing database clusters.
Install the package
Add PostgreSQL 9.4 repository
Import repository signing key, and update the package lists
Install PostgreSQL 9.4 and pgAdmin III
Confirm Version
Check version of existing database
Upgrade existing PostgreSQL 9.3 database cluster(s)
Check current clusters
Stop PostgreSQL 9.4 cluster & drop it
Upgrade PostgreSQL 9.3 cluster to 9.4
Drop PostgreSQL 9.3 cluster
Confirm only 9.4 cluster remains
Credits for the above: