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

The only supported postgresql version is 16.

Packages installation

# apt update && apt install postgresql-16 postgresql-contrib-16 postgresql-16-prefix postgresql-16-pgq3 postgresql-16-pgq-ext postgresql-16-yeti postgresql-16-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

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