Routing database installation

INFO

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-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

INFO

Read also Database tuning guide.