I'm generating files daily named as my_file_YYYYMMDD.csv (for instance, my_file_20160406.csv, my_file_20160407.csv and so on).
I want logrotate to compress them daily and that it keep just the last 30 files.
The problem is that it's generating files as cisco_counters-20160406.csv.1.gz and they will never be removed.
How could I make logrotate compress my files, remove the .csv file and remove all compressed files older than 30 days?
Note: unfortunately I'm not allowed remove the date from my files.