postgresQL备份数据库shell

原创作者：wonderful

#!/bin/bash

declare -a dbarray
declare -a dbusr
Date=`date +%Y%m%d`
CurTime=`date +%F%t%X`
BakDir='/var/lib/pgsql/9.3/backups/'
Psql='/usr/pgsql-9.3/bin/psql'
PgDump='/usr/pgsql-9.3/bin/pg_dump'
Log='/var/log/dbbak.log'
Port='5432'
Gzip='/bin/gzip'
Err=''
#DB array define
dbarray[1]='cd03,cd03'
dbarray[2]='cd03_mwa,cd03_mwa'
#dbarray[2]='cd03,cd03'
#Backup DB
for str in ${dbarray[@]};do
  dbusr=`echo $str | awk -F ',' '{print $1}'`
  db=`echo $str | awk -F ',' '{print $2}'`
  echo $CurTime" Backup DB $db Start..." >> "$Log"
  echo "$PgDump -U $dbusr -C -p $Port -h localhost $db |$Gzip > $BakDir$db$Date.gz" >> $Log
  #Redirct Error to Variable
  #Err="$($PgDump -U $dbusr -C -p $Port -h localhost -f "$BakDir$db$Date.dump" $db 2>&1 > /dev/null)"
  #Err="$($PgDump -U $dbusr -C -p $Port -h localhost $db |$Gzip > "$BakDir$db$Date.gz" 2>&1 > /dev/null)"
  Err="$($PgDump -U $dbusr -C -p $Port -h localhost $db |$Gzip -9 > "$BakDir$db$Date.gz")"
  Cnt=`echo $Err | wc -L`
  if [ "$Cnt" = 0 ]
  then
        EndTime=`date +%F%t%X`
        echo $EndTime" Backup DB $db End." >> "$Log"
  else
        echo $CurTime" Backup DB $db Failed." >> "$Log"
  fi
done

#delete file > 7 days
for DIR in "/var/lib/pgsql/9.3/backups"
do
        echo "/usr/bin/find $DIR -mtime +7 -exec rm {} \;" >> $Log
        /usr/bin/find $DIR -mtime +7 -exec rm {} \;
done