Self-host Pgweb on a VPS

A small web client for browsing and querying PostgreSQL databases, with a table browser, query editor and export. Runs as one container with no storage of its own. Sign in with the username and password from the install form, then enter the connection details of your database.

levelrail-cli templates install pgweb --name my-pgweb

Specification

Status
Listed
Category
Developer Tools
Services
pgweb
Ports
8081
Volumes
0
Memory
about 64 MiB
arm64
image published
amd64
image published
Settings to fill in
none
Listing
Community template

About Pgweb

A small web client for browsing and querying PostgreSQL databases, with a table browser, query editor and export. Runs as one container with no storage of its own. Sign in with the username and password from the install form, then enter the connection details of your database.

What it deploys

Pgweb runs as one service in a single Compose app, listening on port 8081.

ServiceImageTagPortsVolumes
pgweb sosedoff/pgweb 0.17.0 8081 none

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.
  • Listed. It is in the catalog. Back up the data volume before changing an image tag.

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
pgwebPGWEB_AUTH_PASSGenerated at deploy
pgwebPGWEB_AUTH_USERPreset by the template

First run

  1. Sign in with the username and password from the install form.
  2. Enter the host, user, password and database of the Postgres server you want to browse.

Install Pgweb 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 pgweb
  4. Install it

    This template has an install form, so the CLI fills each setting from --env, a generated secret or its default.

    levelrail-cli templates install pgweb --name my-pgweb

    To put a service behind a domain at install, add --domain SERVICE=HOST:

    levelrail-cli templates install pgweb --name my-pgweb --domain pgweb=pgweb.example.com

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

More in Developer Tools

All Developer Tools templates