How to Install pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04

pgAdmin 4 is a popular open-source administration and development platform for PostgreSQL. This guide will walk you through the installation process on Ubuntu 24.04.

Prerequisites

• Ubuntu 24.04 installed on your machine.
• Access to a terminal with sudo privileges.

Step 1: Update Your System

Before installing any new software, it’s a good idea to update your package list and upgrade your existing packages. Open your terminal and run:

sudo apt update && sudo apt upgrade -y
    

Step 2: Install Required Dependencies

pgAdmin 4 requires some additional packages. Install them by running:

sudo apt install wget curl ca-certificates gnupg -y
    

Step 3: Add the pgAdmin Repository

Next, you need to add the pgAdmin repository to your system. Run the following commands:

wget --quiet -O - https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/pgadmin.gpg
echo "deb [signed-by=/usr/share/keyrings/pgadmin.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/ubuntu focal pgadmin4 main" | sudo tee /etc/apt/sources.list.d/pgadmin4.list
    

Step 4: Install pgAdmin 4

Now that the repository is added, update your package list again and install pgAdmin 4:

sudo apt update
sudo apt install pgadmin4 -y
    

Step 5: Configure pgAdmin 4

After installation, you need to configure pgAdmin 4. Run the following command:

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

This script will prompt you to set up an email address and password for the pgAdmin web interface.

Step 6: Access pgAdmin 4

Once the setup is complete, you can access pgAdmin 4 by opening your web browser and navigating to:

http://localhost/pgadmin4
    

Conclusion

You have successfully installed pgAdmin 4 on Ubuntu 24.04. You can now use it to manage your PostgreSQL databases easily.