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-pgwebSpecification
- 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
- License
- Permissive license, MIT
- 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.
| Service | Image | Tag | Ports | Volumes |
|---|---|---|---|---|
| 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.
| Service | Variable | Value |
|---|---|---|
| pgweb | PGWEB_AUTH_PASS | Generated at deploy |
| pgweb | PGWEB_AUTH_USER | Preset by the template |
First run
- Sign in with the username and password from the install form.
- Enter the host, user, password and database of the Postgres server you want to browse.
Install Pgweb on a VPS
-
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 -
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 | shif the machine does not have it. See Getting started.levelrail-cli login --device -
Read the template
Shows the entry, including its full compose.yaml.
levelrail-cli templates get pgweb -
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-pgwebTo 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.
Docs and upstream
More in Developer Tools
- PlantUML ServerTurns PlantUML text into UML diagrams as images over HTTP. It has no database and no login, so restrict who can reach it.
- PocketBaseAn open-source backend in one file: embedded database, auth, file storage, and realtime API.
- OpengistA self-hosted pastebin powered by Git, for sharing snippets and gists with revisions, topics and search. AGPL-3.0 licensed. Uses SQLite in one container. SSH Git access is off, so clone and push over HTTPS. The first account you register becomes the admin.
- ProxyscotchA small CORS proxy that lets Hoppscotch call APIs from the browser.
- OneDevA self-hosted Git server with built-in CI/CD, issue tracking and code search, in one container.
- NocoBaseAn extensible no-code/low-code platform for building internal tools and databases.