How do I install/update to Postgres 9.4?

Question

You can add it from the instructions in the page

http://www.postgresql.org/download/linux/ubuntu/

• Create the file /etc/apt/sources.list.d/pgdg.list, and add a line for the repository

  deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main
  

• Import the repository signing key, and update the package lists

  wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
  sudo apt-get update && sudo apt-get install postgresql-9.4
  

postgresql-9.4 is not available in 14.04 "Trusty". It was added in 14.10 "Utopic". It may be back ported in the future.

The directions on the PostgreSQL Ubuntu Download page are missing a command. Their wiki guide has the correct procedure. You must run apt-get update before trying to install. This will cause the system to read changes to the sources.

If you're trying to install on Ubuntu 14.04 "Trusty", you can follow these steps:

To check your version:

$ lsb_release -a

No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 14.04.3 LTS
Release:    14.04
Codename:   trusty

1) Create new apt repo file for postgres

$ echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" > /etc/apt/sources.list.d/pgdg.list

2) Import repository signing key and update packages list

$ sudo wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
$ sudo apt-get update

3) Install Postgres

$ sudo apt-get install postgresql-9.4

credit: http://ubuntuhandbook.org/index.php/2014/02/install-postgresql-ubuntu-14-04/

Below are steps to install PostgreSQL 9.4 on Ubuntu 14.04.

Reference taken from this Article:

First, check the version of Ubuntu:

lsb_release -sc

You need to add the latest PostgreSQL repository for the latest version, otherwise It will install PostgreSQL 9.3. This is for trusty version.

sudo add-apt-repository "deb https://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main"

Update and Install PostgreSQL 9.4:

sudo apt-get update
sudo apt-get install postgresql-9.4

Default postgres super user and postgres database is created. You need to set a password for the postgres super user.

ubuntu@:~$ sudo passwd postgres
Enter new UNIX password:****
Retype new UNIX password:****
passwd: password updated successfully

If service is not started, you can start the PostgreSQL service.

sudo service postgresql start

Connect PostgreSQL server using postgres user:

ubuntu@:~$ su postgres
Password:****

Create a sample database:

createdb database_name

Connect to that database:

psql -d database_name