Initializing help system before first use

Migrating Data from Earlier Versions of Xpress Insight

Starting with Xpress Insight Server 4.7.2, the supported database has changed to PostgreSQL 9.5. If you have an existing installation it will be running with PostgreSQL 9.1, and your data will need to be migrated prior to upgrade of Xpress Insight Server.
Alongside the Xpress Insight Server installer, a migration script is provided. You need both versions of PostgreSQL to be available before starting the migration.

Follow these steps to migrate your existing Xpress Insight data:

  1. Keep your existing PostgreSQL 9.1 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 9.5 following the instructions in the section PostgreSQL for RHEL .
  3. Run the migration script from the Xpress Insight Server installer directory: ./postgresql-migration-91-to-95.sh
  4. You will be prompted for the bin directory and the data directory of PostgreSQL 9.1. 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 9.5. 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 9.5 data directory will be replaced.
    The script will commence migration of the data. First it will drop the mirror database from the PostgreSQL 9.1 database. Then it will make sure both the PostgreSQL 9.1 and the PostgreSQL 9.5 services are stopped.
  7. After the data has successfully been migrated, the migration script will configure the PostgreSQL 9.5 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 Installation on Red Hat Enterprise Linux (RHEL)

© 2001-2020 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.