Are you looking for steps to install PgAdmin Debian? Here’s how we do it.

Here at Bobcares, we have seen several such Debian related installations as part of our Server Management Services for web hosts and online service providers.

Today we’ll take a look at how to install PgAdmin in Debian

Know more about PgAdmin

pgAdmin is an open-source graphical user interface (GUI) administration and management tool for the PostgreSQL database.

Also, it provides a powerful user interface that helps you to easily create, manage, maintain, and use database objects.

Moreover, it supports all PostgreSQL features, from writing simple SQL queries to developing complex databases.

Additionally, it includes features like auto-detection and support for objects discovered at run-time, support for administrative queries, syntax-highlighting SQL editor, supportive error messages, and so on.

How to install PgAdmin 4 in Debian 10

Now let’s take a look at how our Support Engineers install the PgAdmin in Debian.

By default, Debian 10 ships with pgAdmin 3. However, if you wish to install pgAdmin 4 then you would need to enable the PostgreSQL Global Development Group (PGDG) APT repository that contains the PostgreSQL packages for Debian and Ubuntu.

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

Next, create a repository file named /etc/apt/sources.list.d/pgdg.list.

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

Then add the below lines into the file.

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

Now save the file and exit from it.

Then update the APT package cache and install the pgAdmin 4 package by running the below command.

# apt-get update
# apt-get install pgadmin4 pgadmin4-apache2

You will be asked to set an email address for the pgAdmin web interface initial user account during the package installation. This email address will be the account name. Provide the email address and press Enter.

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

After the installation of the packages, the installer activates systemd to start the Apache2 service and enables it to automatically start at system startup, every time the system is rebooted.

Run the following command to check the status of the service.

# systemctl status apache2

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.

Accessing the pgAdmin 4 Web Interface Debian

Now you must be able to access the pgAdmin 4 web interface. So 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 had set earlier. Then click on Login.

After logging in successfully, the pgAdmin4 web interface default dashboard appears. Then to connect to a database server, click on Add New Server.

Then add the new server connection name and a comment. Next, click on the Connection Tab to provide the connection details i.e. hostname, database name, database username, and password. After entering the details, click Save.

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

Finally, the pgAdmin Homepage must appear.

[Need any further assistance with Debian queries? – We’re available to help you]

Conclusion

Today, we saw how our Support Engineers install PgAdmin in Debian.