清理 PostgreSQL 备份文件

clear_pg_dumps.rb

require 'date'

file_paths = Dir.glob("/BACKUP_DIR/*.dump")

file_paths.map! do |file_path|
  basename = File.basename(file_path, '.dump')
  key = Date.parse(basename)
  [key, file_path]
end.sort! do |a, b|
  a[0] <=> b[0]
end

# 保留最近 5 份
file_paths.pop 5

# 保留 01 和 15 号的备份文件
file_paths.each do |f_obj|
   d = f_obj[0].day
   File.delete(f_obj[1]) unless(d == 1 || d == 15)
end