Update TimescaleDB versions
Update your TimescaleDB version with an in-place update. By updating in-place, you don't need to dump and restore your data. Automated migration scripts handle conversion of internal states where needed.
TimescaleDB supports the following PostgreSQL releases. If you aren't running a compatible release, update PostgreSQL before updating TimescaleDB. To learn more, see the sections on updating PostgreSQL in Timescale Cloud, Managed Service for TimescaleDB, and self-hosted TimescaleDB.
|TimescaleDB release||Supported PostgreSQL releases|
|1.7||9.6, 10, 11, 12|
|2.1-2.3||11, 12, 13|
|2.5+||12, 13, 14|
To make sure your update completes properly, update PostgreSQL and TimescaleDB separately. Keep PostgreSQL and TimescaleDB versions compatible throughout the process. If your update spans multiple versions, this could require several steps.
For example, if you're currently running PostgreSQL 10 and TimescaleDB 1.7.5, and you want to update to PostgreSQL 13 and TimescaleDB 2.2:
- Upgrade PostgreSQL 10 to PostgreSQL 12
- Update TimescaleDB 1.7.5 to TimescaleDB 2.2 on PostgreSQL 12
- Upgrade PostgreSQL 12 to PostgreSQL 13 with TimescaleDB 2.2 installed
Update TimescaleDB by using PostgreSQL's
ALTER EXTENSION command. You can run
different TimescaleDB versions on different databases within the same PostgreSQL
instance. You can also update your extensions independently on different
Install the latest version of the TimescaleDB extension.
Connect to your database with a PostgreSQL client. This example uses
psql, but any client works. If you're using
psql, connect with the
-Xflag. This prevents any commands in
.psqlrcfrom loading a previous TimescaleDB version on session startup.
psql -X "postgres://<USERNAME>:<PASSWORD>@<HOST>:<PORT>/<DB_NAME>?sslmode=require"
Do not run any other commands before continuing to the next step.
psqlprompt, upgrade TimescaleDB to the latest installed version:
ALTER EXTENSION timescaledb UPDATE;
This upgrades TimescaleDB to the latest installed version, even if you're several versions behind. To update to a version that's not the latest installed version, specify the version number, like this:
ALTER EXTENSION timescaledb UPDATE TO '2.5.1';
Verify that the upgrade worked by running
\dx timescaledbto see the version number of the extension.
\dx timescaledb Name | Version | Schema | Description ------------+---------+------------+--------------------------------------------------------------------- timescaledb | x.y.z | public | Enables scalable inserts and complex queries for time-series data (1 row)
If you encounter a problem immediately after upgrading, you can roll back your upgrade. To learn more, see the section on downgrading TimescaleDB.
Found an issue on this page?Report an issue!