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:
-
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 Red Hat Enterprise Linux.
-
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. It 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. It 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 be migrated it 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 once you are happy that you data was migrated correctly.
