Hamsa K
3 min read | 6 months ago

How to Install PgAdmin4 on Ubuntu 18 04

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.

First we will check postgresql srvice 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
   Active: active (running) since Tue 2020-01-28 09:18:07 UTC; 36min ago

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.

Step 2: connect postgresql via pgadmin4

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

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





Warning! This site uses cookies
By continuing to browse the site, you are agreeing to our use of cookies. Read our terms and privacy policy