PacketDescription
postgresql-17
The database is used in EVI services.
clickhouse-server
The database is used in EVI services.
clickhouse-client
Client for connecting to the ClickHouse database
libpq5
Library for interaction between EVI services and databases

Postgresql database

The minimum version of PostgreSQL is 17.

All services use one database to operate.

It is recommended to place the database next to evi-core and evi-scud.

To install PostgreSQL 17, it is necessary to run the following commands in the server terminal:

sudo apt-get install -y apt-transport-https ca-certificates curl gnupg
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget -qO - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo gpg --yes --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg
sudo apt update
sudo apt install -y postgresql-17

Creating a core database with the core user in PostgreSQL.

If you are migrating databases, this step is not applicable.

To create a database, run the following commands:

Create a database user
sudo -u postgres createuser --interactive

Enter name of role to add: core

Shall the new role be a superuser? (y/n) y

Switch to the postgres user
sudo -u postgres psql
Create a database named core
CREATE DATABASE core;
Change the core user's password to 'core'
ALTER USER core WITH PASSWORD 'core';
Allow the user core to have database administrator privileges
ALTER USER core WITH SUPERUSER;
Log out of the postgres user
\quit

ClickHouse database

To install ClickHouse, it is necessary to run the following commands in the server terminal:

sudo apt-get install -y apt-transport-https ca-certificates curl gnupg
curl -fsSL 'https://packages.clickhouse.com/rpm/lts/repodata/repomd.xml.key' | sudo gpg --dearmor -o /usr/share/keyrings/clickhouse-keyring.gpg
ARCH=$(dpkg --print-architecture)
echo "deb [signed-by=/usr/share/keyrings/clickhouse-keyring.gpg arch=${ARCH}] https://packages.clickhouse.com/deb stable main" | sudo tee /etc/apt/sources.list.d/clickhouse.list
sudo apt update

When installing clickhouse-server, a password will be requested for the default user (Set up the password for the default user).

The EVI documentation uses the default password core.

sudo apt-get install -y clickhouse-server clickhouse-client
sudo service clickhouse-server start

Creating a user named core with the password core in the ClickHouse database:

clickhouse-client --user=default --password=core --query="CREATE USER core IDENTIFIED WITH sha256_password BY 'core'" --query="GRANT CURRENT GRANTS on *.* TO core WITH GRANT OPTION"

Installing required dependencies

Each of the packets (evi-core, evi-scud, evi-live, evi-archive, evi-analyzer) requires the libpq5 packet (>= 17.2).

If services are installed on different servers, libpq5 must be installed on each of them.

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget -qO - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo gpg --yes --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg
sudo apt update
sudo apt install libpq5


  • Нет меток