postgreSQL 自动备份脚本

最新推荐文章于 2024-01-11 11:14:04 发布

hellyhe

最新推荐文章于 2024-01-11 11:14:04 发布

阅读量782

点赞数

分类专栏： postgreSQL

本文链接：https://blog.csdn.net/hellyhe/article/details/8309875

版权

postgreSQL 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

#echo "start backup database: postgres"
#${backup_command} -Fc postgres > ${backup_folder}${DATE}/postgres.${DATETIME}.bak

echo "Start backup time: $(date '+%Y-%m-%d %H:%M:%S')";

for loop in `/usr/local/bin/psql postgres -c "SELECT datname FROM pg_database;"`
do

FLAGSTR=`echo $loop | cut -c1-1`

if [ "'$loop'" = "'datname'" ]; then
continue;
elif
[ "'$loop'" = "'template0'" ]; then
continue;
elif
[ "'$FLAGSTR'" = "'-'" ]; then
continue;
elif
[ "'$FLAGSTR'" = "'('" ]; then
echo "backup complete";
exit 0;
else
echo "start backup database: $loop";
${backup_command} ${loop} > ${backup_folder}${DATE}/${loop}.${DATETIME}.bak;
fi
done