PostgreSQL 9.4 has many awesome new features, especially its support for
jsonb data format. Unfortunately there is no 9.4 packages by default in apt repository of Ubuntu 14.04 LTS. We have to install PostgreSQL 9.4 on Ubuntu 14.04 via PostgreSQL their own repository.
1 Add repository
First of all, create a new apt repository entry file under
$ sudo touch /etc/apt/sources.list.d/pgdg.list
The new list file name is not sensitive, but make sure the file extension is
Secondly, add the official repository to the new source list file. Copy following line and paste it into
pgdg.list file created above.
# postgresql official package repository deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main
Or, just execute following command to append the repository to the new source list file.
$ echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" >> /etc/apt/sources.list.d/pgdg.list
Then import the accessing GPG key for this repository.
$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \ sudo apt-key add -
Update the packages information:
$ sudo apt-get update
Now is ready to install PostgreSQL 9.4 by apt.
$ sudo apt-get install postgresql-9.4
All steps complete!