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.

For upgrading to a new major version, for example upgrading from TimescaleDB 1 to TimescaleDB 2, see the major upgrades section.

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.

Try for free

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.

This upgrade uses the PostgreSQL ALTER EXTENSION function to upgrade to the latest version of the TimescaleDB extension. TimescaleDB supports having different extension versions on different databases within the same PostgreSQL instance. This allows you to upgrade extensions independently on different databases. Run the ALTER EXTENSION function on each database to upgrade them individually.

  1. Connect to psql using the -X flag. This prevents any .psqlrc commands from accidentally triggering the load of a previous TimescaleDB version on session startup.

  2. At the psql prompt, upgrade the TimescaleDB extension. This must be the first command you execute in the current session:

    ALTER EXTENSION timescaledb UPDATE;
  3. Check that you have upgraded to the latest version of the extension with the \dx command. The output should show the upgraded version number.

    \dx timescaledb
    Note

    To upgrade TimescaleDB in a Docker container, see the Docker container upgrades section.

Keywords

Found an issue on this page?

Report an issue!