Self-host PostgreSQL with pgweb on a VPS
A PostgreSQL 17 server paired with the pgweb browser console, already wired together. The database is not published on the host, so other services in this project reach it at db:5432. pgweb opens straight into the database with the generated credentials, so keep its address private.
levelrail-cli templates install postgres-pgweb --name my-postgres-pgwebSpecification
- Status
- Listed
- Category
- Database Tools
- Services
- db, pgweb
- Ports
- 8081
- Volumes
- 1
- Memory
- about 384 MiB
- arm64
- unknown
- amd64
- unknown
- Settings to fill in
- none
- License
- Permissive license, MIT
- Listing
- Community template
About PostgreSQL with pgweb
A PostgreSQL 17 server paired with the pgweb browser console, already wired together. The database is not published on the host, so other services in this project reach it at db:5432. pgweb opens straight into the database with the generated credentials, so keep its address private.
What it deploys
PostgreSQL with pgweb runs as 2 services in a single Compose app, listening on port 8081, with 1 named volume mount.
| Service | Image | Tag | Ports | Volumes |
|---|---|---|---|---|
| db | postgres | 17.11-alpine | none | pgdata -> /var/lib/postgresql/data |
| pgweb | sosedoff/pgweb | 0.17.0 | 8081 | none |
Before you install
- CPU architecture. arm64 unknown. The scan could not read a manifest or the tag is chosen at install time. This is not a claim either way.
- 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. 2 secrets are generated at deploy and stored encrypted. Values are never shown here.
| Service | Variable | Value |
|---|---|---|
| db | POSTGRES_PASSWORD | Generated at deploy |
| pgweb | PGWEB_DATABASE_URL | Generated at deploy |
First run
- Open the page, the console is already connected to the bundled database.
Install PostgreSQL with 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 postgres-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 postgres-pgweb --name my-postgres-pgwebTo put a service behind a domain at install, add
--domain SERVICE=HOST:levelrail-cli templates install postgres-pgweb --name my-postgres-pgweb --domain db=postgres-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 PostgreSQL with pgweb.
Docs and upstream
More in Database Tools
- PostgreSQLThe PostgreSQL relational database server on the official Alpine image, with a persistent volume and a generated password. It is not published on the host, so reach it from other services in this project at postgres:5432.
- QdrantA vector similarity search engine for storing, searching, and managing embeddings.
- QuestDBA fast time series database with SQL, a web console, the PostgreSQL wire protocol on 8812 and InfluxDB line protocol ingestion on 9009. The console and the PostgreSQL port share one generated password. Only the console is offered a domain.
- phpMyAdminA web-based admin tool for MySQL and MariaDB, built for ad-hoc use against any reachable database.
- pgvector PostgresPostgreSQL 17 with the pgvector extension preinstalled, for embeddings next to your relational data.
- pgAdminA full-featured web GUI for administering and querying PostgreSQL databases.