_$: apt-get install pgadmin3


We will install a new version of PostgreSQL and a new version of pgadmin too. The current version of PostgreSQL will be reachable on port 5432 and the new one on port 5433

_$: $ pgadmin3 --version
pgAdmin III 1.18.1

_$: service postgresql status
9.3/main (port 5432): online

_$: lsb_release -cs
deb trusty-pgdg main
_$: wget --quiet -O - | sudo apt-key add -
_$: sudo apt-get update
_$: sudo apt-get upgrade
_$: sudo apt-get install postgresql-9.5 pgadmin3


_$: pgadmin3 --version
pgAdmin III 1.22.1

_$: service postgresql status
9.3/main (port 5432): online
9.5/main (port 5433): online

Accept incoming connections

Our database server is located at and we have to configure it to accept incoming connections from hosts in the same network (

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all               md5
host    all             all             md5
_$: service postgresql restart


In pgAdminIII go to Add a connection to a server

Name: development
Port: 5432
Service: -
Maintenance DB: postgres
Username: <user>