Install self-hosted TimescaleDB on Debian-based systems
You can host TimescaleDB yourself, on your Debian or Ubuntu system. These
instructions use the
apt package manager on these distributions:
- Debian 9 Stretch
- Debian 10 Buster
- Debian 11 Bullseye
- Ubuntu 18.04 LTS Bionic Beaver
- Ubuntu 20.04 LTS Focal Fossa
- Ubuntu 22.04 LTS Jammy Jellyfish
If you have already installed PostgreSQL using a method other than the
apt package manager, you could encounter errors following these instructions. It is safest to remove any existing PostgreSQL installations before you begin. If you want to keep your current PostgreSQL installation, do not install TimescaleDB using this method. Install from source instead.
At the command prompt, as root, add the PostgreSQL third party repository to get the latest PostgreSQL packages:apt install gnupg postgresql-common apt-transport-https lsb-release wget
Run the PostgreSQL repository setup script:/usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
Add the TimescaleDB third party repository:
Install Timescale GPG keywget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add -
For Ubuntu 21.10 and later use this command to install Timescale GPG key
wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/timescaledb.gpg
Update your local repository list:apt update
Install TimescaleDB:apt install timescaledb-2-postgresql-14
If you want to install a specific version of TimescaleDB, instead of the most recent, you can specify the version like this:
apt-get install timescaledb-2-postgresql-12='2.6.0*' timescaledb-2-loader-postgresql-12='2.6.0*'
You can see the full list of TimescaleDB releases by visiting our releases page. Note that older versions of TimescaleDB don't always support all the OS versions listed above.
When you have completed the installation, you need to configure your database so
that you can use it. The easiest way to do this is to run the
script, which is included with the
timescaledb-tools package. Run the
timescaledb-tune script using the
sudo timescaledb-tune command. For more
information, see the configuration section.
When you have PostgreSQL and TimescaleDB installed, you can connect to it from
your local system using the
psql command-line utility.
You can use the
apt package manager on Debian and Ubuntu systems to install
- Make sure your
aptrepository is up to date:apt-get update
- Install the
postgresql-clientpackage:apt-get install postgresql-client
Restart PostgreSQL and create the TimescaleDB extension:
Restart the service after enabling TimescaleDB with
timescaledb-tune:systemctl restart postgresql
On your local system, at the command prompt, connect to the PostgreSQL instance as the
postgressuperuser:-u postgres psql
If your connection is successful, you'll see a message like this, followed by the
psqlprompt:psql (15.0 (Ubuntu 15.0-1.pgdg20.04+1), server 14.5 (Ubuntu 14.5-2.pgdg20.04+2))SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)Type "help" for help.
Set the password for the
Exit from PostgreSQL:\q
psqlclient to connect to PostgreSQL:psql -U postgres -h localhost
psqlprompt, create an empty database. Our database is called
tsdb:CREATE database tsdb;
Connect to the database you created:\c tsdb
Add the TimescaleDB extension:CREATE EXTENSION IF NOT EXISTS timescaledb;
Check that the TimescaleDB extension is installed by using the
\dxcommand at the
psqlprompt. Output is similar to:tsdb-# \dxList of installed extensionsName | Version | Schema | Description-------------+---------+------------+-------------------------------------------------------------------plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural languagetimescaledb | 2.7.0 | public | Enables scalable inserts and complex queries for time-series data(2 rows)
After you have created the extension and the database, you can connect to your database directly using this command:
psql -U postgres -h localhost -d tsdb
Now that you have your first TimescaleDB database up and running, you can check out the TimescaleDB section in our documentation, and find out what you can do with it.
If you want to work through some tutorials to help you get up and running with TimescaleDB and time-series data, check out our tutorials section.
You can always contact us if you need help working something out, or if you want to have a chat.
Found an issue on this page?Report an issue!