Install self-hosted TimescaleDB from a pre-built container

warning

If you have already installed PostgreSQL using a method other than the pre-built container provided here, 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. instead.

  1. Install Docker, if you don’t already have it. For packages and instructions, see the .

  2. At the command prompt, run the TimescaleDB Docker image:

important

The image offers the most complete TimescaleDB experience. It includes the TimescaleDB Toolkit, and support for PostGIS and Patroni. If you need the smallest possible image, use the timescale/timescaledb:latest-pg14 image instead.

warning

If your system uses Linux Uncomplicated Firewall (UFW) for security rules, Docker could override your UFW port binding settings. Docker binds the container on Unix-based systems by modifying the Linux IP tables. If you are relying on UFW rules for network security, consider adding DOCKER_OPTS="--iptables=false" to /etc/default/docker to prevent Docker from overwriting the IP tables. For more information about this vulnerability, see Docker’s information about the UFW flaw.

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 timescaledb-tune script, which is included with the timescaledb-tools package. For more information, see the section.

The TimescaleDB HA Docker image includes as its operating system. The lighter-weight TimescaleDB (non-HA) image uses Alpine. The commands in this section use the TimescaleDB HA image, but the steps are the same for both.

You can use the Docker image in different ways, depending on your use case.

  2. docker run -d --name timescaledb -p 5432:5432 -e POSTGRES_PASSWORD=password timescale/timescaledb-ha:pg14-latest

The -p flag binds the container port to the host port. This means that anything that can access the host port can also access your TimescaleDB container, so it’s important that you set a PostgreSQL password using the POSTGRES_PASSWORD environment variable. Without that variable, the Docker container disables password checks for all database users.

If you want to access the container from the host but avoid exposing it to the outside world, you can bind to 127.0.0.1 instead of the public interface, using this command:

  2. docker run -d --name timescaledb -p 127.0.0.1:5432:5432 \
  4. -e POSTGRES_PASSWORD=password timescale/timescaledb-ha:pg14-latest

If you don’t want to install psql and other PostgreSQL client tools locally, or if you are using a Microsoft Windows host system, you can connect using the version of psql that is bundled within the container with this command:

  2. docker exec -it timescaledb psql -U postgres

Existing containers can be stopped using docker stop and started again with docker start while retaining their volumes and data. When you create a new container using the docker run command, by default you also create a new data volume. When you remove a Docker container with docker rm the data volume persists on disk until you explicitly delete it. You can use the docker volume ls command to list existing docker volumes. If you want to store the data from your Docker container in a host directory, or you want to run the Docker image on top of an existing data directory, you can specify the directory to mount a data volume using the -v flag. For example:

When you install TimescaleDB using a Docker container, the PostgreSQL settings are inherited from the container. In most cases, you do not need to adjust them. However, if you need to change a setting you can add -c setting=value to your Docker run command. For more information, see the .

The link provided in these instructions is for the latest version of TimescaleDB on PostgreSQL 14. To find other Docker tags you can use, see the Dockerhub repository.

When you have PostgreSQL and TimescaleDB installed, you can connect to it from your local system using the psql command-line utility. This is the same tool you might have used to connect to PostgreSQL before, but if you haven’t installed it yet, check out the installing psql section.

Setting up the TimescaleDB extension

important

If you installed TimescaleDB from the pre-built Docker container, then you probably already have the TimescaleDB extension, and you can skip this procedure.

    1. psql -U postgres -h localhost

    If your connection is successful, you’ll see a message like this, followed by the prompt:

    1. psql (13.3, server 12.8 (Ubuntu 12.8-1.pgdg21.04+1))
    3. SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
    5. Type "help" for help.
    6. tsdb=>

  2. At the psql prompt, create an empty database. Our database is called example:

    1. CREATE database example;

  3. Connect to the database you created:

  4. Add the TimescaleDB extension:

    1. CREATE EXTENSION IF NOT EXISTS timescaledb;

  5. You can now connect to your database using this command:

    1. psql -U postgres -h localhost -d example

You can check that the TimescaleDB extension is installed by using the \dx command at the psql prompt. It looks like this:

  2. tsdb=> \dx
  4. List of installed extensions
  6. -[ RECORD 1 ]------------------------------------------------------------------
  8. Name        | pg_stat_statements
  10. Version     | 1.7
  12. Schema      | public
  14. Description | track execution statistics of all SQL statements executed
  18. Name        | plpgsql
  19. Version     | 1.0
  21. Schema      | pg_catalog
  23. Description | PL/pgSQL procedural language
  25. -[ RECORD 3 ]------------------------------------------------------------------
  27. Name        | timescaledb
  29. Version     | 2.5.1
  31. Schema      | public
  33. Description | Enables scalable inserts and complex queries for time-series data
  35. -[ RECORD 4 ]------------------------------------------------------------------
  37. Name        | timescaledb_toolkit
  39. Version     | 1.3.1
  41. Schema      | public
  43. Description | timescaledb_toolkit

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 section.