Install pgAdmin 4 on Debian

pgAdmin 4 helps manage PostgreSQL servers with a web-based interface.

Setup Repositories

Install the pgAdmin public key:

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

Add the repository and update:

sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/bookworm pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

Install for web mode:

sudo apt install pgadmin4-web

Other install options:

# Desktop mode only
sudo apt install pgadmin4-desktop
# Both desktop and web
sudo apt install pgadmin4

Post-Installation Setup

Run the setup script to configure the web server:

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

Access pgAdmin at http://127.0.0.1/pgadmin4.

(Optional) Change URL Base Path

To run pgAdmin at the root URL (without /pgadmin4 suffix):

sudo nano /etc/apache2/conf-available/pgadmin4.conf

Replace:

# From original
WSGIScriptAlias /pgadmin4 /usr/pgadmin4/web/pgAdmin4.wsgi
# Changed to
WSGIScriptAlias / /usr/pgadmin4/web/pgAdmin4.wsgi

Restart Apache:

sudo systemctl restart apache2.service

Access pgAdmin at http://127.0.0.1.

References

• pgAdmin - PostgreSQL Tools