How to Install pgAdmin on Debian 11 / Debian 10

0

pgAdmin is a free and open-source web-based tool for managing PostgreSQL databases, and it includes several features that can help you administer and maintain databases with ease.

With pgAdmin,  you can view and edit data in tables, run SQL queries, manage users and permissions, create sequences, etc., all from your web browser

pgAdmin is available for multiple operating systems such as Linux, Windows, and macOS.

Additionally, pgAdmin can also be run as a desktop application.

In this post, we will see how to install pgAdmin on Debian 11 / Debian 10.

Install PostgreSQL Server

First, install PostgreSQL server on your system if you haven’t already installed and above installed on your system.

READ: How To Install PostgreSQL on Debian 11 / Debian 10

Install pgAdmin on Debian 11

Add pgAdmin Repository

Update the repository index and then install a few essential packages.

sudo apt update

sudo apt install -y apt-transport-https ca-certificates software-properties-common curl

First, import the pgAdmin signing key to the system.

# Debian 11

curl -fsSL https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/pgadmin-keyring.gpg

# Debian 10

curl -fsSL https://www.pgadmin.org/static/packages_pgadmin_org.pub -O- | sudo apt-key add -

Next, add the pgAdmin repository to your system using the below command.

# Debian 11

echo "deb [signed-by=/usr/share/keyrings/pgadmin-keyring.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/bullseye pgadmin4 main" | sudo tee /etc/apt/sources.list.d/pgadmin4.list

# Debian 10

echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/buster pgadmin4 main" | sudo tee /etc/apt/sources.list.d/pgadmin4.list

Install pgAdmin 4

Once you have added the repository, run the following command to update the repository index.

sudo apt update

Install pgAdmin 4 web application with the following command.

sudo apt install -y pgadmin4-web

Setup pgAdmin 4

You will need to set up pgAdmin 4 before accessing it. So, initiate the pgAdmin 4 set up with the below command.

sudo /usr/pgadmin4/bin/setup-web.sh

To complete the setup, you will need to answer a few questions. So, answer as per your requirement.

Setting up pgAdmin 4 in web mode on a Debian based platform...
Creating configuration database...
NOTE: Configuring authentication for SERVER mode.

Enter the email address and password to use for the initial pgAdmin user account:

Email address: [email protected]  
Password: xxx
Retype password: xxx
pgAdmin 4 - Application Initialisation
======================================

Creating storage and log directories...
We can now configure the Apache Web server for you. This involves enabling the wsgi module and configuring the pgAdmin 4 application to mount at /pgadmin4. Do you wish to continue (y/n)? y << Type y and press Enter
The Apache web server is running and must be restarted for the pgAdmin 4 installation to complete. Continue (y/n)? y << Type y and press Enter
Apache successfully restarted. You can now start using pgAdmin 4 in web mode at http://127.0.0.1/pgadmin

Set up PostgreSQL Authentication

PostgreSQL database users can only log in from the Unix socket by default. So, you will need to enable login from all hosts or specific subnet if the pgAdmin4 is installed on another machine. You can enable the MD5 method to ensure the pgAdmin sends encrypted passwords for additional security.

Edit pg_hba.conf file.

# PostgreSQL 13

sudo nano /etc/postgresql/14/main/pg_hba.conf

# PostgreSQL 12

sudo nano /etc/postgresql/13/main/pg_hba.conf

Update the below line shown below.

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# IPv4 local connections:
host     all            all              all                     md5

Restart the PostgreSQL service.

sudo systemctl restart postgresql

Access pgAdmin 4

Open a web browser and go to the following URL to access the pgAdmin 4 web application.

http://ip.add.re.ss/pgadmin4

Log in to the pgAdmin4 using the email address and password you have entered during the pgAdmin4 setup.

Upon successful login, you should see the pgAdmin 4 interface.

To manage a PostgreSQL server, you must add a new server by clicking on Add New Server on the home page.

General Tab:

Name:- Name your PostgreSQL Server

Connection Tab:

Hostname/Address:- Hostname or IP Address of PostgreSQL server. Enter 127.0.0.1 if pgAdmin4 is installed on the PostgreSQL server itself.
Port:- 5432 (Leave default) – Change it if required.
Username:- Username by which you are connecting. In my case, it is postgres.
Password:- Password for the database user. In my case, it is a postgres user’s password.

Click Save to save the changes.

If the connection to the PostgreSQL server is successful, you will see the following page.

PostgreSQL Database Statistics
PostgreSQL Database Statistics

Conclusion

That’s All. You have successfully installed pgAdmin on Debian 11 / Debian 10. Also, you have added one of your PostgreSQL instances to manage the database. You can visit pgAdmin 4 documentation for more information.

You might also like