Previous Topic: Secure Data Repository (Optional)Next Topic: How to Set Up Automatic Backups of Data Repository (Single-Node and Cluster Installations)


Configure Log Rotation for Data Repository (Required)

To prevent the underlying vertica.log file from becoming too large, configure log rotation for Data Repository. The recommended configuration for the log rotation is a daily rotation with logs retained for 21 days.

Important! Configuring the log rotation is required because the underlying Data Repository log file (vertica.log) can grow substantially.

Follow these steps:

  1. Log in to the database server for Data Repository as the database administrator user. Type the following command:
    su - dradmin
    
  2. Type the following command:
    /opt/vertica/bin/admintools -t logrotate -d drdata -r daily -k 3
    

    Data Repository log rotation is now set up to occur daily, and only three weeks of log files are maintained.

    You can verify that the vertica.log rotation has been configured correctly. As the log rotation occurs, new gzipped vertica.log files appear in the Vertica catalog directory for previous days. These log files have filenames such as vertica.log.1.gz, vertica.log.2.gz, and so on, with vertica.log.1.gz being the most recent backup.

More Information:

How to Install CA Performance Management Data Aggregator – Installation Wizard

Install the Data Repository Component