Context on the version upgrade

Once an automatic or manual maintenance update has been applied, the most recent TimescaleDB version is then made available within the underlying binaries in Managed Service for TimescaleDB, allowing users to go ahead and upgrade their instances. 

In other words, service maintenance updates will *not* automatically apply the following the "alter extension" command to the underlying databases, since the users code might depend on running the older version. In the case of this error message, your timescaleDB version must first be upgraded to 1.7 before upgrading to PG12


First, reconnect to your Managed Service for TimescaleDB instance using

psql -x <service connection string>

Then, upgrade the TimescaleDB version by running


To check that the version upgrade happened successfully, run


You will need to run ALTER EXTENSION on each database in your cluster individually, including the database named "_timescaledb" which is used for query performance recording.

If you find that this upgrade did not happen successfully, please contact [email protected] for assistance. Thank you!

Did this answer your question?