Use this scenario if the update is performed on the same server where the system is already running.
Uploading and unpacking the migration archive
While in the ~/backup folder, run the following commands:
Uploading and unpacking the migration archive
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
Removal of all services with version 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
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.
Example of running
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.