PG数据库定时逻辑备份脚本(适用linux)

ZhangQi

#!/bin/bash
  export PGPASSWORD=zltj2023!  
  cur_time=$(date '+%Y-%m-%d')
  echo "Starting Backup PostgreSQL ..."
   /home/postgresql/pg15/bin/pg_dumpall -h 127.0.0.1 -U postgres  -c  |gzip > /home/pgsql/backup/"pgsql-backup.$cur_time.dump.gz"
  echo "Finish Backup ..."
find /home/pgsql/backup/ -mtime +5 -name "pgsql-*" -exec rm -rf {} \;