timescale/timescaledb

Get started with TimescaleDB in under 10 minutes. This guide will help you run TimescaleDB locally, create your first hypertable with columnstore enabled, write data to the columnstore, and see instant analytical query performance.

• How to run TimescaleDB with a one-line install or Docker command
• How to create a hypertable with columnstore enabled
• How to insert data directly to the columnstore
• How to execute analytical queries

• Docker installed on your machine
• 8GB RAM recommended
• psql client (included with PostgreSQL) or any PostgreSQL client like pgAdmin

You have two options to start TimescaleDB:

The easiest way to get started:

Important: This script is intended for local development and testing only. Do not use it for production deployments. For production-ready installation options, see the TimescaleDB installation guide.

Linux/Mac:

curl -sL https://tsdb.co/start-local | sh

This command:

• Downloads and starts TimescaleDB (if not already downloaded)
• Exposes PostgreSQL on port 6543 (a non-standard port to avoid conflicts with other PostgreSQL instances on port 5432)
• Automatically tunes settings for your environment using timescaledb-tune
• Sets up a persistent data volume

Alternatively, you can run TimescaleDB directly with Docker:

docker run -d --name timescaledb \
    -p 6543:5432 \
    -e POSTGRES_PASSWORD=password \
    timescale/timescaledb-ha:pg18

Note: We use port 6543 (mapped to container port 5432) to avoid conflicts if you have other PostgreSQL instances running on the standard port 5432.

Wait about 1-2 minutes for TimescaleDB to download & initialize.

Connect using psql:

psql -h localhost -p 6543 -U postgres
# When prompted, enter password: password