CDR databases installation

Note

System requires two databases: one for routing and one for CDRs. Setting up different PostgreSQL instances is highly recommended to make replication possible.

Packages installation

CDRs databases require similar set of packages as routing database

# 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

Warning

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 cdr encrypted password 'somepassword' superuser;
CREATE ROLE
postgres=# create database cdr owner cdr;
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.

PGQd ticker

After initialization of CDR database you should run pgq ticker daemon(pgqd) on server with CDR database.

Create configuration file /etc/pgqd.ini

[pgqd]
base_connstr = host=127.0.0.1 port=5432 dbname=cdr user=cdr password=somepassword
initial_database = cdr
database_list = cdr
script = /usr/bin/pgqd
pidfile = /var/run/postgresql/pgqd.pid
ticker_max_count=1
ticker_max_lag=3
ticker_idle_period=360

Then you should start ticker:

# service pgqd start

Checks

Check if databases were successfully created and are accessible:

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

cdr=# \q
root@cdr-server:/#

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