Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/postgres/bin:/usr/local/pgsql/bin
- BACKUP_DIR=/pg_backup
- DAYS_TO_KEEP=14
- FILE_SUFFIX=_pg_backup.sql
- DATABASE=
- USER=postgres
- FILE=`date +"%m-%d-%y"`${FILE_SUFFIX}
- OUTPUT_FILE=${BACKUP_DIR}/${FILE}
- # do the database backup (dump)
- # use this command for a database server on localhost. add other options if need be.
- pg_dump -U ${USER} ${DATABASE} -F p -f ${OUTPUT_FILE}
- # gzip the mysql database dump file
- gzip $OUTPUT_FILE
- # show the user the result
- echo "${OUTPUT_FILE}.gz was created:"
- ls -l ${OUTPUT_FILE}.gz
- # prune old backups
- find $BACKUP_DIR -maxdepth 1 -mtime +$DAYS_TO_KEEP -name "*${FILE_SUFFIX}.gz" -exec rm -rf '{}' ';'
Add Comment
Please, Sign In to add comment