pgAdmin Upgrade

The Ubuntu repositories do not contain the latest version pgAdmin. Here I will show you how to get the latest stable version on your Ubuntu system.

Open a terminal window so that we can add the GPG Key used to sign the packages:

$ sudo wget -q -O – http://www.pgadmin.org/pgp/archive_key_debian_ubuntu.gpg | apt-key add -

We then need to add the actual repository into your repository list. To do this, you need to go to the Mirror List and choose the mirror closest to you. Once you have followed the links all the way down, your URL should look something like this: ftp://ftp.za.postgresql.org/mirror/ftp.postgresql.org/pgadmin3/release/ubuntu. This is the South African mirror.

To add the mirror to your repositories list, open “Software Sources” under “System -> Administration -> Software Sources” from the Gnome menu bar. In the above menu of the “Software Sources” screen go to “Settings -> Repositories” and then click on the “Third Party Software” tab. Click on the “Add” button and enter the following in “APT Line” field where “[MIRROR URL]“ is the mirror you chose:

deb [MIRROR URL]/pgadmin3/release/ubuntu feisty pgadmin

In your Terminal window you can the enter the following:

$ sudo apt-get update
$ sudo apt-get install pgadmin3

There, now you have the latest stable version of pgAdmin :)

Leave a Reply