How to Install PgAdmin4 on Ubuntu 18 04

Linux

Install and configure PgAdmin4 on ubuntu 18.04

Pgadmin is web-based interface that allows you to administer and manage PostgreSQL database instances in a web browser.It can be installed on Linux, Unix, Mac and Windows to manage PostgreSQL 9.2 and above.You can use pgAdmin to do all from writing basic SQL queries to monitoring your databases and configuring advanced database architectures.

Before installing PgAdmin4 make sure install postgresql server in your ubuntu system.if you don't have postgresql in your server please follow our article to install it.

Also Read -> Install postgresql 12 on ubuntu 18.04

First we will check postgresql service status and also make sure apache service is running.

root@ubuntu18:~# systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
   Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
   Active: active (exited) since Tue 2020-01-28 09:01:24 UTC; 50min ago
 Main PID: 1476 (code=exited, status=0/SUCCESS)
    Tasks: 0 (limit: 1670)
   CGroup: /system.slice/postgresql.service

root@ubuntu18:~# systemctl status apache2
● apache2.service - The Apache HTTP Server
   Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled)
  Drop-In: /lib/systemd/system/apache2.service.d
           └─apache2-systemd.conf
   Active: active (running) since Tue 2020-01-28 09:18:07 UTC; 36min ago

Also Read -> How to Install PHP 8 on Centos 8

Step 1: Install pgadmin4

root@ubuntu18:~# apt-get install pgadmin4 pgadmin4-apache2

The package pgadmin4-apache2 will integrate pgAdmin4 with Apache2 web server.

During installation of packages, you will be prompted for an email address. enter your preferred email address and click on ok.

Next, provide password to login for administrator account for login to pgadmin4.

then setup will continue and it will complete the installation of pgAdmin4 on your system.
 
Also Read -> How to Install Flask on Ubuntu 20 04

Step 2: connect postgresql via pgadmin4

Now you can access pgAdmin4 in your favorite web browser.use your system ip address followed by /pgadmin4.

http://192.168.0.15/pgadmin4

give your email id and password provided during installation process and login.

That's it.Now you have successfully installed pgadmin4 on ubuntu 18.04 system

Also Read -> How to Install Apache Kafka on Ubuntu 20 04