pgAdmin is a web-based interface for management of PostgreSQL database instances. It can be installed on Linux, Unix, Mac OS X, and Windows to manage PostgreSQL 9.2 and above.
You must have PostgreSQL server installed on your system via an official apt repository. If you don’t have installed PostgreSQL, use below link to install.
Install pgAdmin4 on Debian 9
pgAdmin4 packages are available under PostgreSQL official apt repository. We assume you already have configured apt repository during installation of the database server.
Execute below command on the terminal to begin pgAdmin4 installation on Debian.
sudo apt-get install pgadmin4 pgadmin4-apache2
The package pgadmin4-apache2 will integrate pgAdmin4 with Apache2 web server.
During the installation, you are required to setup pgAdmin4 admin login.
Enter an email address to use as admin login id for your pgAdmin4 web interface. You can use any address of your choice.
Then click OK.
Now this will prompt to input password for the administrator account.
This will complete the installation of pgAdmin4 on your system. This will also make required changes on your local PostgreSQL system for connection.
Now, pgAdmin4 is ready to use. Let’s connect pgAdmin4 with PostgreSQL database.
Configure pgAdmin4 with PostgreSQL
You have successfully installed pgAdmin4 on your Debian system. Now you can access pgAdmin4 in your favorite web browser.
Use servers IP address or domain name followed by /pgAdmin4 as subdirectory URL.
After successful login, you will be redirected to pgAdmin4 dashboard. As this is a new installation, there will be no servers connected.
Now, connect your first PostgreSQL instance by clicking on “Add New Server“.
This will open a popup window. This tutorial is using the basic settings to connect database instance. Enter the user-friendly name for the new instance connection under the General tab.
Then switch to Connection tab. Enter hostname or IP address of your PostgreSQL instance. In my case, it’s running on localhost system, so I just the put localhost as the hostname. Then enter the username and password for PostgreSQL authentication.
After that click Save button.
After successful adding new instance, You will see instance in the left sidebar. Here you can manage the database instance.
You have installed pgAdmin4, a web-based interface for the PostgreSQL server management. Now connect as many as PostgreSQL instances with the pgAdmin4.