How to Install Pgadmin in Ubuntu

I. Problem

How to install the PGAdmin on Ubuntu-powered machine.

II. Solution

# Edit debian package list
# Open this file
sudo vi /etc/apt/sources.list

# Add this at the end of the line
deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main

# Execute in terminal
sudo wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt update

# Install the following components
sudo apt install python3-dev pgadmin4-common pgadmin4-apache2 pgadmin4

III. Alternatives

In Ubuntu 20 and up, this installation procedure might not work due to a conflict in python3-psycopg2 dependency, if so you can choose to run PGAdmin inside a docker container.

Todo so execute the line  below:

docker run -e PGADMIN_DEFAULT_EMAIL=<> /
-e PGADMIN_DEFAULT_PASSWORD=<> / 
-p 8080:80 dpage/pgadmin4

And finally, fire-up a browser and open up HTTP://localhost:8080, use the email/password you specify in the parameter to login.