| 12345678910111213141516171819 |
- #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
|
