Skip to main content

Upgrade DBMS PostgreSQL

The DBMS supplied by KIX for new installations has been PostgreSQL version 15 since v34. Existing installations are currently not changed automatically. However, PostgreSQL 12 will be removed from the DB service by the turn of the year 2025/2026  at the latest.

Caution

If you fail to update, your KIX will no longer start. Please update your KIX environment!

If you already have a new KIX installation from v34, no upgrade is required, as KIX from v34 is delivered with PostgreSQL 15.

Perform DBMS upgrade PG12 to PG15

The upgrade requires manual involvement. It will take time and resources depending on the size of the database.

Make sure you have enough free storage space (recommendation: three times the DB size).

Plan a necessary downtime (orientation values indicate a duration of 3 to 4 minutes per 10 GB database size).

Find out more about Backup and restore from KIX beforehand.

  1. Preparation

    1. Update KIX to V34+.

      Do not yet activate any changes to the DBMS.

    2. Register downtime

    3. Make sure that there is sufficient free storage space on the DB storage.

      They require approx. two to three times the size of the current DB size.

  2. Execute upgrade

    1. Stop KIX stack

    2. Add the following line to the file environment:

      POSTGRES_UPGRADE_TO_15=yes

    3. Restart the KIX stack.

      Depending on the size of the database, this may take a while. Please wait until then.

  3. Complete upgrade

    • In the file environment, remove the previously inserted line

      POSTGRES_UPGRADE_TO_15=yes

No more DBMS upgrades will be attempted at the next start.

In this section: