| Packet | Description |
|---|
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 install -y postgresql-17 |
Creating a core database with the core user in PostgreSQL.
To create a database, run the following commands:
sudo -u postgres createuser --interactive |
Enter name of role to add: core
Shall the new role be a superuser? (y/n) y
ALTER USER core WITH PASSWORD 'core'; |
ALTER USER core WITH SUPERUSER; |
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 |
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 |