Upgrading from PostgreSQL 11.x to PostgreSQL 14.5

Tines now supports PostgreSQL 14, from Tines v15.0 onwards. Starting with Tines v15.1.0 we also ship with a script to automatically upgrade your docker compose setup from PostgreSQL 11.x to PostgreSQL 14.5.

Note: Since PostgreSQL 11 will be unsupported after November 9, 2023, we will be discontinuing support for PostgreSQL 11.x at or before that date.

You can follow the below steps to perform the PostgreSQL upgrade:

  • Upgrade to the release v15.1.0 or later by following the steps here

  • Navigate to the install directory after the upgrading to v15.1 (typically /opt/tines)

  • Run ./upgrade-postgresql11.sh. Few notes:

    • This will perform a docker compose down a few times.

    • Depending on the size of the database, this can take anywhere between 2 mins to 30 mins.

    • It is recommended to take a snapshot of the instance before performing.

    • In case the process fails mid way, you can execute the following to restore to the previous database: ./upgrade-postgresql11.sh -r

  • That's all: in the end your docker-compose.yml will have been updated to point the PostgreSQL 14.5 image and all the data imported into the new volume as well.

Was this helpful?