1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
| PGSQL_CONF_FILES='/home/pgsql/backup/temp/';
DATE=`date '+%F-%H'`h
DATE_OLD=`date '+%F-%H' --date '3 days ago'`h
#### FTP ####
FTP_HOST='XXXXXXXXXXXXXX'
FTP_PORT='21'
FTP_USER='public'
FTP_PASSWD='XXXXXXXX'
FTP_REP='AIMS-PGSQL_dump'
######################################################################################################
############################### LANCEMENT DU JOB #####################################################
### Backup des bases ###
mkdir $PGSQL_CONF_FILES
pg_dump intranet__meta > $PGSQL_CONF_FILES/save_intranet_meta.sql
pg_dump intranetOPTIC_qst > $PGSQL_CONF_FILES/save_intranet_qst.sql
pg_dump mironet_10 > $PGSQL_CONF_FILES/save_mironet_10.sql
pg_dump intranetSFR_mozaicom > $PGSQL_CONF_FILES/save_intranet_mozaicom.sql
pg_dump intranetSFR_lct > $PGSQL_CONF_FILES/save_intranet_lct.sql
pg_dump intranetSFR_mmobile > $PGSQL_CONF_FILES/save_intranet_mmobile.sql
pg_dump intranetSFR_dsm > $PGSQL_CONF_FILES/save_intranet_dsm.sql
pg_dump intranetSFR_model > $PGSQL_CONF_FILES/save_intranet_SFRmodel.sql
pg_dump intranetGED_inprint > $PGSQL_CONF_FILES/save_intranet_inprint.sql
pg_dump intranetGED_stms > $PGSQL_CONF_FILES/save_intranet_stms.sql
pg_dump intranetGED_model > $PGSQL_CONF_FILES/save_intranet_GEDmodel.sql
pg_dumpall > $PGSQL_CONF_FILES/save_pg_all.sql
#### Compression FINAL ##################################
echo "Compression pour fichier SQL QST"
tar -czf $PGSQL_CONF_FILES/$DATE-Backup-PGSQLQST.tar.gz $PGSQL_CONF_FILES/*
###Definition du fichier à uploader
FIC=$DATE-Backup-PGSQLQST.tar.gz
###Definition du fichier à supprimer
FIC_OLD=$DATE_OLD-Backup-PGSQLQST.tar.gz
#### Export par FTP #####################################
echo "Export FTP "
cd $PGSQL_CONF_FILES
echo "Sauvegarde Quotidienne"
lftp -u $FTP_USER,$FTP_PASSWD $FTP_HOST << END_SCRIPT
mkdir $FTP_REP
cd $FTP_REP
mput $FIC
rm -rf $FIC_OLD
quit
END_SCRIPT
#### Supression des fichier temporaire de compression #################
echo "Supression des fichiers temporaire de compression"
mv $FIC /home/pgsql/backup
rm -rf /home/pgsql/backup/$FIC_OLD
rm -rf $PGSQL_CONF_FILES
echo -e "\033[0;32mBackup terminée \033[0m"
################# FIN DU SCRIPT ####################################################################### |