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. 10. 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.
Note These are RHEL 7 commands. RHEL 6 users must translate the service commands into the old form.
This script requires both the source and target versions of PostgreSQL are available before starting the migration. It leaves the previous PostgreSQL data intact to provide a fallback position if required, however you should create a backup of your existing repository before attempting migration as good practice.

Perform 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. Stop the existing version of PostgreSQL 9.5 so that the new version of PostgreSQL can be installed and configured, using the following command: 
    systemctl stop postgresql-9.5
  3. Install and configure PostgreSQL 11.10 following the instructions in the section PostgreSQL for RHEL .
  4. Run the migration script from the Xpress Insight Server installer directory: ./postgresql-migration-95-to-11.sh. The script will stop the database services if they are running, and startup the PostgreSQL 11.10 service at the end.
  5. 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.
  6. You will be prompted for the bin directory and the data directory of PostgreSQL 11.10. The migration script will then verify these paths point to the expected version of PostgreSQL.
  7. The migration script will prompt you twice to proceed. This precaution is made because the data in the target PostgreSQL 11.10 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. 10 services are stopped.
  8. After the data has successfully been migrated, the migration script will configure the PostgreSQL 11.10 service to start on boot and then start it immediately.
  9. The migration script will output a post-migration step you can perform after you are happy that your data was migrated correctly.
Covered Topics
Parent Topic Migrating Data from Earlier Versions of Xpress Insight Server