Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 377
Andriy Avatar asked Apr 22 '15 15:04

Andriy


People also ask

How do I connect PostgreSQL to pgAdmin 3?

Connecting to a Database with pgAdmin IIIAfter running OpenVPN as administrator and establishing a connection you should also run pgAdmin III. Establish a new connection from File -> Add Server… menu (the first icon in the toolbar). Enter the details to connect to the database in the New Server Registration window.


2 Answers

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.

like image 62
mivk Avatar answered Oct 08 '22 11:10

mivk


It seems to be a known bug: link

The bug thread suggests to try and use pgAdmin 1.20. You can download it here: link

like image 25
Robin Nabel Avatar answered Oct 08 '22 09:10

Robin Nabel