Uploading and unpacking the migration archive

While in the ~/backup folder, run the following commands:

wget https://archive.eltex-co.ru/evi-raw/evi-1.4.0/db_migration-1.3.0-1.4.0.zip
unzip db_migration-1.3.0-1.4.0.zip
cd db_migration-1.3.0-1.4.0

Removing the EVI Platform 1.3.1 

sudo apt purge evi-core-web evi-core evi-scud evi-live evi-archive evi-analyzer nginx

Preparation for installation

Perform the necessary preliminary steps as described in the Preparation for installation section.

Installing the ClickHouse database

Since the PostgreSQL database is already installed, the next step is to install ClickHouse: see the Installing the database section, item ClickHouse database.

Running the migration script

sudo bash migrate.sh <host> <user> <password> <psql_db_name_from> <psql_db_name_to> <psql_port> <ch_def_user_password> <ch_db_name>

• host — IP address of the host with PostgreSQL and ClickHouse;
• user — username for the database (will be created if necessary);
• password — user password;
• psql_db_name_from — name of the PostgreSQL database from which the migration is performing;
• psql_db_name_to — name of the PostgreSQL database to which the migration will be performed;
• psql_port — PostgreSQL port;
• ch_def_user_password —  password for the ClickHouse user;
• ch_db_name — name of the ClickHouse database to which the migration will be performed.

sudo bash migrate.sh localhost core core core core 5432 core core

After successfully executing the migration script, the message Restoring DB done <3 will appear in the console.

Then proceed to the Installing and configuring EVI services after migration section.