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