How to install PgAdmin3 version 1.20.0 in Ubuntu 14.04

Solution 1:

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.

Solution 2:

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