Introduction

An upgrade of the CTA catalogue database involves these steps:

• Run cta-catalogue-schema-verify to verify that the starting version of the schema is correct and that the schema definition matches what is in the DB
• Use Liquibase to perform the upgrade. Liquibase reads the set of changes to execute from a changelog file in the CTA git repository.
• Run cta-catalogue-schema-verify to verify that the schema upgrade was successful

The recommended way to upgrade is to use the schema upgrade container provided by the CTA team. All the required tools are provided in the container, giving a seamless one-click upgrade procedure.

The procedure for a manual upgrade is also described here for completeness.