acl_tousu/doc/backup-db.sh

#!/bin/sh

echo "$(date) backup start"
export PGPASSWORD='gC5jP3oM1tQ8'
backup_dir=/data1/ts_acl_backup/$(date +%Y%m%d%H%M%S)
mkdir -p "${backup_dir}"
host='192.168.70.136'
port='9999'
username='ts_acl'
dbname='ts_acl'
jobs='32'
echo "pg_dump -h ${host} -p ${port} -U ${username} -d ${dbname} -v -O -Fd -j ${jobs} -Z9 -n sqmdb_rpt -T sqmdb_rpt.acl_operation_log -T sqmdb_rpt.acl_top_user_bak -T sqmdb_rpt.acl_verification_log -T sqmdb_rpt.sms_record -T sqmdb_rpt.sms_report -T sqmdb_rpt.sms_send_queue -f ${backup_dir}"
pg_dump -h "${host}" -p "${port}" -U "${username}" -d "${dbname}" -v -O -Fd -j "${jobs}" -Z9 -n sqmdb_rpt -T sqmdb_rpt.acl_operation_log -T sqmdb_rpt.acl_top_user_bak -T sqmdb_rpt.acl_verification_log -T sqmdb_rpt.sms_record -T sqmdb_rpt.sms_report -T sqmdb_rpt.sms_send_queue -f "${backup_dir}"
echo "$(date) backup end"