Routing database installation¶
We recommend placing routing database on the same host with management WEB interface for best performance and web interface responsiveness.
The only supported postgresql version is 11.
# apt update && apt install postgresql-11 postgresql-contrib-11 postgresql-11-prefix postgresql-11-pgq3 postgresql-11-pgq-ext postgresql-11-yeti pgqd
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
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.
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/11/main/pg_hba.conf and apply them if you plan to access this databases from other hosts and/or set up database replication