备份:
pg_dump -h 127.0.0.1 -p 5432 -U askdog -d askdog.web > /home/PGBackUp/askdog-$(date +%Y%m%d%H%M%S).sql #文件按天小时存储
#pg_dump -h 127.0.0.1 -p 5432 -U askdogsync -d askdogsync > /home/docker/backup/askdogsync-$(date +%Y%m%d%H%M%S).sql #文件按天小时存储
find /home/PGBackUp/ -type f -ctime +2 |xargs rm -rf #保留2天数据
恢复:
psql -h 127.0.0.1 -d askdog.web -U askdog --password < /home/docker/backup/askdog-$(date +%Y%m%d%H%M%S).sql
#psql -h 127.0.0.1 -d ask.dog.store -U store.dog --password < /home/docker/backup/askdogsync-$(date +%Y%m%d%H%M%S).sql