# 启用归档模式
archive_mode = on
archive_command = ‘cp %p /postgresql/archive/%f’

# 2. 创建归档目录
$ mkdir -p /postgresql/archive
$ chown postgres:postgres /postgresql/archive

# 3. 重启PostgreSQL
$ systemctl restart postgresql

# 4. 执行全量备份
$ pg_basebackup -D /postgresql/backup/full -Ft -z -P -h fgedu.localhost -U postgres
pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
pg_basebackup: write-ahead log start point: 0/3000028 on timeline 1
pg_basebackup: starting background WAL receiver
pg_basebackup: created temporary replication slot “pg_basebackup_12345”
31300/31300 kB (100%), 1/1 tablespace
pg_basebackup: write-ahead log end point: 0/3000100
pg_basebackup: waiting for background process to finish streaming…
pg_basebackup: base backup completed

# 2. 备份所有数据库
$ pg_dumpall -h fgedu.localhost -U postgres -f /postgresql/backup/all_databases.sql

# 3. 备份表结构
$ pg_dump -h fgedu.localhost -U postgres -d fgedudb -s -f /postgresql/backup/schema.sql

# 4. 备份数据
$ pg_dump -h fgedu.localhost -U postgres -d fgedudb -a -f /postgresql/backup/data.sql

# 备份目录
BACKUP_DIR=”/postgresql/backup”
DATE=$(date +%Y-%m-%d)

# 创建备份目录
mkdir -p “$BACKUP_DIR/$DATE”

# 全量备份
echo “开始全量备份…”
pg_basebackup -D “$BACKUP_DIR/$DATE/full” -Ft -z -P -h fgedu.localhost -U postgres

# 清理过期备份（保留7天）
echo “清理过期备份…”
find “$BACKUP_DIR” -type d -mtime +7 -exec rm -rf {} \;

echo “备份完成！”

# 每天凌晨2点执行全量备份
0 2 * * * /postgresql/scripts/backup.sh >> /postgresql/logs/backup.log 2>&1

# 每小时执行WAL归档清理
0 * * * * find /postgresql/archive -type f -mtime +7 -exec rm {} \;