yum Installation

This will install both TimescaleDB and PostgreSQL via yum (or dnf on Fedora).

Note: TimescaleDB requires PostgreSQL 12 or 13.

Prerequisites

  • RHEL/CentOS 7 (or Fedora equivalent) or later

Build and install

warning

If you have another PostgreSQL installation not via yum, this will likely cause problems. If you wish to maintain your current version of PostgreSQL outside of yum, we recommend installing from source. Otherwise please be sure to remove non-yum installations before using this method.

You’ll need to download the correct PGDG from PostgreSQL for your operating system and architecture and install it:

  1. # Download PGDG:
  2. sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-$(rpm -E %{rhel})-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Add TimescaleDB’s third party repository and install TimescaleDB, which will download any dependencies it needs from the PostgreSQL repo:

  1. # Add timescaledb repo
  2. sudo tee /etc/yum.repos.d/timescale_timescaledb.repo <<EOL
  3. [timescale_timescaledb]
  4. name=timescale_timescaledb
  5. baseurl=https://packagecloud.io/timescale/timescaledb/el/$(rpm -E %{rhel})/\$basearch
  6. repo_gpgcheck=1
  7. gpgcheck=0
  8. enabled=1
  9. gpgkey=https://packagecloud.io/timescale/timescaledb/gpgkey
  10. sslverify=1
  11. sslcacert=/etc/pki/tls/certs/ca-bundle.crt
  12. metadata_expire=300
  13. EOL
  15. sudo yum update -y
  17. # disable builtin postgres packages on CentOs 8
  18. if command -v dnf; then sudo dnf -qy module disable postgresql; fi
  20. # Now install appropriate package for PG version
  21. sudo yum install -y timescaledb-2-postgresql-13

Upgrading from TimescaleDB 1.x

If you are upgrading from TimescaleDB 1.x, the EXTENSION must be updated in the database as discussed in Updating Timescale to 2.0.

Configure your database

There are a variety of settings that can be configured for your new database. At a minimum, you will need to update your postgresql.conf file to include our library in the parameter shared_preload_libraries. The easiest way to get started is to run timescaledb-tune, which is installed by default when using yum:

  1. sudo timescaledb-tune

This will ensure that our extension is properly added to the parameter shared_preload_libraries as well as offer suggestions for tuning memory, parallelism, and other settings.

To get started you’ll need to restart PostgreSQL and add a postgres superuser (used in the rest of the docs). Please refer to your distribution for how to restart services, for example:

  1. sudo -u postgres service postgres-13 start