Update TimescaleDB

Updating TimescaleDB 1.x

Use these instructions to update TimescaleDB within the 1.x version.

TIP:TimescaleDB 2.0 is currently available as a release candidate and we encourage users to upgrade in testing environments to gain experience and provide feedback on new and updated features.

See Changes in TimescaleDB 2.0 for more information and links to installation instructions

TimescaleDB Release Compatibility

TimescaleDB 1.x is currently supported by the following PostgreSQL releases.

If you need to upgrade PostgreSQL first, please see our documentation.

Update TimescaleDB

Software upgrades use PostgreSQL’s ALTER EXTENSION support to update to the latest version. TimescaleDB supports having different extension versions on different databases within the same PostgreSQL instance. This allows you to update extensions independently on different databases. The upgrade process involves three-steps:

1. We recommend that you perform a backup of your database via pg_dump.
2. Install the latest version of the TimescaleDB extension.
3. Execute the following psql command inside any database that you want to update:

ALTER EXTENSION timescaledb UPDATE;

WARNING:When executing ALTER EXTENSION, you should connect using psql with the -X flag to prevent any .psqlrc commands from accidentally triggering the load of a previous TimescaleDB version on session startup. It must also be the first command you execute in the session.

This will upgrade TimescaleDB to the latest installed version, even if you are several versions behind.

After executing the command, the psql \dx command should show the latest version:

\dx timescaledb
    Name     | Version |   Schema   |                             Description
-------------+---------+------------+---------------------------------------------------------------------
 timescaledb | 1.7.4   | public     | Enables scalable inserts and complex queries for time-series data
(1 row)