Routing database installation

Note

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

Supported versions

For Debian 8 you should install Postgresql version 9.4. For Debian 9 we supports Postgresql 10 as well.

Packages installation

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

or for Debian 9 and Postgresql 10:

# apt update && apt install postgresql-10 postgresql-10-prefix postgresql-10-pgq3 postgresql-10-pgq-ext postgresql-10-yeti pgqd

Warning

Since yeti-web version 1.6.0 it is important to install Postgresql from PGDG repository. See Repositories configuration for details

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

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/9.4/main/pg_hba.conf and apply them if you plan to access this databases from other hosts and/or set up database replication