Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Supported databases and versions

DatabaseOldest supported versionNewest supported version
PostgreSQL9.217.0
MariadDB 5.511.6
MYSQL5.79.0
MSSQL14.0 (from 2017)16.0 (from 2022)
HSQLNOT RELEVANTNOT RELEVANT

Recommended DB settings:

For optimal performance and compatibility of your database with Unimus you can find recommend DB settings it he following table.
In case your database use any other collation, please make sure to choose one that is always case-insensitive.

DatabaseCharacters setCollation
PostgreSQLutf8C (equivalent to POSIX)
MariadDB utf8mb4utf8mb4_unicode_ci
MYSQLutf8mb4utf8mb4_unicode_ci
MSSQLUCS-2 / UTF-16

Latin1_General_CI

SQL_Latin1_General_CP1_CI

HSQLNOT RELEVANTNOT RELEVANT

Using this combination ensures better global language support and consistent case-insensitive behavior in text comparisons.

Step by step for PostgreSQL migration:

Before you start with migration and for more information related to PostgreSQL we highly recommend to visit visit the official page: https://www.postgresql.org/docs/9.0/migration.html 

Upgrading PostgreSQL from Version 11 to 12+

  • Prepare the new database:
    • Set up your new PostgreSQL 12+ instance where the data will be migrated.
  • Stop both databases:
    • Make sure to stop both the old (PostgreSQL 11) and the new (PostgreSQL 12+) databases to avoid any conflicts during migration.
  • Access PostgreSQL:

    • Log in to your old PostgreSQL 11 database and run the following commands:

      • ALTER TABLE backup SET WITHOUT OIDS;

      • ALTER TABLE push_output_group SET WITHOUT OIDS;

    • These commands ensure that tables containing OIDs are altered to be compatible with newer versions of PostgreSQL (tables no longer support OIDs in version 12+). No errors should occur when executing them.
  • Pre-check the upgrade:

    • Run the following command to check if your system is ready for the upgrade:

      • pg_upgrade --check

    • This will confirm whether the upgrade can proceed without issues.
  • Backup the old database:
    • Make sure to create a full dump of your old database for safekeeping, using the pg_dump command.
  • Migrate the data:

    • After ensuring everything is in order, migrate your data from PostgreSQL 11 to 12+ using:
      • pg_upgrade

Upgrading PostgreSQL from Version 12 to 16

  • Backup Your Old Database:
    • Before starting the migration, create a full dump of your old PostgreSQL 12 database. This step ensures you have a backup in case anything goes wrong during the upgrade process.
  • Check Compatibility:

    • Ensure that both your old (PostgreSQL 12) and new (PostgreSQL 16) databases are compatible for migration. You can do this by running the following command:

      • pg_upgrade --check

    • This command will verify that the upgrade can proceed without any issues.
  • Migrate the Data:

    • Once you have confirmed compatibility, you can proceed with the migration using:
      • pg_upgrade