Data store Operational Documentation

The following operational document is provided to help with the initial configuration and settings that are required for Analytics to perform optimally.

Analytics Datastore is based on PostgreSQL, we recommend that you see the official documentation regarding managing the Datastore.

Main PostgreSQL Configuration File

The postgresql.conf file is located in the following directory:<Automic>/External.Resources/postgresql/data

Important! This file should be configured with caution.

Main Database Activity Log File

The pg_log file is located in the following directory: <Automic>/External.Resources/postgresql/data

Password File

For information regarding setting and editing passwords, see: https://www.postgresql.org/docs/current/static/libpq-pgpass.html

Access and Permissions

Analytics Datastore is based on PostgreSQL, we recommend that you see the official documentation regarding managing your database access and permissions. PostgreSQL use the concept of roles to define permissions.

For more information about Access and Permissions, see: https://www.postgresql.org/docs/current/static/user-manag.html

Data store Maintenance Task

For information regarding Database Maintenance Tasks, see: https://www.postgresql.org/docs/current/static/maintenance.html

Log File Maintenance

For information regarding Log File Maintenance, see: https://www.postgresql.org/docs/current/static/logfile-maintenance.html