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.

If you liked this article, then do subscribe to email alerts for Linux tutorials. If you have any questions or doubts? do ask for help in the comments section.

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

TecMint is the fastest growing and most trusted community site for any kind of Linux Articles, Guides and Books on the web. Millions of people visit TecMint! to search or browse the thousands of published articles available FREELY to all.

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

Support Us

We are thankful for your never ending support.

8 thoughts on “How to Install PgAdmin 4 Debian 10”

  1. Hi there, I am trying to install pgAdmin4 on an 18.04 ubuntu server. When I tried to “apt install pgadmin4 pgadmin4-apache2” I ran into the following error:

    The following packages have unmet dependencies:
     pgadmin4 : Depends: libqt5core5a (>= 5.11.0~rc1) but 5.9.5+dfsg-0ubuntu2.5 is to be installed
     pgadmin4-common : Depends: python3-psycopg2 (>= 2.7.4) but it is not going to be installed
                       Recommends: python3-psycopg2 (>= 2.8) but it is not going to be installed
    E: Unable to correct problems, you have held broken packages.
    

    I appreciate any suggestions.

    Cheers

    Reply
    • @Bo

      Do the following.

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

      Create /etc/apt/sources.list.d/pgdg.list file with this line in it:

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

      Save the file and close it.

      Then run these commands to install pgadmin4:

      $ sudo apt-get update
      $ apt-get install pgadmin4  pgadmin4-apache2
      
      Reply
      • That did it! What do I need to do if any when a new release of pgAdmin4 is out?

        The reason I am asking this question is that for about a year and a half, I have been using the containerized deployment. Since I never could get the volume-mapping working, each time when I want to upgrade, I lost my history, connections, settings, etc.

        Thank you for sharing this great post and your support!

        Bo

        Reply

Got something to say? Join the discussion.

Have a question or suggestion? Please leave a comment to start the discussion. Please keep in mind that all comments are moderated and your email address will NOT be published.

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