Hi,
We are using vertica 8.0.1. We noticed that now INFO is enabled as default. We got several hundred MB log every day. We did
/opt/vertica/bin/adminTools -t logrotate -d ourdatabase -r daily -k 3 -s 10
But it still do daily rotate daily, with hundreds of MB. We are hoping to have log size under 10M.
We also did following, but did not reduce much logs. Is any way to limit the vertica.log to a very small size?
su dbadmin -c "/opt/vertica/bin/vsql -w dbadmin -c \"select clear_debug_log('TXN','INFO')\""
su dbadmin -c "/opt/vertica/bin/vsql -w dbadmin -c \"select clear_debug_log('SESSION','INFO')\""
su dbadmin -c "/opt/vertica/bin/vsql -w dbadmin -c \"select clear_debug_log('UTIL','INFO')\""
su dbadmin -c "/opt/vertica/bin/vsql -w dbadmin -c \"select clear_debug_log('EE','INFO')\""
su dbadmin -c "/opt/vertica/bin/vsql -w dbadmin -c \"select clear_debug_log('COMMAND','INFO')\""
su dbadmin -c "/opt/vertica/bin/vsql -w dbadmin -c \"alter database ourdatabase SET EnableDataCollector = 0\""
Thanks!
