Yeti Switch

Appearance

Routing database installation ​

::: note ::: title Note :::

We recommend placing routing database on the same host with management WEB interface for best performance and web interface responsiveness. :::

Supported versions ​

The only supported PostgreSQL version is 13.

Packages installation ​

# apt update && apt install postgresql-13 postgresql-contrib-13 postgresql-13-prefix postgresql-13-pgq3 postgresql-13-pgq-ext postgresql-13-yeti postgresql-13-pllua pgqd

Databases creation ​

Create routing database

# su - postgres
$ psql
postgres=# create user yeti encrypted password 'somepassword' superuser; 
CREATE ROLE 
postgres=# create database yeti owner yeti; 
CREATE DATABASE 
postgres=# \q

WARNING

::: title Warning

It's recommended to choose databases names, usernames and passwords different from specified in this manual for security reasons. :::

For large installations it's recommended to place CDR database on dedicated server.

Checks ​

Check if databases were successfully created and are accessible:

root@evial:/# psql -h 127.0.0.1 -U yeti -d yeti
Password for user yeti:  psql (9.4.5) SSL connection
(cipher: DHE-RSA-AES256-GCM-SHA384, bits: 256) 
Type "help" for help.

yeti=# \q
root@evial:/#

Don't forget to make changes in /etc/postgresql/13/main/pg_hba.conf and apply them if you plan to access this databases from other hosts and/or set up database replication

::: seealso Database tuning <database_tuning> :::