Self-host TimescaleDB on a VPS
PostgreSQL with the TimescaleDB extension for time series data, with a persistent volume and a generated password. The core is Apache-2.0 and some features fall under the Timescale License. It is not published on the host, so reach it from other services in this project at timescaledb:5432.
levelrail-cli templates install timescaledb --name my-timescaledbSpecification
- Status
- Listed
- Category
- Database Tools
- Services
- timescaledb
- Ports
- 5432
- Volumes
- 1
- Memory
- about 512 MiB
- arm64
- unknown
- amd64
- unknown
- Settings to fill in
- none
- Listing
- Community template
About TimescaleDB
PostgreSQL with the TimescaleDB extension for time series data, with a persistent volume and a generated password. The core is Apache-2.0 and some features fall under the Timescale License. It is not published on the host, so reach it from other services in this project at timescaledb:5432.
What it deploys
TimescaleDB runs as one service in a single Compose app, listening on port 5432, with 1 named volume mount.
| Service | Image | Tag | Ports | Volumes |
|---|---|---|---|---|
| timescaledb | timescale/timescaledb | 2.30.2-pg17 | 5432 | tsdata -> /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 |
|---|---|---|
| timescaledb | POSTGRES_DB | Preset by the template |
| timescaledb | POSTGRES_PASSWORD | Generated at deploy |
| timescaledb | POSTGRES_USER | Preset by the template |
First run
- Read the generated password from the app secrets, connect from a service in the same project, The extension is already created in the default database. Run CREATE EXTENSION IF NOT EXISTS timescaledb in any other database you add.
Install TimescaleDB 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 timescaledb -
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 timescaledb --name my-timescaledbTo put a service behind a domain at install, add
--domain SERVICE=HOST:levelrail-cli templates install timescaledb --name my-timescaledb --domain timescaledb=timescaledb.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 TimescaleDB.
Docs and upstream
More in Database Tools
- TiDBA MySQL compatible distributed SQL database, run here as a single node on local storage for development and testing. Apache-2.0 licensed. The root user has no password, so keep it private.
- SurrealDBA multi-model database for documents, graphs and relations with a SQL-like query language, using the RocksDB engine on a named volume. The root password is generated at install. Source available under the BSL.
- ValkeyA Redis-compatible in-memory key-value store under the Linux Foundation, with password auth and append-only persistence.
- SQLPadWeb based SQL editor for running queries against many databases, with saved queries, charts and sharing. The admin account is created from the install form.
- WeaviateAn open-source vector database with hybrid search, built-in modules, and a GraphQL and REST API.
- SonicFast, lightweight schema less search index server that stores identifiers instead of documents. The install form carries config.cfg as an editable file and a generated channel password.