Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- BACKUP_DIR="/backup-nas/backup-db/"
- PGHOST="localhost"
- PGUSER="postgres"
- PGPASSWORD="<enter password here>"
- SERVER_IP_ADDRESS=10.100.129.212
- BACKUP_LOCATION=/HosDB/backup/on2hour
- DATABASE_NAME=retailconnect
- export PGPASSWORD
- time=`date '+%d'-'%m'`
- echo "============================================================================================="
- echo "Start backup on " `date '+%X'-'%T' `
- echo "============================================================================================="
- pg_dump rc-nis -h $SERVER_IP_ADDRESS -U postgres -f /tmp/$DATABASE_NAME-$time.back -i
- PGPASSWORD=""
- export PGPASSWORD
- echo "============================================================================================="
- echo "Backup finished. Compression started at : " `date '+%X'`
- echo "============================================================================================="
- gzip -c /tmp/$DATABASE_NAME-$time.back > $BACKUP_LOCATION/$DATABASE_NAME-$time.gz
- rm -f /tmp/$DATABASE_NAME-$time.back
- rem Find the latest backup file, in case we already have more of them..
- find $BACKUP_LOCATION/ -mtime +1 -exec rm {} \;
- echo "============================================================================================="
- echo "Backup finished at : " `date '+%X'`
- echo "============================================================================================="
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement