General configuration for all backends

This chapter contains the common settings for the databases PostgreSQL® and MS SQL®.

This list of values are key/value pairs for the configuration of these settings. The names (keys) are predefined by the backend in backend profile - see configuration of the backend profile. The further chapters are database-specific for the three different databases InfluxDB®, PostgreSQL® and MS SQL®.

Figure 1. Database-specific Configuration - Example PostgreSQL®

Logger for PostgreSQL® and MS SQL®

  • logger.level - the level of the log messages that produce the backend. Possible values are "trace", "debug", and "info", "warn" and "error".

    The default value is "info".

  • logger.logProtobufMessages – Set this flag to 1 for logging protobuf messages from/to frontend.

    The default value is 0.

  • logger.logToStdOut - Set this flag to 1 for logging parameters of the DB queries.

    The default value is 0.

  • logger.logSql - Set this flag to 1 for logging SQL messages to DB. The default value is 0.

  • logger.logSqlBindedParameters - Set this flag to 1 for logging parameters of the DB queries. The default value is 0

Backend configuration for PostgreSQL® and MS SQL®

  • backend.readThreadsNumber - size of thread pool for reading threads.

    The default value is 50. The backend splits read requests according to archive groups of requested elements. Each read request for a given archive group performs in a separate thread. The size of the thread pool defines maximum threads that might be used simultaneously for handling read requests. If a value smaller than one is specified, the default value is used.

  • backend.writeThreadsNumber - size of thread pool for writing threads. The default value is 50. If a value smaller than one is specified, the default value is used.