Initializing help system before first use

Migrating Data from Xpress Insight Server 4.53.2 to Xpress Insight Server 4.54

Starting with Xpress Insight Server 4.54, the supported database has changed to PostgreSQL 11. 8. An earlier installation of Xpress Insight Server will be running either PostgreSQL 9.1 or PostgreSQL 9.5, and your data will need to be migrated prior to upgrade of Xpress Insight Server.
This script requires both the source and target versions of PostgreSQL are available before starting the migration.

Follow these steps to migrate your existing Xpress Insight data:

  1. Keep your existing PostgreSQL 9.5 installation intact until you have completed the migration of your existing data and verified it in the upgraded version of Xpress Insight.
  2. Install PostgreSQL 11.8 following the instructions in the section PostgreSQL for RHEL .
  3. Run the migration script from the Xpress Insight Server installer directory: ./postgresql-migration-95-to-118.sh
  4. You will be prompted for the bin directory and the data directory of PostgreSQL 9.5. The migration script will then verify these paths point to the expected version of PostgreSQL.
  5. You will be prompted for the bin directory and the data directory of PostgreSQL 11.8. The migration script will then verify these paths point to the expected version of PostgreSQL.
  6. The migration script will prompt you twice to proceed. This precaution is made because the data in the target PostgreSQL 11.8 data directory will be replaced.
    The script will commence migration of the data. First it will drop the mirror database from the PostgreSQL 9.5 database. Then it will make sure both the PostgreSQL 9.5 and the PostgreSQL 11. 8 services are stopped.
  7. After the data has successfully been migrated, the migration script will configure the PostgreSQL 11.8 service to start on boot and then start it immediately.
  8. The migration script will output a post-migration step you can perform after you are happy that your data was migrated correctly.
Parent Topic Migrating Data from Earlier Versions of Xpress Insight Server