#pgsql数据库备份  ckup_dir="/var/lib/postgresql/data/postgresql_backup/data"
# backup_file="testdb_$(date +%Y%m%d%H%M%S).sql"

# 定义数据库名和登录信息 --role $db_owner 
# db_host="127.0.0.1"
# db_port="5432"
# db_name="idea_fire_safety"
# db_owner="testuser"
# db_user="postgres"
# db_pass="idea@2024"

# 备份数据库
# pg_dump --file $backup_dir/$backup_file --host $db_host --port $db_port --username $db_user --dbname $db_name -c --format=c --blobs --encoding "UTF8"
# pg_dump $db_name -h 127.0.0.1 -U $db_user -p $db_port -C > $backup_dir/$backup_file

pg_dump idea_fire_safety_census -h 127.0.0.1 -U postgres -p 5432 -C > /var/lib/postgresql/data/postgresql_backup/data/pg_dump_$(date +%Y%m%d).sql

find /var/lib/postgresql/data/postgresql_backup/data/ -name "pg_dump_*.sql" -mtime +30 -delete