๐ŸŒ
pgAdmin
pgadmin.org โ€บ download โ€บ pgadmin-4-apt
pgAdmin 4 (APT)
# # Setup the repository # # Install ...ources.list.d/pgadmin4.list && apt update' # # Install pgAdmin # # Install for both desktop and web modes: sudo apt install pgadmin4 # Install for desktop mode only: sudo apt install pgadmin4-desktop # Install for web mode only: sudo apt install ...
FAQ
pgAdmin - PostgreSQL Tools for Windows, Mac, Linux and the Web
Introduction
pgAdmin - PostgreSQL Tools for Windows, Mac, Linux and the Web
Download
pgAdmin - PostgreSQL Tools for Windows, Mac, Linux and the Web
Screenshots
pgAdmin - PostgreSQL Tools for Windows, Mac, Linux and the Web
free and open-source relational database management system
postgresql psql screenshot
postgresql snap 3 1744372955
PostgreSQL (/หˆpoสŠstษกrษ›skjuหŒษ›l/ โ“˜ POHST-gres-kew-EL), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) โ€ฆ Wikipedia
Factsheet
Other names Postgres
Developer PostgreSQL Global Development Group
Release 8 July 1996;
29 years ago (1996-07-08)
Factsheet
Other names Postgres
Developer PostgreSQL Global Development Group
Release 8 July 1996;
29 years ago (1996-07-08)
๐ŸŒ
pgAdmin
pgadmin.org โ€บ download
Download
pgAdmin is a free software project released under the PostgreSQL licence. The software is available in source and binary format from the PostgreSQL mirror network. Because compiling from source requires technical knowledge, we recommend installing binary packages whenever possible. The pages in this section give additional details about each binary package available as well as more direct download links.
๐ŸŒ
Snapcraft
snapcraft.io โ€บ install โ€บ pgadmin4 โ€บ ubuntu
Install pgadmin4 on Ubuntu using the Snap Store | Snapcraft
May 11, 2026 - Get the latest version of pgadmin4 for on Ubuntu - Management tool for the PostgreSQL database
๐ŸŒ
Gcore
gcore.com โ€บ home โ€บ developers โ€บ how to install pgadmin4 on ubuntu
PgAdmin4 Installation on Ubuntu 22.04 Guide | Gcore
April 8, 2025 - sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal/ pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'
๐ŸŒ
ComputingForGeeks
computingforgeeks.com โ€บ home โ€บ install pgadmin 4 on ubuntu 24.04 / 22.04
Install pgAdmin 4 on Ubuntu 24.04 / 22.04 [Step-by-Step]
March 19, 2026 - It provides a powerful web-based interface for managing your PostgreSQL servers, running queries, monitoring performance, and handling routine database administration tasks. This guide covers installing pgAdmin 4 (version 9.13) in web mode on Ubuntu 24.04 and Ubuntu 22.04.Original content from computingforgeeks.com - post 32490
๐ŸŒ
Snapcraft
snapcraft.io โ€บ pgadmin4
Install pgadmin4 on Linux | Snap Store
May 11, 2026 - Get the latest version of pgadmin4 for Linux - Management tool for the PostgreSQL database
๐ŸŒ
TecAdmin
tecadmin.net โ€บ how-to-install-pgadmin4-on-ubuntu-20-04
How to Install pgAdmin4 on Ubuntu 20.04 โ€“ TecAdmin
April 26, 2025 - An official PPA is available for pgAdmin4 to install the latest version on Ubuntu systems. First, import the repository signing GPG key and add the pgAdmin4 PPA to your system using the following commands.
๐ŸŒ
HowtoForge
howtoforge.com โ€บ home โ€บ how to install postgresql and pgadmin4 on ubuntu 18.04 lts
How to Install PostgreSQL and pgAdmin4 on Ubuntu 18.04 LTS
Now go to the 'pgadmin4' directory and activate the virtual environment. ... Inside the python virtual environment, download the pgAdmin4 whl package file.
Find elsewhere
๐ŸŒ
Time4vps
help.time4vps.com โ€บ all collections โ€บ vps tutorials โ€บ various tutorials โ€บ how to install pgadmin 4 on ubuntu and debian
How To Install pgAdmin 4 on Ubuntu and Debian | Time4VPS Help Center
August 6, 2025 - pgAdmin 4 is a powerful web-based tool for managing PostgreSQL databases. This guide provides step-by-step instructions for installing and configuring pgAdmin 4 on Ubuntu (version 22.04 and later) and Debian 11/12.
๐ŸŒ
CommandPrompt Inc.
commandprompt.com โ€บ education โ€บ how-to-install-pgadmin-on-ubuntu
How to Install pgAdmin on Ubuntu โ€” CommandPrompt Inc.
April 3, 2023 - To install pgAdmin on Ubuntu, add the public key using Curl, add the pgAdmin repository using sudo, and execute the โ€œsudo apt install pgAdmin4โ€ command.
Call ย  +1-503-667-4564
Address ย  2950 Newmarket ST STE 101 - 231, 98226, Bellingham
๐ŸŒ
HowtoForge
howtoforge.com โ€บ home โ€บ how to install pgadmin 4 postgresql admin tool on ubuntu 24.04
How to Install pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04
Download the GPG key for the pgAdmin4 repository with the following command. curl -fsSL https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/pgadmin4.gpg ยท Now add the pgAdmin4 repository for the ...
๐ŸŒ
LinuxShout
linux.how2shout.com โ€บ home โ€บ how to install pgadmin 4 on ubuntu 20.04 lts linux
How to install Pgadmin 4 on Ubuntu 20.04 LTS Linux - LinuxShout
August 4, 2022 - Steps to install PostgreSQL pgAdmin 4 on Ubuntu 20.041. Add pgAdmin 4 repository2. Add Public GPG Key3. Update Ubuntu 20.044. Install pgAdmin4 on Ubuntu 20.04 server5. Configure the pgAdmin user account6.
๐ŸŒ
LinuxShout
linux.how2shout.com โ€บ home โ€บ install postgresql pgadmin 4 on ubuntu 24.04 or 22.04 lts linux
Install PostgreSQL pgAdmin 4 on Ubuntu 24.04 or 22.04 LTS Linux
September 18, 2024 - Learn the commands to install - the PostgreSQL GUI interface pgAdmin 4 tools on Ubuntu 24.04 Noble or 22.04 LTS Jammy JellyFish Linux to manage Databases using a web-based graphical user interfaceโ€ฆ
๐ŸŒ
Heatware
heatware.net โ€บ postgresql โ€บ install-pgadmin-ubuntu
Install PgAdmin 4 on Ubuntu: A Step-by-Step Guide - HeatWare
February 11, 2025 - Learn how to install and set up pgAdmin on Ubuntu with this step-by-step guide. Streamline your PostgreSQL management with ease.
Top answer
1 of 6
7

I had a similar problem and couldn't find any solution for the desktop version, in particular, for Ubuntu 22.04 (jammy). However, this should also work for the pgadmin4-web:

sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add
sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/snapshots/2022-05-05/apt/jammy pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'
sudo apt install pgadmin4-web

(Don't forget to run sudo /usr/pgadmin4/bin/setup-web.sh after that)

For the desktop version just install pgadmin4-desktop instead of pgadmin4-web:

sudo apt install pgadmin4-desktop

Also, please note that this is a temporary solution (May 2022), until the devs release the final pgadmin4 version for jammy. Once it's out, you would just need to update the repository.

Hope this helps.

2 of 6
4

I managed to install pgadmin4 from APT on Ubuntu 22.04, but even after that I was facing some issues while starting pgadmin4.

So I found out that there's a python package for pgadmin4 which exists. It will install the web version of the pgadmin4 and it works without any issue.

Follow the below steps to install or you can check this link.

$ sudo mkdir /var/lib/pgadmin
$ sudo mkdir /var/log/pgadmin
$ sudo chown $USER /var/lib/pgadmin
$ sudo chown $USER /var/log/pgadmin

# Create virtual environment
$ python3 -m venv pgadmin4
$ source pgadmin4/bin/activate

# Install pgadmin4
(pgadmin4) $ pip install pgadmin4

# Start pgadmin4
(pgadmin4) $ pgadmin4

For the first time after running pgadmin4, you'll be asked to set the email and password.

Top answer
1 of 4
163

For pgAdmin 4 v4.21 on Ubuntu, according to the download page:

Install dependencies, create a virtual environment, download, install & configure

Using Python2.x

sudo apt-get install virtualenv python-pip libpq-dev python-dev

cd
virtualenv pgadmin4
cd pgadmin4
source bin/activate

pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.21/pip/pgadmin4-4.21-py2.py3-none-any.whl

Using Python3.6 (Preferred to avoid encoding related issues)

sudo apt-get install virtualenv python3-pip libpq-dev python3-dev

cd
virtualenv -p python3 pgadmin4
cd pgadmin4
source bin/activate

pip3 install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.21/pip/pgadmin4-4.21-py2.py3-none-any.whl

Configure

Override default paths and set it to single-user mode in the local configuration file:

nano lib/python2.7/site-packages/pgadmin4/config_local.py

For Python3.x:

nano lib/python3.6/site-packages/pgadmin4/config_local.py

Write:

import os
DATA_DIR = os.path.realpath(os.path.expanduser(u'~/.pgadmin/'))
LOG_FILE = os.path.join(DATA_DIR, 'pgadmin4.log')
SQLITE_PATH = os.path.join(DATA_DIR, 'pgadmin4.db')
SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions')
STORAGE_DIR = os.path.join(DATA_DIR, 'storage')
SERVER_MODE = False

Run

python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py

For Python3.x:

python3 lib/python3.6/site-packages/pgadmin4/pgAdmin4.py

Access

Access at http://localhost:5050

Exit

Exit with Ctrl-C

Run again

cd ~/pgadmin4
source bin/activate
python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py

For Python3.6

#!/bin/bash
cd ~/pgadmin4
source bin/activate
python3 lib/python3.6/site-packages/pgadmin4/pgAdmin4.py

Make a shortcut

touch ~/pgadmin4/pgadmin4
chmod +x ~/pgadmin4/pgadmin4
nano ~/pgadmin4/pgadmin4

Write:

#!/bin/bash
cd ~/pgadmin4
source bin/activate
python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py

For Python3.6

#!/bin/bash
cd ~/pgadmin4
source bin/activate
python3 lib/python3.6/site-packages/pgadmin4/pgAdmin4.py

Now you can just run it with a simpler command:

~/pgadmin4/pgadmin4

Python3 users

Replace [x] in Python3.6 with your respective version.

Conflict with pgAdmin 3 configuration

pgAdmin 4 will not start in the environment where pgAdmin 3 was previously installed and used because of incompatible configuration in the .pgadmin directory. The simplest solution is to either clear that directory or tweak config_local.py to point to a clean new .pgadmin4 directory.

2 of 4
52

Other option is to use docker and a docker image provided by thaJeztah - https://github.com/thaJeztah/pgadmin4-docker

$ docker run --rm -p 5050:5050 thajeztah/pgadmin4

Then to access a PostgreSQL DB instance from within pgadmin4 you should use the IP of the host instead of localhost and 127.0.0.1 since Docker will map those to the container itself.

The IP of a dockerised DB instance could be found with 2 steps:

  • find the container ID of your db with:

    docker ps

  • inspect the container_name to find its ip with:

    docker inspect <ID from previous step>

you are looking for something like "IPAddress": "172.18.0.3"

๐ŸŒ
Shapehost
shape.host โ€บ home โ€บ resources โ€บ how to install pgadmin 4 postgresql admin tool on ubuntu 24.04
How to Install pgAdmin 4 PostgreSQL Admin Tool on Ubuntu 24.04 - Shapehost
December 17, 2024 - Learn how to install pgAdmin 4 on Ubuntu 24.04 and manage your PostgreSQL databases with ease. Follow our simple, step-by-step guide.
๐ŸŒ
MacLochlainns Weblog
blog.mclaughlinsoftware.com โ€บ 2023 โ€บ 12 โ€บ 07 โ€บ pgadmin4-on-ubuntu
pgAdmin4 on Ubuntu | MacLochlainns Weblog
December 7, 2023 - sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update' ... Hit:1 http://us.archive.ubuntu.com/ubuntu jammy InRelease Hit:2 http://us.archive.ubuntu.com/ubuntu jammy-updates InRelease Hit:3 http://security.ubuntu.com/ubuntu jammy-security InRelease Hit:4 http://us.archive.ubuntu.com/ubuntu jammy-backports InRelease Hit:5 https://dl.google.com/linux/chrome/deb stable InRelease Get:6 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/jammy pgadmin4 InRelease [4,217 B] Get:7 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/jammy pgadmin4/main all Packages [4,637 B] Get:8 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/jammy pgadmin4/main amd64 Packages [7,693 B] Fetched 16.5 kB in 2s (7,404 B/s) Reading package lists...
๐ŸŒ
DEV Community
dev.to โ€บ andersonleite โ€บ como-instalar-o-pgadmin-4-no-ubuntu-modo-desktop-ou-web-k3d
Como instalar o pgAdmin 4 no Ubuntu (modo Desktop ou Web) - DEV Community
July 4, 2025 - echo "deb [signed-by=/usr/share/keyrings/pgadmin.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" | sudo tee /etc/apt/sources.list.d/pgadmin4.list
๐ŸŒ
DigitalOcean
digitalocean.com โ€บ community โ€บ tutorials โ€บ how-to-install-and-configure-pgadmin-4-in-server-mode-on-ubuntu-22-04
How To Install And Configure pgAdmin 4 in Server Mode on Ubuntu 22.04 | DigitalOcean
September 16, 2022 - In this tutorial, weโ€™ll walk through the process of installing and configuring the latest version of pgAdmin onto an Ubuntu 22.04 server, accessing pgAdmin tโ€ฆ