A major upgrade is when you upgrade from one major version of TimescaleDB, to the next major version. For example, when you upgrade from TimescaleDBÂ 1 to TimescaleDBÂ 2.
A minor upgrade is when you upgrade within your current major version of TimescaleDB. For example, when you upgrade from TimescaleDBÂ 2.5 to TimescaleDBÂ 2.6.
If you originally installed TimescaleDB using Docker, you can upgrade from within the Docker container. For more information, and instructions, see the Upgrading with Docker section.
Important
When you upgrade the timescaledb
extension, the experimental schema is removed by default. To use experimental features after an upgrade, you need to add the experimental schema again.
Try for free on Timescale
Timescale is a fully managed service with automatic backup and restore, high availability with replication, seamless scaling and resizing, and much more. You can try Timescale free for thirty days.
You can upgrade your self-hosted Timescale installation in-place. This means that you do not need to dump and restore your data. However, it is still important that you plan for your upgrade ahead of time.
Before you upgrade:
- Read the release notes for the Timescale version you are upgrading to.
- Check which PostgreSQL version you are currently running. You might need to upgrade to the latest PostgreSQL version before you begin your Timescale upgrade.
- Perform a backup of your database. While Timescale upgrades are performed in-place, upgrading is an intrusive operation. Always make sure you have a backup on hand, and that the backup is readable in the case of disaster.
Note
If you use the Timescale Toolkit, ensure the timescaledb_toolkit
extension is on version 1.6.0, then upgrade the timescaledb
extension. If required, you can then later upgrade the timescaledb_toolkit
extension to the most recent version.
You can check which version of TimescaleDB you are running, at the psql command prompt. Use this to check which version you are running before you begin your upgrade, and again after your upgrade is complete:
\dx timescaledbName | Version | Schema | Description-------------+---------+------------+---------------------------------------------------------------------timescaledb | x.y.z | public | Enables scalable inserts and complex queries for time-series data(1 row)
Keywords
Found an issue on this page?Report an issue or Edit this page in GitHub.