Installing pgAdmin 4

pgAdmin 4 will make managing PostgreSQL much easier if you are new to relational databases. The web-based GUI will allow you to view your data and allow you to visually create tables. To install pgAdmin 4, take the following steps:

1. You need to add the repository to Ubuntu. The following commands should be added to the repository:

   wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
   sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
   sudo apt update
   sudo apt install pgadmin4 pgadmin4-apache2 -y

2. You will be prompted to enter an email address for a username and then for a password. You should see the following screen:

   Figure 2.27 – Creating a user for pgAdmin 4

3. When the install has completed, you can browse to http://localhost/pgadmin4 and you will be presented with the login screen, as shown in the following...