1
Step 1Open the server Apps tab
Select the tutorial-vps VPS, open the Apps tab, and start a new app deployment. Keep sensitive server details hidden before capturing or sharing screenshots.
Back to all templates
TimescaleDB
Database512MB+ RAM
Time-series database built on PostgreSQL for metrics and analytics
databasetimeseriespostgresanalytics
Deploy TimescaleDB in 3 Steps
1
Connect Your VPS
Add your server credentials to Server Compass
2
Select TimescaleDB
Choose from our template library
3
Deploy & Configure
Fill in settings and click Deploy
No Docker knowledge required
Step-by-step deployment guide
Deploy TimescaleDB on a VPS with Server Compass
Use the TimescaleDB template in Server Compass to deploy a PostgreSQL time-series database on your VPS, then verify the deployed database with pg_isready.
About 10 minutesBrowser verified
2
Step 2Choose an app template
Click New App and choose the template deployment path so Server Compass can load the built-in catalog.
3
Step 3Search for TimescaleDB
Use the template picker search to find TimescaleDB in the Server Compass template catalog.
4
Step 4Select the TimescaleDB template
Choose the TimescaleDB template. Server Compass fills the TimescaleDB PostgreSQL container, persistent data volume, host port, username, database name, and generated password.
5
Step 5Review the TimescaleDB settings
Confirm the app name and compose service. In this run, the app was named timescaledb-demo and used host port 5432.
6
Step 6Deploy TimescaleDB
Review the generated environment values, keep the database password masked, confirm the web port is available, and click Deploy Now.
7
Step 7Watch the deployment progress
Keep the deployment modal open while Server Compass uploads the compose file, pulls the TimescaleDB image, starts the container, and verifies the stack.
8
Step 8Confirm TimescaleDB is running
After deployment finishes, return to the Apps tab and confirm the TimescaleDB app is marked Running with the database port available.
9
Step 9Verify TimescaleDB is reachable
Open the app detail view and verify the running TimescaleDB container. In this tutorial run, pg_isready confirmed the database service was accepting connections without exposing the generated password.
After TimescaleDB Opens
- Store the generated PostgreSQL password in a secure password manager.
- Create application-specific roles and databases before production use.
- Restrict external access to port 5432 unless remote clients explicitly need it.
- Configure regular backups for the TimescaleDB data volume before storing production data.
- Create TimescaleDB hypertables and retention policies for time-series workloads.
Verified Result
The TimescaleDB container returned a successful pg_isready result inside the deployed container.
TimescaleDB deployment questions
What does the TimescaleDB template deploy?
It deploys the TimescaleDB PostgreSQL 16 container with a persistent data volume, configured database name, configured username, and generated password.
Which port did the tutorial use?
The tutorial used host port 5432, which maps to TimescaleDB container port 5432.
Why is there no browser verification screenshot?
TimescaleDB is a database service, not a web application. The tutorial verifies it with pg_isready inside the running container instead of opening a browser page.
Should this become a blog post?
No. The deployment guide should live on the TimescaleDB template detail page and be linked from the reusable template deployment docs page.
Command Line Setup
Install TimescaleDB Manually
Set up TimescaleDB yourself using Docker Compose and the command line.
1
Log into Your Server
Access your server's command line by opening a terminal and running the SSH command below.
terminal
# SSH into your server
ssh root@your-server-ip
# Using a custom SSH key
ssh -i ~/.ssh/id_rsa root@your-server-ipFirst time? Need Docker? Install it: curl -fsSL https://get.docker.com | sh
2
Prepare the Install Location
Set up the folder structure for your Docker deployment.
terminal
# Create and navigate to project directory
mkdir -p ~/apps/timescaledb
cd ~/apps/timescaledb3
Create docker-compose.yml
Set up your Docker Compose file with this configuration:
docker-compose.yml
services:
timescaledb:
image: timescale/timescaledb:latest-pg16
ports:
- "5432:5432"
environment:
- POSTGRES_USER=postgres
- POSTGRES_PASSWORD=<your-postgres-password>
- POSTGRES_DB=timeseries
volumes:
- timescaledb_data:/var/lib/postgresql/data
restart: unless-stopped
healthcheck:
test: ["CMD-SHELL", "pg_isready -U postgres -d timeseries"]
interval: 10s
timeout: 5s
retries: 5
volumes:
timescaledb_data:
Configuration Options
PORTHost port(default: 5432)POSTGRES_USERUsername(default: postgres)POSTGRES_PASSWORDPasswordPOSTGRES_DBDatabase(default: timeseries)4
Run the Deployment
Start all services defined in your compose file.
terminal
# Start the containers in detached mode
docker compose up -d
# Check if containers are running
docker compose ps
# View logs
docker compose logs -f5
Configure Network Access
Open the port so you can access the application externally.
terminal
# Allow the application port through firewall
sudo ufw allow 5432/tcp
sudo ufw reload
# Access your app at:
# http://your-server-ip:5432Skip the Terminal
Want one-click deploys? Try Server Compass.
No terminal needed. Deploy TimescaleDB through a visual dashboard with automatic configuration.
- Visual configuration UI
- One-click deployment
- Automatic SSL setup
- Zero-downtime updates
- Built-in monitoring
- One-click rollbacks
Download Server Compass$29 one-time • Lifetime license
After Deployment
After deploying TimescaleDB with Server Compass, complete these steps to finish setup
1
Enable TimescaleDB extension: CREATE EXTENSION IF NOT EXISTS timescaledb;
2
Create hypertables for time-series data
Need help? Check out our documentation for detailed guides.
TimescaleDB FAQ
Common questions about self-hosting TimescaleDB
How do I deploy TimescaleDB with Server Compass?
Simply download Server Compass, connect to your VPS, and select TimescaleDB from the templates list. Fill in the required configuration and click Deploy. The entire process takes under 3 minutes.
What are the system requirements for TimescaleDB?
TimescaleDB requires a minimum of 512MB RAM. We recommend a VPS with at least 1024MB RAM for optimal performance. Any modern Linux server with Docker support will work.
Can I migrate my existing TimescaleDB data?
Yes! Server Compass provides volume mapping that allows you to import existing data. You can also use standard TimescaleDB backup and restore procedures.
How do I update TimescaleDB to the latest version?
Server Compass makes updates easy. Simply click the Update button in your deployment dashboard, and the latest TimescaleDB image will be pulled and deployed with zero downtime.
Is TimescaleDB free to self-host?
TimescaleDB is open-source software. You only pay for your VPS hosting (typically $5-20/month) and optionally Server Compass ($29 one-time). No subscription fees or per-seat pricing.
Ready to Self-Host TimescaleDB?
Download Server Compass and deploy TimescaleDB to your VPS in under 3 minutes. No Docker expertise required.
Download Server Compass