postgresql备份脚本

#!bin/bash
export PATH=$PATH:/app/db/pg/bin
PGDATA=/pgdata/data
PGUSER=postgres
DATABASE=postgres
PGPORT=19200
DATE=`date +%F`
backupDir=/pgdata/backup/databack
find $backupDir --maxdepth 1 -type d -mmin +20 -exec rm -rf {} \;
pg_basebackup -D $backupDir/$DATE -R -Ft -PV -z -Upostgres -p 19200