Self-host PostgreSQL on a VPS
The 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.
levelrail-cli templates install postgres --name my-postgresSpecification
- Status
- Listed
- Category
- Database Tools
- Services
- postgres
- Ports
- 5432
- Volumes
- 1
- Memory
- about 256 MiB
- arm64
- unknown
- amd64
- unknown
- Settings to fill in
- none
- License
- Permissive license, PostgreSQL
- Listing
- Community template
About PostgreSQL
The 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.
What it deploys
PostgreSQL runs as one service in a single Compose app, listening on port 5432, with 1 named volume mount.
| Service | Image | Tag | Ports | Volumes |
|---|---|---|---|---|
| postgres | postgres | 17.11-alpine | 5432 | pgdata -> /var/lib/postgresql/data |
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. 1 secret is generated at deploy and stored encrypted. Values are never shown here.
| Service | Variable | Value |
|---|---|---|
| postgres | POSTGRES_DB | Preset by the template |
| postgres | POSTGRES_PASSWORD | Generated at deploy |
| postgres | POSTGRES_USER | Preset by the template |
First run
- Read the generated password from the app secrets, then connect with psql or any client from a service in the same project.
Install PostgreSQL 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 -
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 --name my-postgresTo put a service behind a domain at install, add
--domain SERVICE=HOST:levelrail-cli templates install postgres --name my-postgres --domain postgres=postgres.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.
Docs and upstream
More in Database Tools
- PostgreSQL with pgwebA 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.
- 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.