How to Install PgAdmin 4 Debian 10

pgAdmin is an open-source, powerful and feature-rich graphical user interface (GUI) administration and management tool for PostgreSQL database. Currently, it supports PostgreSQL 9.2 or later, and runs on Unix and its variants such as Linux, Mac OS X as well as Windows operating systems.

It provides a powerful user interface that enables you to easily create, manage, maintain and use database objects, by both beginners and experienced Postgres users alike.

pgAdmin 4 is a major release (and a complete rewrite) of pgAdmin, built using Python and Javascript/jQuery, and a desktop runtime written in C++ with Qt. pgAdmin 4 immensely enhances on pgAdmin 3 with updated user interface(UI) elements, multi-user/web deployment options, dashboards, and more modern and elegant design.

In this article, we will show you how to install pgAdmin 4 on Debian 10 system to provide secure, remote access to PostgreSQL databases.

This guide assumes that you already have PostgreSQL 9.2 or higher installed and configured on your Debian 10 server, otherwise to install it, follows our guide: How to Install PostgreSQL 11 on Debian 10.

Installing pgAdmin 4 in Debian 10

Debian 10 ships with pgAdmin 3 by default. To install pgAdmin 4, you need to enable the PostgreSQL Global Development Group (PGDG) APT repositoryv(which contains PostgreSQL packages for Debian and Ubuntu) on your system.

# apt-get install curl ca-certificates gnupg
# curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -

Then create a repository file called /etc/apt/sources.list.d/pgdg.list.

# vim /etc/apt/sources.list.d/pgdg.list

And add the following line in the file.

deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main

Save the changes and exit the file.

Now update the APT package cache (which is a mandatory step), and install the pgAdmin 4 package as follows. The pgadmin4-apache2 package is the WSGI application.

# apt-get update
# apt-get install pgadmin4  pgadmin4-apache2
Install Pgadmin 4 on Debian 10

Install Pgadmin 4 on Debian 10

During the package installation, you will be asked to set an email address for the pgAdmin web interface initial user account. This email will work as the account name, provide it and press Enter.

Add Email to PgAdmin

Add Email to PgAdmin

You will also be asked to set a password for the pgadmin4 initial user account. Provide a secure and strong password, then click Enter to proceed.

Set Pgadmin User Password

Set Pgadmin User Password

Once the packages are installed, the installer activates systemd to start the Apache2 service and enables it to automatically start at system startup, every time the system is rebooted.

You can check the status of the service with the following command to ensure that it is up and running.

# systemctl status apache2 
Check Apache2 Status

Check Apache2 Status

On Debian 10, pgAdmin 4 WSGI application is configured to work with Apache HTTP server by default using the /etc/apache2/conf-available/pgadmin4.conf configuration file.

Before you can access the pgadmin4 web interface, if you have the UFW firewall running (it is usually disabled by default), you need to open port 80 (HTTP) to allow incoming traffic on Apache service as follows.

# ufw allow 80
# ufw allow 443
# ufw status

Accessing the pgAdmin 4 Web Interface

Now you can access the pgAdmin 4 web interface. Open a web browser and point it to the following address and click Enter.

http://SERVER_IP/pgadmin4
OR
http://localhost/pgadmin4

Once the pgAdmin 4 web login interface appears, enter the email address and password that you set earlier on to authenticate. Then click Login.

Pgadmin Login

Pgadmin Login

After a successful login, you will land at the pgAdmin4 web interface default dashboard. To connect to a database server, click on Add New Server.

Pgadmin Dashboard

Pgadmin Dashboard

Then add the new server connection name and a comment. And click on the Connection Tab to provide the connection details I.e hostname, database name, database username, and password as shown in the following screenshot. Once you are done, click Save.

Pgadmin New Server Connection Name

Pgadmin New Server Connection Name

Pgadmin New Connection Details

Pgadmin New Connection Details

Under the Browser tree, you should now have at least one server connection showing the connection name, number of databases, roles, and table space. Double click on the Database link to view server performance overview under the Dashboard.

Pgadmin Server Performance Overview

Pgadmin Server Performance Overview

pgAdmin Homepage: https://www.pgadmin.org/

That’s all! pgAdmin 4 vastly improves on pgAdmin 3 with several new features, improvements and bug fixes. In this guide, we showed how to install and configure pgAdmin 4 on Debian 10 server. If you have any queries, reach us via the comment form below.

Best Affordable Linux and WordPress Services For Your Business
Outsource Your Linux and WordPress Project and Get it Promptly Completed Remotely and Delivered Online.

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.45/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Aaron Kili

Aaron Kili is a Linux and F.O.S.S enthusiast, an upcoming Linux SysAdmin, web developer, and currently a content creator for TecMint who loves working with computers and strongly believes in sharing knowledge.

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

You may also like...

Got something to say? Join the discussion.

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.