Starting with Xpress Insight Server 4.7.2, the supported database has changed from PostgreSQL 9.1 to PostgreSQL 9.5. If you have an installation of Xpress Insight that is version 4.7.1 or earlier it will be running with PostgreSQL 9.1, and your data will need to be migrated prior to upgrade of Xpress Insight Server.
Migration scripts are provided alongside the
Xpress Insight Server installer. You need both versions of PostgreSQL to be available before starting the migration.
Follow these steps to migrate your existing Xpress Insight data:
- 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.
- Install PostgreSQL 9.5 following the instructions in the section PostgreSQL for RHEL .
- Run the migration script from the Xpress Insight Server installer directory: ./postgresql-migration-91-to-95.sh
- 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.
- 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.
- 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.
- 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.
- The migration script will output a post-migration step you can perform after you are happy that your data was migrated correctly.
