hdp hadoop ambari pgserver backup

hdp hadoop ambari pgserver backup

大数据平台 HDP ambari  pgsql 的备份

#!/bin/bash

export PGPASSWORD=bigdata BACKUP_PATH=/var/lib/pgsql/backups LOG_FILE=/var/lib/pgsql/backups/pgbackup.log DATE=$( date +%Y_%m_%d_%k:%M:%S) remote_ip="test15" log(){LEVEL=$1INFO=$2     if [ ! -d /var/lib/pgsql/backups  ];then mkdir -p $BACKUP_PATHfitest -f $LOG_FILE || touch $LOG_FILEecho $LEVEL $( date +%Y_%m_%d_%k:%M:%S)  $ $INFO 2>&1 |tee -a $LOG_FILE   } backup1(){export PGPASSWORD=bigdatalog DEBUG "Begin back up pg "pg_dump -U ambari ambari -f $BACKUP_PATH/ambari_$DATE.sqlif [ $? -ne 0 ];then log ERROR "Begin back up pg Failed".return 1else if [ ! -f $BACKUP_PATH/ambari_$DATE.sql  ];then log ERROR "Back up pg Failed.[File $BACKUP_PATH/ambari_$DATE.sql is not exist. ]".return 1else size=$(du -s $BACKUP_PATH/ambari_$DATE.sql |awk '{print $1}' )                          echo $sizeif [ $size -lt  40000 ];then log ERROR "Back up pg Failed.[ du -s $BACKUP_PATH/ambari_$DATE.sql |awk '{print $1}' < 40000 ]".return 1fi fi fi log SUCCECC "Back up pg Failed.".return 0 } backup2(){export PGPASSWORD=mapredlog DEBUG "Begin back up pg mapred"pg_dump -U mapred ambarirca -f $BACKUP_PATH/ambarirca_$DATE.sqlif [ $? -ne 0 ];then log ERROR "Begin back up pg mapred Failed".return 1else if [ ! -f $BACKUP_PATH/ambarirca_$DATE.sql  ];then log ERROR "Back up pg Failed.[File $BACKUP_PATH/ambarirca_$DATE.sql is not exist. ]".return 1else size=$(du -s $BACKUP_PATH/ambarirca_$DATE.sql |awk '{print $1}' )                         echo $sizeif [ $size -lt 11 ];then log ERROR "Back up mapred pg Failed.[ du -s $BACKUP_PATH/ambarirca_$DATE.sql |awk '{print $1}' < 11 ]".return 1fi fi fi log SUCCECC "Back up mapred pg ."return 0 } traslate_sql(){FLAG="0"ssh root@$remote_ip "mkdir -p $BACKUP_PATH" scp $BACKUP_PATH/ambarirca_$DATE.sql   $BACKUP_PATH/ambari_$DATE.sql root@$remote_ip:$BACKUP_PATHvalue=$(ssh root@$remote_ip  "ls $BACKUP_PATH/ambarirca_$DATE.sql ")if [ "x$( echo $value  |grep $BACKUP_PATH/ambarirca_$DATE.sql )" = "x" ];then log ERROR "Back up mapred pg Failed.[ ssh root@$remote_ip  ls $BACKUP_PATH/ambarirca_$DATE.sql ]".FLAG="1"fi     value2=$(ssh root@$remote_ip  "ls  $BACKUP_PATH/ambari_$DATE.sql ")if [ "x$( echo $value2  |grep $BACKUP_PATH/ambari_$DATE.sql )" = "x" ];then log ERROR "Back up mapred pg Failed.[ ssh root@$remote_ip  ls  $BACKUP_PATH/ambari_$DATE.sql  ]".FLAG="2"fiif [ "x$FLAG" != "x0" ];then log ERROR "Back up remote hosts filed"else log INFO "Back up retmote host successed"fi } backup1 backup2 traslate_sql

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。