Ubuntu: How to install PgAdmin3 version 1.20.0 in Ubuntu 14.04



Question:

I try to install using PPA

First, I add a link to a file repository source.list directory the /etc/apt/sources.list

$ Sudo nano /etc/apt/sources.list       deb http://ppa.launchpad.net/pitti/postgresql/ubuntu precise play     deb-src http://ppa.launchpad.net/pitti/postgresql/ubuntu precise play  

Secondly I did update the repository with the command

$ Sudo apt-get update  

although there is an error

: W: GPG error: precise http://ppa.launchpad.net Release: The following signatures could not be verified Because The public key is not available: NO_PUBKEY 99B656EA8683D8A2  

I added a way to overcome the apt-key, create a folder Key1 contains the code on the link below code key1

then I run the command

$ Sudo apt-key add / directory / key1  

succeed

I tried to update the back third repository

$ Sudo apt-get update  

succeed

four I try to run the following command to install pgadmin3 vs. 1.20.0

$ Sudo apt-get install pgadmin3  

yet installed fixed vs. 1.18.0 how do I fix it?


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  

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »