Upgrade TimescaleDB within Docker

To upgrade TimescaleDB within Docker, you need to download the upgraded image, stop the old container, and launch the new container pointing to your existing data.

1. Pull the latest TimescaleDB image

This command pulls the latest version of TimescaleDB running on Postgres 17:

If you're using another version of Postgres, look for the relevant tag in the TimescaleDB HA repository on Docker Hub.

1. Stop the old container, and remove it

2. Launch a new container with the upgraded Docker image

Launch based on your mount point type:

1. Connect to the upgraded instance using psql with the -X flag

2. At the psql prompt, use the ALTER command to upgrade the extension

The [TimescaleDB Toolkit][toolkit] extension is packaged with TimescaleDB HA, it includes additional hyperfunctions to help you with queries and data analysis.

If you have multiple databases, update each database separately.

1. Pull the latest TimescaleDB image

This command pulls the latest version of TimescaleDB running on Postgres 17.

If you're using another version of Postgres, look for the relevant tag in the TimescaleDB light repository on Docker Hub.

1. Stop the old container, and remove it

2. Launch a new container with the upgraded Docker image

Launch based on your mount point type:

1. Connect to the upgraded instance using psql with the -X flag

2. At the psql prompt, use the ALTER command to upgrade the extension

If you have multiple databases, you need to update each database separately.

===== PAGE: https://docs.tigerdata.com/self-hosted/upgrades/major-upgrade/ =====

Examples:

Example 1 (bash):

docker inspect timescaledb --format='{{range .Mounts }}{{.Type}}{{end}}'

Example 2 (bash):

docker inspect timescaledb --format='{{range .Mounts }}{{.Name}}{{end}}'

Example 3 (unknown):

069ba64815f0c26783b81a5f0ca813227fde8491f429cf77ed9a5ae3536c0b2c

Example 4 (bash):

docker inspect timescaledb --format='{{range .Mounts }}{{.Source}}{{end}}'