postgresQL备份数据库shell

来源：互联网发布：steam数据扫号编辑：程序博客网时间：2024/05/30 02:25

原创作者：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

0 0