# 数据库备份脚本
#!/bin/bash

BACKUP_DIR="/backup/$(date +%Y%m%d)"
DB_NAME="myapp"
DB_USER="postgres"

echo "创建备份目录: $BACKUP_DIR"
mkdir -p $BACKUP_DIR

echo "备份数据库: $DB_NAME"
pg_dump -U $DB_USER -h localhost $DB_NAME > $BACKUP_DIR/database.sql

echo "压缩备份文件"
gzip $BACKUP_DIR/database.sql

echo "备份完成: $BACKUP_DIR/database.sql.gz"