Skip to content

Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04

Netcloud24
Cloud Infrastructure Expert
HOSTING H1

Free web hosting H1

5 GB of storage and SSL for a small website or WordPress project.

Explore hosting H1
WINDOWS VPS + RDS

Run Windows applications remotely

Windows Server 2022 or 2025 and RDS CALs included in the plan. Choose resources and user capacity for your business.

Explore Windows VPS
NetCloud24 Expert Guides Open the dedicated video page

Video transcript: NetCloud24 Expert Guides. Practical knowledge for a reliable cloud. Cloud and VPS expertise, security, performance, and step-by-step tutorials. Learn, deploy, and keep building with NetCloud24.

 

How to Install pgAdmin 4 on Ubuntu 24.04

Introduction

pgAdmin 4 is a powerful and feature-rich administration and management tool for PostgreSQL databases. This guide will walk you through the steps to install pgAdmin 4 on Ubuntu 24.04.

Prerequisites

  • An Ubuntu 24.04 server with sudo privileges
  • PostgreSQL installed on your system
  • A stable internet connection

Step 1: Update System Packages

Before installing any software, it is essential to update your system packages. Run the following commands:

Visual overview of Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
Visual overview: Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
sudo apt update
sudo apt upgrade -y

Step 2: Install pgAdmin 4

    1. Add the pgAdmin 4 repository by running the command:
curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo tee /etc/apt/trusted.gpg.d/pgadmin.asc
    1. Add the repository to your system:
echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/ubuntu/ focal-pgdg main" | sudo tee /etc/apt/sources.list.d/pgadmin4.list
    1. Update the package list:
sudo apt update
    1. Install pgAdmin 4:
sudo apt install pgadmin4 -y

Step 3: Configure pgAdmin 4

After installation, you need to configure pgAdmin 4. Follow these steps:

    1. Run the setup script to configure the web server:
sudo /usr/pgadmin4/bin/setup-web.sh
  1. Follow the prompts to set up an email and password for accessing the pgAdmin web interface.

Step 4: Access pgAdmin 4

Once configured, you can access pgAdmin 4 by opening a web browser and navigating to:

http:///pgadmin4

Log in with the email and password you set during configuration.

Conclusion

Congratulations! You have successfully installed and configured pgAdmin 4 on Ubuntu 24.04. You can now use this tool to manage your PostgreSQL databases efficiently.

For advanced hosting solutions, check out our VPS Windows VPSoffers.

Key topics covered in Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
Key topics covered in this NetCloud24 guide.

© 2024 netcloud24.com. All rights reserved.

Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
Explore more

More on this topic

Netcloud24
Netcloud24
Cloud Infrastructure Expert · NetCloud24

Comments are closed.

Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04

Netcloud24
Cloud Infrastructure Expert
HOSTING H1

Free web hosting H1

5 GB of storage and SSL for a small website or WordPress project.

Explore hosting H1
WINDOWS VPS + RDS

Run Windows applications remotely

Windows Server 2022 or 2025 and RDS CALs included in the plan. Choose resources and user capacity for your business.

Explore Windows VPS
NetCloud24 Expert Guides Open the dedicated video page

Video transcript: NetCloud24 Expert Guides. Practical knowledge for a reliable cloud. Cloud and VPS expertise, security, performance, and step-by-step tutorials. Learn, deploy, and keep building with NetCloud24.

 

 

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:

Visual overview of Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
Visual overview: Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
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.

Key topics covered in Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
Key topics covered in this NetCloud24 guide.

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.

Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
Linux VPS & VPS Windows Setup Guide | NetCloud24 pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
Explore more

More on this topic

Netcloud24
Netcloud24
Cloud Infrastructure Expert · NetCloud24

Comments are closed.