How to get a version of pgAdmin III working correctly with the PostgreSQL 9.4 (Ubuntu 14.10 x64)?

postgresql ubuntu pgadmin
Andriy picture Andriy · Apr 22, 2015 · Viewed 21.2k times · Source

I have installed postgresql-9.4 and pgAdmin III on Ubuntu 14.10 x64:

sudo apt-get update && sudo apt-get dist-upgrade
sudo apt-get install postgresql-9.4
sudo apt-get pgadmin3

However using pgAdmin with PostgreSQL I faced with the warning

Warning: The server you are connecting to is not a version that is supported by this release of pgAdmin III.

pgAdmin III may not function as expected.

Supported server versions are 8.4 to 9.3.

1) How to get a version of pgAdmin III do I use?

2) How to uninstall current version of pgAdmin and to install the correct version of pgAdmin?

Thank you.

Answer

mivk picture mivk · Jul 23, 2015

PostgreSQL maintains a repository of apt packages. You can follow the instructions on their wiki at https://wiki.postgresql.org/wiki/Apt

Basically, they boil down to:

# add the repository
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

# install their key
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

sudo apt-get update

Then

sudo apt-get install pgadmin3

That worked fine for me on Ubuntu 12.04, and I have now pgadmin3 v. 1.20.

Related questions

Postgresql: password authentication failed for user "postgres"

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password "postgres", because it worked before. But now authentication is failed. I did it …

Read More
How to solve PostgreSQL pgAdmin error "Server instrumentation not installed" for adminpack?

PostgreSQL 9.1 pgAdmin III on Ubuntu is giving this warning: Guru Hint - Server instrumentation not installed Server Instrumentation The server lacks instrumentation functions. pgAdmin II uses some support functions that are not available by default in all PostgreSQL versions... The …

Read More
How to thoroughly purge and reinstall postgresql on ubuntu?

Somehow I've managed to completely bugger the install of postgresql on Ubuntu karmic. I want to start over from scratch, but when I "purge" the package with apt-get it still leaves traces behind such that the reinstall configuration doesn't run …

Read More