Installing PostgreSQL using Advanced Package Tool

Advanced Package Tool (APT) is used to handle the installation and removal of software on Debian and Debian-based distributions, such as the Ubuntu operating system.

As stated earlier, recent PostgreSQL binaries might not yet be integrated with the official Debian and Ubuntu repositories. To set up the PostgreSQL apt repository on Debian or Ubuntu, execute the following:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.PostgreSQL.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update

After adding a new apt repository, it's good to upgrade your system as follows:

sudo apt-get upgrade