通过脚本实现 PostgreSQL 备份到 UCloud

week=$(date +%u)
day=$(date +%d)
month=$(date +%m)
year=$(date +%Y)

if [ "$day" -eq "1" ]; then
  target_dir="monthly-backup"
elif [ "$week" -eq "1" ]; then
  target_dir="weekly-backup"
else
  target_dir="daily-backup"
fi

pg_backupcluster 12 tanmer basebackup && \
        us3cli sync /var/backups/postgresql/12-tanmer/ us3://tanmer-backup/${target_dir}/pg-12-tanmer --storageclass "ARCHIVE" --config tanmer && \
        pg_backupcluster 12 tanmer expirebasebackups 0