This will install TimescaleDB via
apt on Ubuntu distros.
Note: TimescaleDB requires PostgreSQL 12 or 13.
If you have another PostgreSQL installation not via
apt, this will likely cause problems.
If you wish to maintain your current version of PostgreSQL outside
apt, we recommend installing from source. Otherwise, please be
sure to remove non-
apt installations before using this method.
If you don't already have PostgreSQL installed, add PostgreSQL's third party repository to get the latest PostgreSQL packages (if you are using Ubuntu older than 19.04):
# `lsb_release -c -s` should return the correct codename of your OS echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -c -s)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update
Add TimescaleDB's third party repository and install TimescaleDB, which will download any dependencies it needs from the PostgreSQL repo:
# Add our PPA sudo add-apt-repository ppa:timescale/timescaledb-ppa sudo apt-get update # Now install appropriate package for PG version sudo apt install timescaledb-2-postgresql-13
If you are upgrading from TimescaleDB 1.x, the
apt package will first
uninstall the previous version of TimescaleDB and then install the latest TimescaleDB 2.0
binaries. The feedback in your terminal should look similar to the following:
Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: timescaledb-2-loader-postgresql-12 The following packages will be REMOVED: timescaledb-loader-postgresql-12 timescaledb-postgresql-12 The following NEW packages will be installed: timescaledb-2-loader-postgresql-12 timescaledb-2-postgresql-12 0 upgraded, 2 newly installed, 2 to remove and 11 not upgraded. Need to get 953 kB of archives. After this operation, 1314 kB of additional disk space will be used. Do you want to continue? [Y/n]
Once you confirm and install the newest binary package, you must still perform the EXTENSION update as discussed in Updating Timescale to 2.0.
There are a variety of settings that can be configured for your
new database. At a minimum, you will need to update your
file to include our library in the parameter
The easiest way to get started is to run
timescaledb-tune, which is
installed by default when using
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 now need to restart PostgreSQL:
# Restart PostgreSQL instance sudo service postgresql restart
Found an issue on this page?Report an issue!