How to install PgAdmin3 version 1.20.0 in Ubuntu 14.04

That is because, as mentioned in the PPA page, the PPA is deprecated and will NOT receive ANY UPDATES any more. The 'latest' version available in that PPA is 1.18.1-1.

If you want the latest version, checkout the repository maintained by The PostgreSQL Global Development Group (PGDG). In short,

Create /etc/apt/sources.list.d/pgdg.list and put the following contents:

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

Import repository key, update and install the packages:

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

There is also a shell script that will automate repository setup.

Refer documentation for more information.


Why do you use Precise repositories in Trusty? pgadmin3 is in the Ubuntu repositories for Trusty and so on.

Therefore remove the lines

deb http://ppa.launchpad.net/pitti/postgresql/ubuntu precise play
deb-src http://ppa.launchpad.net/pitti/postgresql/ubuntu precise play

from your sources.list and install with

sudo apt-get update
sudo apt-get install pgadmin3

To install version 1.20.0~beta2-1 you need at least Vivid or another PPA:

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

Check with

% apt-cache policy pgadmin3
pgadmin3:
  Installed: (none)
  Candidate: 1.20.0-1.pgdg14.04+1
  Version table:
     1.20.0-1.pgdg14.04+1 0
        500 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main i386 Packages

And install

sudo apt-get update
sudo apt-get install --reinstall pgadmin3