Parameters

General

• Host: contains target IP address or database server hostname.
• Port: contains database server port (5432 by default).
• Database: contains name of the database.
• Schema: contains name of the schema.
• Table Prefix: contains prefix of the tables.
• Database Type: Specifies the type of the target TimescaleDB or PostgreSQL database. If TimescaleDB is specified, the store will set up an extension, create a hypertable, etc.
• Connection Timeout: contains the time interval (in milliseconds) within which the connection to the database should be established. If the connection is not established within the specified time, an error occurs.
• Request Timeout: contains time interval (in milliseconds) within which the response from the database server must be received. If the response is not received during the specified interval, an error occurs.
• Max. Buffer Size: contains maximum size of sample buffer for each time series that is accumulated in the server memory.  
• Wait after Write: contains timeout interval (in milliseconds) before the start of next data writing to the store.
• Wait after Error: contains timeout interval (in milliseconds) in case an error occurs during data writing or store preparation.
• Inter-request Interval: contains timeout interval (in milliseconds) before sending the next request. It is used if data doesn’t fit in one request.

Security

• Username: contains username.
• Password: contains password.
• Use SSL: specifies that it is necessary to verify database server SSL certificate.
• SSL Verification: contains verification mode of database server SSL certificate:

1. Accept any
2. Verify chain of trust by using a store of certificates of the operating system.
3. Verify chain of trust by using custom certificate of certification authority.

• Custom CA File:  contains custom certificate of certification authority.

Performance

• Series per Request: contains maximum number of time series that can be written per one request.
• Samples per Request: contains maximum number of samples for each time series that can be written per one request.
• Max. Buffer Size: contains maximum size of sample buffer for each time series that is accumulated in the server memory.
• Wait after Write: contains timeout interval (in milliseconds) before the start of next data writing to the store.
• Wait after Error: contains timeout interval (in milliseconds) in case an error occurs during data writing or store preparation.
• Inter-request Interval: contains timeout interval (in milliseconds) before sending the next request. It is used if data doesn’t fit in one request.

Advanced

• Add Server UID to Tag: specifies that for all store associated time series server UID will be added as su tag value (record metadata).
• Add Store UID to Tag: specifies that for all store associated time series store UID will be added as stu tag value (record metadata).
• Add Time Series UID to Tag: specifies that for all store associated time series time series UID will be added as tsu tag value (record metadata).
• Add Time Series Path to Tag: specifies that for all store associated time series string path to time series will be added as tsp tag value (record metadata).
• Add Time Series Comment to Tag: specifies that for all store associated time series comment to time series will be added as tsc tag value (record metadata).
• Use Server UID in ‘Hash’ Addresses: specifies that unique server identifier should be used to generate Hash addresses.

You can find more information about identifiers used in the server here.

• Database Auto-creation: if the parameter is set, database will be created automatically. If TimescaleDB is set as the database type, the TimescaleDB extension will also be automatically created.
• Schema Auto-creation: if the parameter is set, schema will be created automatically.
• Table Auto-creation: if the parameter is set, data and metadata tables will be created automatically. If TimescaleDB is set as the database type, hypertables will also be automatically created.
• Index Auto-creation: if the parameter is set, indexes for tables will be created automatically.

TimescaleDB

The parameters listed in this category are only used if the database type is set to TimescaleDB.

• Set Time Interval: if the parameter is set, upon creation of a hypertable it will automatically be assigned a time interval of the chunk equal to Time Interval.
• Time Interval: defines the data chunk interval in a hypertable.
• Automatic Deletion of Old Data: if the parameter is set, the drop_chunks() function will periodically be called.
• Call drop_chunks() Every: defines the period for calling the drop_chunks() function.
• Drop Data Older Than: Defines the time interval for holding data. Basically, represents the older_than argument of drop_chunks() function.