pg数据库自动备份记录

#!/bin/bash
export PGPASSWORD='jRYruB$fM*4'
mkdir -p /opt/pgsql备份/$(date +"%Y‐%m‐%d")
for i in {'amdb','josdb','josdb_qy','amdb_collect','amdb_ljfs','amdb_sharesign','jointcloud42','jointdss42','jointmq42','postgres'}
do
pg_dump -h 10.64.195.3 -U postgres -p 5432 -d $i -f /opt/pgsql备份/$(date +"%Y‐%m‐%d")/$i.sql
done
sleep 5
scp -r -P 6635  /opt/pgsql备份/$(date +"%Y‐%m‐%d") root@10.64.195.252:/opt/pgsql备份/