Install TimescaleDB on Linux

TimescaleDB is a PostgreSQL extension for time series and demanding workloads that ingest and query high volumes of data.

Want to skip these steps?

Deploy a Timescale service in the cloud. We tune your database for performance and handle scalability, high availability, backups and management so you can relax.

Try for free

This section shows you how to:

Install and configure TimescaleDB on PostgreSQL - set up a self-hosted PostgreSQL instance to efficiently run TimescaleDB.
Set up TimescaleDB on a database - enable TimescaleDB features and performance improvements on a database.

Warning

If you have previously installed PostgreSQL without a package manager, you may encounter errors following these install instructions. Best practice is to full remove any existing PostgreSQL installations before you begin.

To keep your current PostgreSQL installation, Install from source.

Install and configure TimescaleDB on PostgreSQL

Best practice for self-hosting TimescaleDB is to install the latest version of PostgreSQL and TimescaleDB on a supported platform using the packages supplied by Timescale.

Debian, Ubuntu

Red Hat, Fedora

ArchLinux

Install the latest PostgreSQL packages


sudo apt install gnupg postgresql-common apt-transport-https lsb-release wget

Run the PostgreSQL package setup script


sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

Add the TimescaleDB package

Debian

Ubuntu


echo "deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main" | sudo tee /etc/apt/sources.list.d/timescaledb.list

Install the TimescaleDB GPG key
```
wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/timescaledb.gpg
```
For Ubuntu 21.10 and earlier use the following command:
wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add -
Update your local repository list
```
sudo apt update
```
Install TimescaleDB
```
sudo apt install timescaledb-2-postgresql-16 postgresql-client
```
To install a specific TimescaleDB release, set the version. For example:
sudo apt-get install timescaledb-2-postgresql-14='2.6.0*' timescaledb-2-loader-postgresql-14='2.6.0*'
Older versions of TimescaleDB may not support all the OS versions listed on this page.
Tune your PostgreSQL instance for TimescaleDB
```
sudo timescaledb-tune
```
This script is included with the timescaledb-tools package when you install TimescaleDB. For more information, see configuration.
Restart PostgreSQL
```
sudo systemctl restart postgresql
```
Login to PostgreSQL as postgres
```
sudo -u postgres psql
```
You are in the psql shell.
Set the password for postgres
```
\password postgres
```
When you have set the password, type \q to exit psql.

Job jobbed, you have installed PostgreSQL and TimescaleDB.

Set up TimescaleDB on a database

For improved performance, you enable TimescaleDB on each database on your self-hosted PostgreSQL instance. This section shows you how to enable TimescaleDB for a new database in PostgreSQL using psql from the command line.

Connect to your PostgreSQL instance
```
psql -U postgres -h localhost
```
Create a database
```
CREATE DATABASE tsdb;
```
Connect to the database
```
\c tsdb
```

Add TimescaleDB to the database


CREATE EXTENSION IF NOT EXISTS timescaledb;

Check that TimescaleDB is installed

\dx

You see the list of installed extensions:


List of installed extensions
Name     | Version |   Schema   |                                      Description                                      
-------------+---------+------------+---------------------------------------------------------------------------------------
plpgsql     | 1.0     | pg_catalog | PL/pgSQL procedural language
timescaledb | 2.14.2  | public     | Enables scalable inserts and complex queries for time-series data (Community Edition)

Press q to exit the list of extensions.

And that is, you have TimescaleDB running on a database on a self-hosted instance of PostgreSQL.

Where to next

Now you have TimescaleDB running, have a look at the:

Tutorials: walk through a variety of business scenarios using example datasets.
Use Timescale: browse the features available with TimescaleDB.

Supported platforms

TimescaleDB is supported on the following platforms:

Debian	Ubuntu	Red Hat Enterprise	Fedora	Rocky Linux
Debian 10 Buster	Ubuntu 20.04 LTS Focal Fossa	Red Hat Enterprise Linux 7	Fedora 33	Rocky Linux 8
Debian 11 Bullseye	Ubuntu 22.04 LTS Jammy Jellyfish	Red Hat Enterprise Linux 8	Fedora 34	Rocky Linux 9
Debian 12 Bookworm	Ubuntu 23.04 Lunar Lobster	Red Hat Enterprise Linux 9	Fedora 35

Install TimescaleDB on Linux

Want to skip these steps?

Warning

Install and configure TimescaleDB on PostgreSQL

Set up TimescaleDB on a database

Where to next

Supported platforms

Related Content