Configure an external database

In PostgreSQL, run the following queries to create a user for ADQM Control to connect to an external database and a database owned by that user for use by ADQM Control services (the queries should be run under the default postgres user with superuser privileges):

CREATE ROLE <user_name> LOGIN PASSWORD '<user_password>';
CREATE DATABASE <database_name> OWNER <user_name>;

Connect to the created database under a superuser and load the following extensions:

CREATE EXTENSION IF NOT EXISTS timescaledb;
CREATE EXTENSION IF NOT EXISTS timescaledb_toolkit;
CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE EXTENSION IF NOT EXISTS pg_trgm;

To enable access to the <database_name> database from an ADQM Control host as the <user_name> user, add an entry like the following to the pg_hba.conf file on the PostgreSQL server side:

host <database_name> <user_name> <adqmc_host_address> trust

On the configuration page of the ADQM Control service, activate the Use external PostgreSQL server toggle and fill in parameters in the list that opens. The assignment of parameters is described in the Configuration parameters → ADQM Control → External PostgreSQL server section.

ADQM Control parameters for connecting to an external PostgreSQL database

Click Save to save the ADQM Control configuration.

Install the ADQM Control service using the Install service action or execute the Reconfigure and restart action for the ADQM Control service if it is already installed.