Self-host pgAdmin on a VPS

A full-featured web GUI for administering and querying PostgreSQL databases.

levelrail-cli templates deploy pgadmin --name my-pgadmin

Specification

Status
Verified on arm64 with image tag 8.14
Category
Database Tools
Services
pgadmin
Ports
80
Volumes
1
Memory
about 256 MiB
arm64
tested
amd64
image published
Settings to fill in
none
License
not yet recorded

About pgAdmin

A full-featured web GUI for administering and querying PostgreSQL databases. Runs as a single container from the pgadmin4 image, listening on port 80; data is kept in named volumes.

What it deploys

pgAdmin runs as one service in a single Compose app, listening on port 80, with 1 named volume mount.

ServiceImageTagPortsVolumes
pgadmin dpage/pgadmin4 8.14 80 pgadmin_data -> /var/lib/pgadmin

Before you install

  • CPU architecture. arm64 listed. Every image lists linux/arm64 in its registry manifest. That is a manifest fact, not proof the app runs on Arm.
  • Verified. Verified on arm64 with image tag 8.14. Verified means our CI ran this exact image version and it answered on its health path. Evidence
  • Host ports. It publishes port 80 directly on the host, so open them in the VPS firewall only if you want that.

Settings and environment

You do not have to fill in anything. 1 secret is generated at deploy and stored encrypted. Values are never shown here.

ServiceVariableValue
pgadminPGADMIN_DEFAULT_EMAILPreset by the template
pgadminPGADMIN_DEFAULT_PASSWORDGenerated at deploy

Install pgAdmin on a VPS

  1. Install Levelrail on a fresh VPS

    Run this as root on a Linux server (amd64 or arm64) with ports 80 and 443 reachable. The installer prints a setup link.

    curl -fsSL https://levelrail.com/install.sh | sudo sh
  2. Sign in

    Open the setup link, choose a password, then log the CLI in. The CLI install command is curl -fsSL https://levelrail.com/install-cli.sh | sh if the machine does not have it. See Getting started.

    levelrail-cli login --device
  3. Read the template

    Shows the entry, including its full compose.yaml.

    levelrail-cli templates get pgadmin
  4. Deploy it

    This deploys the template compose file as an app. The app name defaults to the template id; --name sets another.

    levelrail-cli templates deploy pgadmin --name my-pgadmin

Without a domain the app gets an sslip.io address. You can also deploy it from the dashboard: Apps, New app, Browse templates, then pgAdmin.

More in Database Tools

All Database Tools templates