Upgrading to 2.19.0

This note describes the necessary steps to upgrade to Stellio 2.19.0

Upgrade to TimescaleDB 2.17.2 and PostGIS 3.5

The Timescale extension has been upgraded to 2.17.2 and the PostGIS extension to 3.5. A new Docker image is available on DockerHub.

The general upgrade procedure is described in the Timescale documentation and more specifically in the Docker upgrade section.

If using the docker-compose configuration provided in the Stellio repository, the upgrade can be done in this way (do not forget to do a backup of the database before starting the upgrade!):

docker compose pull
docker compose up -d
docker exec -it stellio-postgres psql --host=localhost -d stellio_search -U stellio -W -X -c "ALTER EXTENSION timescaledb UPDATE;"
docker exec -it stellio-postgres psql --host=localhost -d stellio_search -U stellio -W -X -c "ALTER EXTENSION postgis UPDATE;"
docker exec -it stellio-postgres psql --host=localhost -d stellio_subscription -U stellio -W -X -c "ALTER EXTENSION timescaledb UPDATE;"
docker exec -it stellio-postgres psql --host=localhost -d stellio_subscription -U stellio -W -X -c "ALTER EXTENSION postgis UPDATE;"